Spreadsheet to Form Widget: Autocomplete Unique Code Field

Is there a way to populate the drop down list from column A (automatically)?I can't get it to work with tranlation, I guess it is because of the unique names and labels. Is there a way to do it correctly?

Hi Tzur_Farm,

Unfortunately, it is not possible to directly populate the autocomplete field from another field however we can achieve this using a workaround. Doing that is easy. Let me show you how:

• Add a Dropdown field and set the Options to the client's name which is also the unique code at the same time.

• Now add the below condition to your form to populate copy the Unique code from the Dropdown field to the Spreadsheet to form widget:

Now that we have the Unique code setup, the next thing we need is the Unique name of the dropdown field.

The URL format to prepopulate the field would be:

https://form.jotform.com/{FormID}?{UniqueName}={Option}

So the URL for the demo form would be:

https://form.jotform.com/221464543935964?selectA=unique1

Result:

Please give it a try and let us know how it goes.