Struggling with multiple dependent dropdown

[Natt_Boarer]

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.

[Suvrutt_Gurjar]

Natt_Boarer:

IN( [_THIS], SORT(SELECT (Brand[Current],true, [_THISROW].[Sauce Name] = [Sauce])))

Maybe

IN( [_THIS], SORT(SELECT (Brand[Current] , [_THISROW].[Sauce Name] = [Sauce]), TRUE))

[Natt_Boarer]

Unfortunately whilst this does work in “TEST” when I save to the form and try it, it doesnt work…

Any advice?

[Ryan_Mortimer]

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.

[Steve]

For reference:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

SORT()

Sorted list items