I have a form with 2 dependent dropdowns, the first works fine, the second is dependent on the first
My first valid if is as follows:
IN( [_THIS], SORT(SELECT (Brand[Sauce], [_THISROW].[Brand] = [Brand])))
The user then selects the sauce, which should then display the content of the column “CURRENT” (i.e current recipe of said sauce)
IN( [_THIS], SORT(SELECT (Brand[Current],true, [_THISROW].[Sauce Name] = [Sauce])))
I tried to follow the tutorial regarding adding the “TRUE” statement but I guess I wrote it wrong.
Maybe
IN( [_THIS], SORT(SELECT (Brand[Current] , [_THISROW].[Sauce Name] = [Sauce]), TRUE))
Unfortunately whilst this does work in “TEST” when I save to the form and try it, it doesnt work…
Any advice?
I have a similar thing going on with a Make and Model selection for an automotive app I have.
Dropdown 1)
SELECT(MAKES[MAKE], TRUE)
Dropdown 2)
SELECT(MODELS[MODEL], [MAKE] = [_THISROW].[MAKE]).
Hopefully this doesn’t give you a bum steer and can help steer you in the right direction.
For reference:
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |