Select list in the second row to be unique from first row

[Korn_Tris]

Hello . I have A table for students and i have B table for class. Now in table B i have a column with multi select student list from table A.

What i want is that if the students name are already selected in first row, I want it to be unique and cannot be select in second row .

Any formula to filter this

[Quentin_Morel]

Hi @Korn_Tris

If I understand well, you don’t want to be able to select a student twice, > if a student is already in Test Class 1, you dont want to have it in Test Class 2, right ?

If Yes

• Start to check if a people is already in a test class with this formula. If coda detect your students once in the test class list, the checkbox qill go to “true”
  
  
• Then, custom filter your lookup (in option settings) in class table, you only want people that are not already in a class > witch checkbox “already in a class” not true

• There you go, you will have only “available” people for new class test

[Christiaan_Huizer]

hi @Quentin_Morel , @Korn_Tris

you might also want to consider this in the LookUp Option

currentvalue. Contains(BibleStudyClass.StudentSelection).Not()

cheers, Christiaan

[Korn_Tris]

what do you mean by lookup option? if it’s LOOKUP then it’s not select list

[Quentin_Morel]

Hey @Korn_Tris

@Christiaan_Huizer meens in the option settings here, that will filter your lookup value. With his formula, you will only have available people. Different (more elegant) solution than mine, but same results !

Right there