Jump to content
  • 0

Submission Form's submission contingent on a Data Table



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?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...