Display comma separated values in a list and show next dropdown based on match

[JuanMata]

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?

[Joseph_Seddik · Accepted solution]

Applications and Brands have many-to-many relationship. The best is to have separate Applications and Brands tables and a third table relating them to each other. 

In your Media table, the Brand and Application columns will be references to their respective tables. Once this is done, the behavior you need should be straight forward and easily achieved.