As we know, we can clock in our time directly by refering ‘Time Clock’. But i found that we can clock in more than one times at the same times. For example, i clock in at 9.00am, and i havent clock out yet, then, i still can clock in at 9.01am. Means that i can clock in many times at the same time. How can i solve it?
HI @Warren_Wong
Welcome to the community !
I assume you are talking about the Timesheet Tracker Sample App ?
If so, you have to keep in mind that the “Clock In” View is a form view type.
You may want not to display that view with a show_if condition, if one has been clocked in yet.
For example:
ISBLANK(
FILTER("Timesheet",
AND([Name]=USEREMAIL(),
ISBLANK([Date/Time Out])
)
)
)
Here, what I literally achieve this way is:
Then, if it’s empty, that means: “I did not clock in yet, so it’s OK to clock in now”.
And then, it’s OK to allow the user to see that view.
You will want to use this expression here:
Please see also:
Let us know if that works for you !
Cheers
Hi, I have similiar problem and i did the above mentioned query but still its not working.
There's two ways to think of solving this issue.
When choosing between the two approaches, the data level constraints are tighter and less prone to error. So usually, I prefer that. But also, they are less forgiving in case there is a need to correct wrong entries via the app.
Thanks Prave but iam not getting.Can you tell me step by step where should i go and do these steps.
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |