Appsheet Timesheet Tracker user can clock in multiple times

[vanquerubin]

I recently copied the template in the timesheet tracker and found out that each user can clock in multiple times. How do i prevent each user to clock in multiple times if they still have an existing clock in and has not clocked in yet.  Thank you in advance!

[AleksiAlkio]

If they are two separate rows in your Timesheet table, one way is to create your key column with a initial value something like USEREMAIL()&TEXT(TODAY(),"mmddyyyy")&[Type]. With this way the employee is able to fill the "IN" our "OUT" record only once in a day.

[vanquerubin]

Heres a screenshot of my tables

[vanquerubin]

Name in the Timesheet table using Ref pointing to Employee name.

[AleksiAlkio]

Then you could write it like [Name]&TEXT([Date/Time IN],"MMDDYYYY") and then the employee is able to add only one record per day.

[vanquerubin]

I want my app to determine that if he has still existing clock out he wont be able to clock out again unless he clock in, he can now clock out again.

[AleksiAlkio]

Do you want the employee can log in & out multiple times per day?

[vanquerubin]

I mean i want to prevent them double clock out like if they still have an existing clock out they wont be able to clock out again unless they clock in pls see my attached ss. I want to prevent the user to clock out more than 1 but if they clock in they can clock out again. This is for the noon break app.

[AleksiAlkio]

So.. employees are able to login/logout more than once in a day and for that reason you want to prevent them to fill out login before the logout is updated. Is my assumption correct?

[vanquerubin]

Yes exactly. I dont want them to double clock out unless they clock in they can clock out again.

[Steve]

Use an Only if this condition is true expression for the Add action of the Timesheet table to disable the action if the user already has an open timesheet.

Similarly, use an Only if this condition is true expression for the Edit action of the Timesheet table to disable the action if the the timesheet is already closed.

[vanquerubin]

Im basically new to this appsheet. Where should i add the expression.

[Steve]

---

@Steve wrote:

Use an Only if this condition is true expression for the Add action of the Timesheet table

---