Solved: Unselected values in enumlist - Page 2

flan828 · 12-24-2021 11:35 AM

I have a enumlist that is a list of students. I can pick any number of students and the field [present] is set to true. I would like to be able to have all the rest of the list set to false for that day. Right now I have the [present] field default value set to false. when I add the attendance the selected student’s present value is set to true using a behavior action that creates an individual record for each selected student in the enumlist using the following formula index([STUDENT_ID], [COUNT]). My question is, is there a way to index the students that are not selected?
Or
is there a way to set the unselected students’ [present] field to false?

Thanks,
Flan

SkrOYC

This is the way to go in my opinion

The other way is maybe by a list substraction

STUDENTSTABLE[KEYCOLUMN]-YOURENUMLIST

You will get a list of the students that are not selected.

BTW, why you need to have a YN column on the students table if that changes technically everyday?

View solution in original post