Appsheet multiple Dependent Dropdown filtered by form data

[Ubadath]

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

[Marc_Dillon]

Your question is not clear.

[Steve]

It seems you want each ITEM dropdown to only offer items that have not been selected in one of the other ITEM columns. That's possible. In order to provide clear guidance, please post screenshots of the Valid If expressions for all of the columns you mentioned in your post: groups, categories, and programs (ITEM1 to ITEM4).

[Ubadath]

HERE IS THE SCREENSHOTS 

[Steve]

If I've interpreted everything correctly, try this as the Valid If expression for ITEM1:

(
  SELECT(
    ITEMS[ITEM],
    ([Category] = [_THISROW].[CATEG])
  )
  - LIST([ITEM2], [ITEM3], [ITEM4])
)

Try this as the Valid If expression for ITEM2:

(
  SELECT(
    ITEMS[ITEM],
    ([Category] = [_THISROW].[CATEG])
  )
  - LIST([ITEM1], [ITEM3], [ITEM4])
)

This as the Valid If expression for ITEM3:

(
  SELECT(
    ITEMS[ITEM],
    ([Category] = [_THISROW].[CATEG])
  )
  - LIST([ITEM1], [ITEM2], [ITEM4])
)

And this as the Valid If expression for ITEM4:

(
  SELECT(
    ITEMS[ITEM],
    ([Category] = [_THISROW].[CATEG])
  )
  - LIST([ITEM1], [ITEM2], [ITEM3])
)

[Ubadath]

it was very nice experience .... 

but May I know that there is a chance to input only item 2 or 3,4 without giving 1st item.

better to come item2 dropdown if input in item 1. And Item3 display if item2 selected only

[Steve · Accepted solution]

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])

[Ubadath]

There is a final request to know how to prevent a chance to :-

Select/ Input same program item for same Team 1 (Velimanna).

means there is a rule that "Only 1 student can participate from 1 team for 1 item" 

[Ubadath]

@Steve and @Marc_Dillon