Hi, I am creating a check in & check out app for staff. I have a โCheck Inโ view (form view) for the staff to check in and submit. I would like to restrict the staff to check in once a day(submit the form once per day).
I have the following columns: Date, Staff ID, Name, Staff Email Address, Check In Status.
What expression can be used to do so and where should I input the expression?
Thank you.
Hi, thank you for the info.
Do you know how I can form the expression and where should I put my expression in the appsheet?
By using the expressions from the help articles I listed.
Thatโll depend on how your users access the Form to Add new records. One obvious spot would be the condition for the system-generated โAddโ Action for that Table. However there may be other ways that your users are adding records.
Hi Marc, I have put my expression under the โAddโ Action for the table.
The expression looks correct to me. Did you use the โTestโ button? Why/how is it not working?
This is the expression result after I have pressed on the โTestโ button. It is not working as I can still submit the form more than once for today.
Dunno man.
That expression should be useable in the base table access. Try inputting it here, make sure to read what this field expects to be returned (once you open the expression assistant) so you can add on to the expression appropriately.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |