Referencing data to auto populate

  • Profile Image
    lifemovesmt
    Asked on November 08, 2019 at 02: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

  • Profile Image
    EltonCris
    Answered on November 08, 2019 at 06: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