Hi
I have a table in Google Sheets called ‘Media’, within that table I have many columns but one column I am interested in is Application type. I then have a separate table called ‘Quotes’ that will store the form selections.
The ‘Application type’ column has multiple values that are separated by a comma i.e. value 1, value 2, value 3 etc.
I have added a form view to Appsheet for Quotes and used SPLIT(Media[Application Type], “,”) in the suggested values field. This has been successful and provided me with a list of items removing any duplicated in the process.
The next dropdown will be a list of brands that match the application type.
My issue though is how do I get the next selection to appear once that selection has been made and only with values (brands) that match what was selected.
Here’s a shrunk down view of my Media table
| Media Type | Brand | Range | Sales Price (Per Metre) | Application Type |
|---|---|---|---|---|
| Monomeric | Other 2 | 200 | 2 | Labels |
| Polimeric | 3M | 1080 | 4 | Vehicle Graphics, Labels |
| Cast | Avery | 700 | 3 | Vehicle Graphics, Labels |
| Cast | Other | 500 | 5 | Vehicle Part Wrap, Vehicle Wrap |
If the user selects ‘Vehicle Graphics’ I want a dropdown to appear with only 3M and Avery as options as only ones that have ‘Vehicle Graphics’ I the Application Type column.
How can I achieve this?