Juiced Technologies Covid-19 Tracker

Inspiration

In light of current events, we decided to solve the current problem relating to Covid-19.

What it does

Our app is designed to create schedules for employees in a construction company. In addition to this, it notifies the employees if they have been in contact with another employee who has tested positive.

How we built it

We created a workflow using a Quick Base app, APIs, Automations, and Pipelines. On the Employees table, there is a button called “Mark Employee as Tested Positive” that will trigger a process. This process starts out by checking a check box in that employee record marking them as having tested positive. Then an automation runs that updates a checkbox in each Sign In/Out record of that employee to mark them as tested positive. When the Sign In/Out record is checked, a pipeline runs that compares the other employees’ Sign Ins/Outs to see if they were at the same location at the same time within the last two weeks. If an employee meets this criterion, they will be sent an email letting them know that they must quarantine for two weeks. The email will also include a link that will show them a list of testing sites in New York City where they can get tested. The pipeline that compares the employee’s sign ins and outs runs in two parts. The first half of the pipeline works where it compares the sign in and sign out of each day in the past two weeks to see if the sign in or sign out of another employee falls between those times. The second half of the pipeline then compares the rest of the sign ins and sign outs to see if the employee who tested positive signed in or signed out during that time. The pipeline also checks the task that is related to that sign in and sign out to see if the two employees have been in the same location. This will cover every way that two employees can come in contact with each other.

Challenges we ran into

While working on the Hackathon, we faced the following challenges: 1) Making sure that the pipeline was configured properly to the correct specifications so that we got the desired output. 2) Figuring out what to send to an employee who now needs to quarantine. 3) Configuring the app structure to create an easy and meaningful flow. 4) To differentiate when to use pipelines or automations.

Accomplishments that we're proud of

Taking part in the 2020 Quick Base Hackathon gave us an opportunity to dive deep into the inner workings of Pipelines. It also gave us the opportunity to potentially help other companies during the Covid-19 pandemic.

What we learned

We learned about the vast capabilities of using Pipelines to compliment our Quick Base application.

What's next for Juiced Technologies Covid-19 Tracker

To suggest to our clients the capabilities and flexibility that Quick Base brings to everyday business problems. In our case it helped us solve a real world issue by helping us track and inform employees about potential Covid-19 exposures.

Built With

• apis
• automations
• pipelines