Serial Number Data Validation

  • freedomhp
    Asked on December 19, 2020 at 3:54 PM

    Hi, i'd like to be able to validate the input of a field against an uploaded database of serial numbers. Is that possible?

  • John Support Team Lead
    Replied on December 19, 2020 at 5:04 PM

    If you mean you would like to use the form to query from an external database, unfortunately, it is not possible. One workaround that I can recommend is to use the Spreadsheet to Form widget. It allows you to upload your spreadsheet (where the serial numbers are stored) to your form and use the values you have on the spreadsheet to pre-populate your form.

    By using a unique code (in your case, the serial numbers) that is present on every row of your spreadsheet, you can access that specific row that matches the unique code.

    The values are automatically populated on your form fields, as long as the spreadsheet column headings match your form field labels.

    Here's a guide on how-to-use-the-spreadsheet-to-form-widget.