Dropdown Input Affect 2nd Dropdown Field

Queries and Resources
,
1

Hello,

We're trying to run a function that looks at one selected value, in this case, input2 or the "Campaign" field, and then auto populates input3 or "Template" according to the corresponding value in the "campaign_table" resource (which is an connection made to a Google sheet).

For instance, in the Google sheet, we have a value in cell A5 that is selected in input2, which then input3 should auto-populate the contents of cell B5.

Any help with this will be appreciated.

2

Hey @jth, welcome to the community :hugs:

Assuming you already queried your sheets data (to be able to populate input2) you could write a JS Query that takes data from the same row (but different column) and populate input3.

Is this in a form or in an editable table? Could you also share some of your setup around the queries and inputs?