{"id":605,"date":"2020-05-21T23:41:46","date_gmt":"2020-05-21T11:41:46","guid":{"rendered":"https:\/\/www.jgi.geek.nz\/?p=605"},"modified":"2020-12-17T20:09:27","modified_gmt":"2020-12-17T07:09:27","slug":"create-a-simple-covid-19-contact-tracing-register-for-your-school","status":"publish","type":"post","link":"https:\/\/www.jgi.geek.nz\/?p=605","title":{"rendered":"Forms: Create a simple COVID-19 contact tracing register for your school"},"content":{"rendered":"\n

At school we have a dedicated tablet for visitors with the Vistab<\/a> software – a fantastic visitor management tool. We asked, they kindly obliged, if the COVID-19 contact tracing questions could be added to their software.<\/p>\n\n\n\n

In order to capture this they reset all visitor and contractor information so as to make each one a \u2018new person\u2019 for their next sign in event (this is to capture the required information for Level 2 lock down). <\/p>\n\n\n\n

\"Bitmoji<\/figure><\/div>\n\n\n\n

It worked really well while it was just staff onsite. However, on Monday, when school reopened it was a different story. It was painful to watch, and it took everyone a long time to sign in. Meaning we had a real problem with a bottleneck of people trying to sign in, both parents & staff at the office. Right where we didn\u2019t want it. <\/p>\n\n\n\n

Safe physical distancing became a nightmare as most parents needed help navigating the screens.<\/p>\n\n\n\n

So, I had to come up with a solution, fast.<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>
\n

Below is a simple workflow using Google Forms, Sheets & Docs to create a simple QR code.<\/p>\n<\/div><\/div>\n\n\n\n

Note we are using this just for parents, we already have their contact details stored in our student management system.<\/p>\n\n\n\n

The form asks for their email for both sign & sign out, this is in order to be able match their data (each time a form is submitted it creates a new line in the response sheet) if you want to use a vlookup formula, or similar, to take it one step further and analyse how long someone was onsite there must be at least one cell with the same data to use for matching functions.<\/p>\n\n\n\n

Pros <\/strong>– it is really fast.<\/p>\n\n\n\n

Cons<\/strong> <\/p>\n\n\n\n