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

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.

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:

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

For example:

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.

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.

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.

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

Thanks aubreybourke -- That did the trick.

1st time user fills in form:

When user goes back to edit form:

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.