Create a drop-down list dependent on the drop-down list that precedes it.

[Laxis]

Hello everyone. I would like to create a drop-down list dependent on the drop-down list that precedes it.

To make it more concrete, here is an example:
On line 13 (of the Apple table), there is a drop-down list, where I can choose between "Smartphones", "Tablets", "Portal players", "Watches", "Headphones".
I would like that in line 14, if I have chosen for example "Tablets" in line 13, it only offers me to choose between "iPad", "iPad Mini", "iPad Air", "iPad Pro ".

I am a basic French speaker, and I have a little trouble with English technical terms. I tried with the help of various tutorials on Youtube, but I quickly got lost.

Thanks in advance.

[Marc_Dillon]

"Dependent drop-down" is the exact term to search for this.

https://support.google.com/appsheet/answer/10106620

[Laxis]

Thanks.

I've already tried to follow this solution, but the technical terms are sometimes mistranslated, so that in the end, I have errors.

I am looking for someone who could explain to me with my info, what to indicate as a formula and where to place it.

This is the disadvantage of being French-speaking, because many tutorials are in English...

[Marc_Dillon]

What does your reference data look like?

[Laxis]

In my Google Sheet file, I have an "Apple" table, a "Samsung" table and a "Filtre" table.
In the "Apple" & "Samsung" tables, I have a "Device" column and a "Gamme" column.

 

In the "Filter" table, I have in column A the "Device Apple" , in B the "Gamme Apple". The "Gamme" are unique, but the "Device" are not, because for example, I have, on one line, in A "Tablettes" and in B "iPad Air", but in the next line, in A I have "Tablettes" but in B "iPad Mini". Then, I have in E the "Device Samsung" and in F the "Gamme Samsung" and as for Apple, the "Gamme" are unique but not the "Device".

And I would like that in AppSheet, when I create a new entry, if I have selected, for example in the Apple tab, "Tablet" I only have, on the next line, the choice between the different iPads, and not the choice between everything (iPhone, iPod, iPad, etc.).

 

[Laxis · Accepted solution]

I finally found this video, which seemed simpler to me. And it worked for me.
https://www.youtube.com/watch?v=28qCZIDePGI