Referencing data to auto populate

  • lifemovesmt
    Asked on November 8, 2019 at 2:34 PM

    Hello,

    I am trying out the free to see if JotForm meets my needs before upgrading to at least Silver. Is it possible to upload a .csv file and set conditions so that when one field is entered, others auto populate?

    For instance, if the Client ID number is entered, the Client's name would autopopulate.

    Thank you for your help,

    Amanda

  • Elton Support Team Lead
    Replied on November 8, 2019 at 6:22 PM

    Hi Amanda,

    That's possible using this widget https://www.jotform.com/widgets/spreadsheet-to-form. You will have to upload a spreadsheet file containing the data including the client ID number in a separate column that will be used as the access code for the population.

    Here's the full instruction: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Demo:  https://form.jotform.com/71500914392957