Serial Number Data Validation

  • Profile Image
    freedomhp
    Asked on December 19, 2020 at 03: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?

  • Profile Image
    JohnRex
    Answered on December 19, 2020 at 05: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.