I have a Form with a “type” that a want to filter from a list:
How i want it to work :
1 - select a “type” as filter from a Choice component
2 - The second Choice component will be filtered based on the “type”.
How my spreadsheet is setup :
| INDEX | CATEGORY | TYPE | PRODUCT | PRICE |
The setup in Glideapp :
- Relation : [Index] > [List > Index]
(This return the INDEXs from my spreadsheet into groups)
- Lookup : Relation Column : PRODUCT
(This return the PRODUCTS from my spreadsheet into groups)
I have it grouped by TYPE, Now… how can i get the grouped items into the second “choice component”. It has to change dynamic inside the FORM, using the other “choice component”.
I saw this working outside the form… is there a way to work inside the form without the need to sent it?