Solved: Appsheet multiple Dependent Dropdown filtered by f... - Page 2

Ubadath · 08-23-2022 03:34 AM

Hi,

I'm making a program for students festival program management app.

3 Groups contesting = RED, ROSE, GREEN Gropus.

Participants are 3 categories = Sub junior, Junior, Senior

for Participants form I have category dropdown after Name & team Name.

1 student can participate maximum 4 programs like song, poem, drawing, quiz ...etc

so, I made columns ITEM-1, ITEM-2, ITEM-3,ITEM4. for each record.

now i'm getting category filtered data in item-1 column (only junior items if selected junior category)

so, the same full list coming in next dropdown Item-2. where no need to shoe the already selected item in Item-1.

The same in Item-3,4 columns also.

please help

Steve

Editable? expression for ITEM1:

ISBLANK([ITEM2])

Editable? expression for ITEM2:

AND(
  ISNOTBLANK([ITEM1]),
  ISBLANK([ITEM3])
)

Editable? expression for ITEM3:

AND(
  ISNOTBLANK([ITEM2]),
  ISBLANK([ITEM4])
)

Editable? expression for ITEM4:

ISNOTBLANK([ITEM3])

Appsheet multiple Dependent Dropdown filtered by form data