Creating a Site Check in and out form with Visual report of users that are still to check out at any given time

Afternoon team,

I would like to create a site check in and check out form ideally using a QR code to prompt the user to fill the form on the way into and out of a work site.

Fields while entering site would be things like
Name,
Phone number,
Company,
Vehicle type (Ute, Van, Truck)
Whether they have complete a site induction or not.
and signature

This could e a single form used and based on whether they are checking in or out the required fields would change.
If two forms were required I'd like to look into using a Jotform app containing both forms which the user would view when scanning the QR code

I am happy with creating the forms and the app itself which is accessible via a QR code what I am struggling with is a kind of visual for the security or H&S staff to check.
Would love a visual report or list of users that are checked in but have yet to check out (At the time the report is viewed)
This would track who is still on site in the case of an evacuation or other emergency situation.

Tank you

Hi Pete,

Thanks for reaching out to Jotform Support. I9m an AI assistant here to assist you.

Let me help you with creating a site check-in and check-out form with a visual report for users still checked in.

To achieve this, you can use Jotform's Report Builder to generate visual reports based on your form submission data. This will allow your security or H&S staff to see a live list or visual representation of users who have checked in but not yet checked out, which is crucial for emergency situations.

Here9s how to do it:

1. Create your check-in and check-out form(s) with the fields you mentioned: Name, Phone number, Company, Vehicle type, Site induction status, and Signature.
2. Use conditional logic to show or hide fields based on whether the user is checking in or out if you want to use a single form.
3. Generate a visual report using Jotform Report Builder that filters submissions to show only users currently checked in (those who have checked in but not checked out).
4. Share the report with your security or H&S staff so they can view the live status of who is still on site.

This setup will allow you to use a QR code to prompt users to fill the form on entry and exit, and your staff will have a clear visual of who remains on site.

Give it a try and let us know how it goes.

How is this part done please?

"Generate a visual report using Jotform Report Builder that filters submissions to show only users currently checked in (those who have checked in but not checked out)."

Hi Pete,

Thanks for your follow-up question.

To generate a visual report in Jotform Report Builder that filters submissions to show only users currently checked in (those who have checked in but not checked out), you can use the Advanced Filters feature in the Visual Report Builder.

Here9s how to do it:

1. Open Visual Report Builder for your form.
2. Click on the Filter button next to the search bar on the upper-left side.
3. Go to Advanced Filters in the Filter box.
4. Add a new filter condition that checks the field indicating check-out status (for example, "Check-out" field) and set the condition to filter submissions where this field is empty or not filled (meaning the user has not checked out yet).
5. Apply the filter to see only the users who are still checked in.

This way, your report will dynamically show only those users who have checked in but have not yet checked out, providing a live view of who is still on site.

Give it a try and let us know how it goes.