Question

Check for duplicate submission in forms

Forms

Updated April 23

asked on April 22

I have a requirement where I need to restrict duplicate form submissions. If same person is submitting the form multiple times, I need to catch that. What is the best way to implement that?

0 0

Replies

replied on April 22

Save a record of the process ID and the initiator ID to a SQL table. Within the form, perform a lookup on that table based upon the process ID and initiator ID, which will display a warning (custom HTML) and disable the submit button if a row is found.

1 0

replied on April 22

Will try that, thank you.

0 0

replied on April 23

I'd recommend tossing one more field into the DB to help you gate the submissions. For example last submission date so you can calculate one submission per month/quarter/etc.

0 0

replied on April 23

Thanks.

0 0

replied on April 23

I do wish that for licensed users there was an option in the Forms Process options to only allow one response per person. Microsoft Forms has a similar option:

1 0

replied on April 23

yes, that will be nice.

0 0

replied on April 22

Are these licensed users?

0 0

replied on April 22

yes.

0 0

You are not allowed to follow up in this post.

Question

Question

Check for duplicate submission in forms

Replies

Sign in to reply to this post.