Select option (A), Auto-fill option (B), (C), (D) from Excel

  • Profile Image
    Asked on December 11, 2017 at 03:40 PM


    Q.1 Select store location (free-form text field)

    Q.2 Street Address:

    Q.3 City:

    Q.4 Province:

    When user inserts "Store A" as store location, is it possible for Street Address, City, and Province to auto-populate based on an excel document (that contains a couple hundred stores)?

    Thanks for the help.

  • Profile Image
    Answered on December 11, 2017 at 04:47 PM

    Yes its possible. You can see a demo here:


    First you need to setup your form. You need:

    1. A drop down for the Store Location. Configure its options to include Store A to Store E.

    2. A long text entry for the street address

    3. A short text entry for the city

    4. A short text entry for the province.


    To insert the information based on a selection of the store. You need to setup 3 conditions for each location.

    For example:


    Then when you submit your form. Your submissions will record the populated fields:

    For example:


  • Profile Image
    Answered on December 11, 2017 at 04:59 PM

    Sorry for the confusion. I just noticed you want to populate your form from a spreadsheet right?

    Ok, that is also possible.

    Please read this guide:


    And get back to us if you require any further assistance.

  • Profile Image
    Answered on December 12, 2017 at 03:34 PM

    Hi aubreybourke,

    Thanks so much for your quick reply. I tried out the second method, and it worked! I'll definitely be putting this to good use.

    Thanks again.

  • Profile Image
    Answered on January 25, 2018 at 09:09 AM

    Hi aubreybourke,

    After more revisions, I discovered that the "Spreadsheet to Form" widget does not work when the fields that need to be auto-populated are required. I need the user to fill in Store Location (i.e. Store A), and if Store Location exists it will auto-populate. But if not, I need the Store to enter in their Store Location PLUS the Street Address, City etc, as these fields are mandatory.

    Can you help? It would be greatly appreciated.

  • Profile Image
    Answered on January 25, 2018 at 10:32 AM

    1) You could try requiring them through conditions.


    2) You could make your own warning message.

    Just use a text field and in red text you could say "Location is required!". You could also hide the submit button until all fields are filled.

    For example here is a demo:

  • Profile Image
    Answered on January 30, 2018 at 11:14 AM

    Thanks aubreybourke -- That did the trick.

  • Profile Image
    Answered on April 14, 2018 at 04:48 PM

    Hi JotForm,

    I found a bug with the "Speadsheet to Form" widget.

    My form is here:

    It appears that when the user goes back to edit their form via an "Edit Link" (see here:, the value for the input field disappears.

    This is very alarming. In my form, I have set up these options below:

    1523738457Screen Shot 2018-04-14 at 4.10

    1523738481Screen Shot 2018-04-14 at 4.11

    However, these fields don't seem to make a difference...A user can hit "submit" when the Input Field is empty, even though the field is required...In the back-end, when I check my submissions, the value is blank. Please help!

    1st time user fills in form:

    1523738789Screen Shot 2018-04-14 at 4.42

    1523738825Screen Shot 2018-04-14 at 4.44

    When user goes back to edit form:

    1523738756Screen Shot 2018-04-14 at 4.43

    1523738518Screen Shot 2018-04-14 at 4.37

  • Profile Image
    Answered on April 14, 2018 at 08:53 PM

    We have moved the issues into separate threads to be able to address them properly:

    The threads will be updated shortly.