Clock-in and Clock-out for Attendance in the same row

Hi everyone,
Is there any possible way to create attendance form that contain clock-in time and clock-out time in the same row.

Scenario:

  1. The worker scan QR Code to record clock-in time.
  2. Then after finish the job, the worker again scan QR Code on the same Form to record clock-out time.

Note: After Scan the QR Code, the form recall back the previous clock-in time data and update clock-out time.

I hope you can understand my explaination. Thank you.

It’s certainly possible. You’ll probably want to use slices to create the clock-in and clock-out versions of the row, create separate form views for each, and set the Finish view of the clock-in view to the clock-out form view.


I’m sorry. I don’t really understand what do you mean by Finish view of the clock-in view to the clock-out form view. Can you explain about it. Thank you.

I would try to work with a Changecount column

value 1 - enables the clock-in time

value 2 - enable clock-out time.

Can you explain more about it.

Don’t forget to tag QRcode in “The columns to watch for changes.” count column