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

[NOORFIRDAUS_AB1]

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.

[Steve]

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.

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

help.appsheet.com

UX View Type: Form

Use our most popular view to digitize your processes

[NOORFIRDAUS_AB1]

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.

[Steve]

[Eduardo_dos_San]

I would try to work with a Changecount column

value 1 - enables the clock-in time

value 2 - enable clock-out time.

[NOORFIRDAUS_AB1]

Can you explain more about it.

[Eduardo_dos_San]

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