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.
LinkedIn
Twitter
