Submission Form's submission contingent on a Data Table

[Roderick]

Hi, how do I create a Submission Form where its submission is contingent on the data submitted by other users?

For example: 2 employees must insert in a form the time they clocked in and the time they clocked out, but they cannot work during the same interval.

How do I restrict the form based on the first user that submitted the information?

[MayMusic]

So basically if there is a clock in and it is not ye clocked out there should not be any new entry to this table. Is that correct? If that is correct, then you can have a details page which is filtered based on this table to pull the record that Clock out is blank and clock in is not blank. If there is any record that means someone if already working. You can add a message with for instance user name that this person is already working.

If there is no record then it means they can submit a new row. This is when this details page returns no records found. You can change this message in Localization and add a JS line to redirect user to submission page.

<script>window.location.href="SUBMISSION PAGE URL";</script>

apply this localization to your DataPage.

Authenticate your details page so user can login and use it as entry point. If they can submit they will be redirected to submission otherwise they see the details or no details of the open task but a message that says there is another open task.