Clock in and out for workers

Ask for Help
1

Trying to make clock in and out for workers.
I have read other peoples help topics but cannot come right Whatever I try Clock in and Clock out goes to two lines. Guess I don’t understand to well explanations so sorry .

Nav
Nav1171×607 52.2 KB

Users
Users1437×269 35 KB

timesheet
timesheet1173×243 37.2 KB

My basic start. Thanks in advance for any help

2

  • Create a query in the Users table, target the Timesheet table, filter by user email is signed-in user, and “Clock In” is within today.

  • Add a single value column on top of the query, choose “Whole row” & first.

  • Add another single value column on top of the query, choose “Clock Out” & first.

  • If the query is empty, show the Clock in button, which should add a row with the signed-in user’s email and write the current date/time to the “Clock In” column.

  • If the query is not empty AND the single value > Clock Out value is empty, show the “Clock Out” button, which use a set column action, set the current date/time to the “Clock Out” column of the single value > whole row thing.

  • Once it’s done for the day, no buttons should be shown.

3

Created this very app before. Can you share what the actions are on your buttons?

4

Check this, could possibly help and inspire

5

There has to be a relation ship between the users table to the timesheets table to grab the last timesheet entry of that user.

If the last entry is Open (Clock out is empty). then the action of clock out would edit the row and set the clock out time.

If the last entry is Closed (Clockout is not empty). then you add a new row with the clock in value.

There are way other conditions you can do if you want to make this complicated…
Make sure you are using different actions for Clock in and Clock out.

6

Thank You so much for Your reply.
Followed all steps but Sadly think I don’t understand something. [ Feeling stupid already.
( * If the query is empty, show the Clock in button, which should add a row with the signed-in user’s email and write the current date/time to the “Clock In” column. )

7

Here’s a recording for you.

8

Thank You so much, Your Video explained to me what needs to be done, and I got it working

1 Like
9

I want to thank everyone who has offered their help and guided me, So nice to have a community that wants to help.

1 Like
10

Great to hear it’s working for you!