How to restrict only 1 form submission per user

Unknown

How to restrict only 1 form submission per user

Unknown

Hello,
We are working on a project to create a flow for employee termination. One of the requirement is to submit only 1 request for a given employee. If there exists an active termination request, dont allow submitter to proceed further. (ignore any termination requests for that employee those were closed/cancelled due to rehire+reterminate or hire+terminate+cancel termination). What is the best course of action to accomplish this?

Unknown

One option you could do would be to just point a query or report at your assignment table and then filter the results down to the user email or name. Once you parse that out you can push it through a simple rule that looks at whether or not an assignment has the name, for example, "termination" and the status = active. If this rule is true, then push them to an end form that says there is already an active submission. If its false, then you can allow them to continue with the process.

You could also look at using a truth table to exhibit this same behavior, where your columns would be employee name, assignment status = active and then push it through the same logic as listed above.

Thanks