Visitor Sign-In Sheet

MJB87

Hello,

I am trying to see if it is possible to create a visitor sign-in sheet with the time in and the time out in the same line. I already created a form with the logic where the visitor would manually enter in a time in. However, is there a way to enter in the time out on a separate form on the same line? I already tried with two separate forms and two separate qr forms, with each leading to the time out being entered in the subsequent row.

Paul Newcome

Using forms will always create a new row. I would suggest a separate form on a separate sheet, assigning some sort of unique ID to each visitor, then using an INDEX/MATCH to grab from the out sheet.