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.
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.).
