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

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

    Scenario:

    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
    aubreybourke
    Answered on December 11, 2017 at 04:47 PM

    Yes its possible. You can see a demo here:

    https://form.jotform.com/73446644746971

     

    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:

    15130285948.jpg

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

    For example:

    15130287759.jpg

  • Profile Image
    aubreybourke
    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:

    How-to-Use-the-Spreadsheet-to-Form-Widget

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

  • Profile Image
    sstrawbridge
    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
    sstrawbridge
    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
    aubreybourke
    Answered on January 25, 2018 at 10:32 AM

    1) You could try requiring them through conditions.

    How-to-Make-a-Field-Required-Based-on-User-s-Answer 

    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:

    https://form.jotform.com/80243921036954



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

    Thanks aubreybourke -- That did the trick.

  • Profile Image
    sstrawbridge
    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:

    https://form.jotform.com/80996047363264

    It appears that when the user goes back to edit their form via an "Edit Link" (see here: https://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date), 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
    Mike
    Answered on April 14, 2018 at 08:53 PM

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

    https://www.jotform.com/answers/1444957

    https://www.jotform.com/answers/1444958

    The threads will be updated shortly.