Hi. I am looking to build dependent dropdowns that are getting data from Google Sheets using the API.
What I want to build is described here:
I have a Google Sheets table that looks like this:
I want to make two dependent dropdowns:
- One that has only unique strings from the column “Defect type.”
- Dependent on the first dropdown selection, it displays only strings from the “Defect name” column that match with the selected Defect type from the previous dropdown.
The illustration of my dropdown use idea:
The output settings of the Google Sheets Connector are following:
The output (some of them) of the Google Sheets Connector:
How to filter out the first row (in this case, the “Defect type”)?
How to have only unique values in this dropdown?
How to display only the Defect names that match with a selection from the previous dropdown list?