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

  • Profile Image
    Employeerelations
    Asked on July 31, 2019 at 09:16 PM

    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 


  • Profile Image
    roneet
    Answered on July 31, 2019 at 11:12 PM

    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.

  • Profile Image
    roneet
    Answered on July 31, 2019 at 11:15 PM

    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.