I am developing an app that requires different dropdown choices for a category field depending on the value of another field.
Both the category and the source field will be dynamic, so I can’t just set up some tables in sheets.
I have used unique() to get the list of unique categories, but of course, when I use that list in the category Choice field, it shows all of them, not just the relevant ones.
I have looked at the Categories & Sub Categories video and got that concept to work (using relations), but he doesn’t show if the same concept works when you come to Choices.
Is there any way using relations or some google sheet formulas to make this happen?