Appsheet filter

[Ubada]

I have 2 tables. 

1. Programs (Song, Story, Poem....)

2. Participants (Name, program 1, program 2,3,4

A student can participate maximum 4 program. But if selected program 1 as song, then when selecting program 2 it shouldn't load song(already selected in P1) and need to load only unselected items

[franc · Accepted solution]

Hi @Ubada 

let's say that your first table, which lists your courses is the following

and that you want to store each student's selection as follows:

in order to create a sequence of conditional dropdowns, where the first lists all the available courses, the second one lists all but the one that has been chosen in the first one, and so on, you could create each dropdown as an Enum, and to use the Valid_if condition to list only the courses that you want the user to be able to select at every stage.

for instance, for the first choice from the course list, you could have something like:

which will show:

and for the third one 

which will show the list of remaining courses (I have selected the first two before, Acting and Architecture)

that's it.

Please let me know if you need any further assistance, if you like the answer and if it solves your question.

Have a good day

Franc

[franc · Accepted solution]

Hi @Ubada 

let's say that your first table, which lists your courses is the following

and that you want to store each student's selection as follows:

in order to create a sequence of conditional dropdowns, where the first lists all the available courses, the second one lists all but the one that has been chosen in the first one, and so on, you could create each dropdown as an Enum, and to use the Valid_if condition to list only the courses that you want the user to be able to select at every stage.

for instance, for the first choice from the course list, you could have something like:

which will show:

and for the third one 

which will show the list of remaining courses (I have selected the first two before, Acting and Architecture)

that's it.

Please let me know if you need any further assistance, if you like the answer and if it solves your question.

Have a good day

Franc

[Ubada]

It working ... 

Next wanted solution is that, 

This student Francesco is from Group A.

When trying to input these 4 already group member participated item can't be loaded for next Student (Jospeh) from same group A. 

Like this we have to maintain 3 groups

[franc · Accepted solution]

I'm not sure what you mean but, if this is a new question, please open a new ticket and add a reference to me like this @Ubada. Also, please elaborate on what you mean by the problem with the fourth group.

Thanks