How to autofill the other fields using the Spreadsheet to Form widget

Hi Team,

In this form https://www.jotform.com/build/251112450227039

I have a dropdown. If i select any currency from dropdown i need to auto fill my text fields from the matching value in the spreadsheet.

Is there any possibility to do.

Hi landmarkgroup.

Thanks for reaching out to Jotform Support. I'll need some time to look into this. I'll get back to you as soon as I can.

We appreciate your patience and understanding.

Hi landmarkgroup.

Let me show you how to use the Spreadsheet to Form widget:

First create a spreadsheet that has the same column name with the field label in your form, like the one below:

Let's now upload the spreadsheet to the Spreadsheet to Form widget:

1. In Form Builder, click on the Wand icon of the Spreadsheet to Form widget.
2. From the General tab, upload the spreadsheet.
3. Select Currency as the Access code column.
4. Scroll down your mouse and select Yes from Autofill By Condition.
5. If you don't want the Spreadsheet to Form widget to be visible in your form, select Yes from Run in the background.
6. Click on Update at the bottom of the page.

 Let's now set up an Update/Calculate Field condition:

1. In Form Builder, click on Settings on the orange navigation bar at the top of the page.
2. Select Conditions from the left side window.
3. Select Update/Calculate Field.
4. Set up the condition like the one below and click on Save at the bottom of the page.

Here's the result:

To learn more, you can check out our guide on How to Use Spreadsheet to Form Widget

Let us know if you have any other questions.

Hi I have done the same thing but once the the data is populated the first dropdown is becoming empty

can you help me to resolve this

Hi landmarkgroup.

I'll need another time to look into this. I'll get back to you shortly.

Thanks for your patience and understanding, we appreciate it.

Hi landmarkgroup,

When I checked your form, I had the same issue. But when I cloned it again and applied the value to be passed on to the other fields, I couldn't replicate the issue. Check out my screencast below:

Can you try to delete the Spreadsheet to Form widget and add it back? Let me show you how to do this:

1. In Form Builder, click on the Trash can icon of the Spreadsheet to Form widget.
2. Click on Add Element on the left side of the page.
3. From the Widgets tab, search for Spreadsheet to Form and set it up again.
4. Fix the conditions and adjust it accordingly, like the one below:

Give it a try and let us know how it goes.

I am still getting the same issue

Hi landmarkgroup,

Can you try to remove the condition and add it back? Let me show you how to do this:

1. In Form Builder, click on Settings on the orange navigation bar at the top of the page.
2. Select Conditions from the left side window.
3. Click on the Gear icon of the current condition and select Delete.
4. Set up the Update/Calculate Field condition below:

Keep us updated and let us know how it goes.

still same issue

Hi landmarkgroup,

I'll need some time to look into this. I'll get back to you shortly.

We appreciate your patience and understanding.

Hi landmarkgroup,

Do you have a column in your spreadsheet that has the name 'Currency'? I've made a sample, and the issue is replicable after adding Currency as one of the columns on my spreadsheet. Check out my screenshot below for reference:

If yes, can you try changing the field label of your Currency field, like the one below?Here's the result:

Reach out again if you need any other help.