Spreadsheet to Form Widget: How to validate a field from external source?

  • Profile Image
    Pascal 
    Asked on March 22, 2021 at 06:49 AM

    Hi,

    I'm looking to build a form with rather advanced field validation.

    To explain simply, there would be a field in which the user enters a code that needs to be validated based on an external data source.

    The form should only be submitable if the code entered in this field is contained in the third party table. (Note that this table is constantly updated with new codes and the user should not be able to see its content. )

    According to my current understanding, this is not possible with JotForm. Is there any other way to achieve this? (Something with an API call or Webhooks triggered when entering the code in a field maybe?)

    Thank you in advance for your help.

    Best regards

  • Profile Image
    Zahra_S
    Answered on March 22, 2021 at 08:38 AM

    Hello Pascal,

    Thank you for reaching out to us.

    We have a spreadsheet to form widget that allows you to achieve this. You can upload a spreadsheet that will act as a database. When the user enters a code, and if it is in the spreadsheet, then that row's data will be auto-filled in the form fields. However, it doesn't have the functionality to auto-update the file. You will have to manually upload the new spreadsheet whenever it needs to be updated.

    Guide: how-to-use-the-spreadsheet-to-form-widget

    If this doesn't work for you, you can contact our API team at api@jotform.com. Here's our API documentation: https://api.jotform.com/docs/.

    I hope this helps. Please let us know if you need further assistance.