You are viewing limited content. For full access, please sign in.

Question

Question

Stop duplicate form submissions?

asked on March 3, 2021 Show version history

Is there a way to create a dynamic look up or similar for previously submitted forms to keep certain data from being entered twice?

For example, if someone enters a form with 1234 Main St., Anywhere US 12345 on a submission, and then someone else tries to enter the same address on another form, the second user would be shown a message that the address has already been used.

I realize that if one user enters "Main St." and another enters "Main Street" they would be able to submit, but looking to cut down on as many duplicates as possible before they are submitted. 

0 0

Replies

replied on March 4, 2021

If you store that info in a database table, you could have your address field do a lookup on that table.

0 0
replied on March 11, 2021

Thanks Craig. Would I need to save to a database other than Laserfiche? I ask because I had assumed data saved to the repo could be searched and compared since I'm able to pull information in reports.

0 0
replied on March 11, 2021

The method I was describing would be using a separate SQL Database table that your process has access to and uses for field lookups.  

A workflow service task in your Forms business process diagram would use the tokens from the forms fields and then insert them into the SQL table if if is a new address.

 

1 0
replied on March 11, 2021

Thanks for the reply Craig. Seems like this should be something that LF can natively do. Maybe some day!

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.