How do I verify if a data was already submitted to the Form?

To Whom It May Concern,

Our form asks people to upload a cheque with a corresponding number. I am finding it difficult to identify which cheque's have been redeemed and which ones have not. Is there a way we can block cheque numbers that have already been entered in the form?

Kind Regards,

Emily Lynch 

You can use the Spreadsheet to Form widget in your Form which will help you to check if the entered check already submitted or not. If the entered check is the same then you can hide the submit button and show a text message to the user.

https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

In the Spreadsheet to Form widget, you need to attach the submissions Excel. You can download and customize the Excel sheet to attach to the widget.

Let us know if this was helpful.

thanks.

Also, you can implement the Unique question feature.

Guide: https://www.jotform.com/help/223-How-to-set-Form-Limits-Based-on-a-Unique-Question

If you want to always receive a unique check number then you can follow the above guide to implement the unique question feature.

Whenever a user enters a duplicate check number he would not be able to submit the form and a message would be shown.

Thanks.