Construction CoVid Screening and Control

Elevator pitch? Not in the era of Covid!, We take the stairs.No stairs available? Our "Construction CoVid Screening and Control" application can help you regain control of the elevator.

Comment

Inspiration

Having worked with companies in the Constructions and Manufacturing industry for multiple years, we have been able to see how over the past year these companies have struggled to maintain productivity while adhering to all the existing safety regulations recently put in place due to CoVid-19. This gave us the idea of building an app that would help them meet these safety regulations while making use of terminology that will be familiar to anyone within the industry, therefore making it an easy fit into their workflows.

What it does

The Main QuickBase app has the following functionality: *Track positive CoVid-19 test results from employees and use this information to determine who else could be at risk of having contracted CoVid-19. *Creation of Purchase Order records that can be downloaded by using Exact Forms and sent to companies that provide healthcare equipment. The supporting Android App has the following functionality: *Display Covid-19 related information based on the geographical location of the user. *Creation of Purchase Orders the same way as the QuickBase app.

How I built it

Combining our knowledge of the everyday needs of Construction and Manufacturing companies, and their more recent challenges due to the CoVid-19 pandemic. We built the app with a similar structure to other apps we’ve built in the past, but this time with a focus on Purchase Orders, which are meant to be the main selling point on this solution.

Challenges I ran into

*We couldn’t find a CoVid-19 data set that would show nationwide information for the data we wanted to obtain, only state by state data sets that needed to be queried independently, which required a lot more effort. *It was difficult to find specific data sets about the total cases, deaths, and recoveries by counties. Most data sets were outdated or had data about global cases. *Also, we had problems processing some data sets because they were found as documents with .csv extensions located in a repository, which was harder for us to work with.

Accomplishments that I'm proud of

*We worked on a tight schedule and managed to build an app that meets what we had envisioned as a first version of the solution that can easily be expanded upon. *We managed to turn this hackathon into a great learning experience for our team.

What I learned

Part of the reason why we decided to make a submission for the hackathon was to use this as an opportunity for our team members to learn about things that they don’t usually get a chance to work with, for instance, getting our least QuickBase-familiar team members to make the QuickBase side of the solution. With that in mind, here are some of the things we learned: *Learned a few new tricks in Android development, both in logic and graphical user interface building. *Learned about the aspects of working with external datasets, in this case related with Covid-19 data. *Learned about the advantages of using tool like maps on QuickBase in order to present data in more easily digestible ways. *Learned about the flexibility QuickBase allows when relating data from different tables and creating complex and useful reports.

What's next for Construction CoVid Screening and Control

Our App’s current functionality can be greatly expanded if we can find better data sets (More complete ones), and then it can be generalized to be an app that allows you to meet the general healthcare needs of companies for their job sites. (Not covid-19 specific).

Share this project:

Updates