Unselected values in enumlist

[flan828]

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]

flan828:

and the field [present] is set to true

and or if the field is set to true?

flan828:

I would like to be able to have all the rest of the list set to false for that day

Can you elaborate? Where is [Present] located? Which basetype is the EnumList?

flan828:

Right now I have the [present] field default value set to false

So Students is another table and the EnumList is basetype Ref?

flan828:

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

Can you tell us how you did that? Is related to Looping with actions?

flan828:

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?

I have no way to tell you anything about this before we get more info.

Please give us a better intro to your app, what it does, the tables that you have and their schema

[flan828]

to answer your questions:

• enumlist for students is in a table called attendance_table its of type ref.
• [present] is set to false by default and it is in the attendance_table.[present] is of type yes/no.
• student_table is what’s referenced in attendance_table[student_id]

My app keeps track of attendance.
what happens is that when you add an attendance you choose the acadamy, the date, and the student(s)
the attendance_table is where the records for the students are kept. the acadamy field is a ref of the acadamy_table, date is set to today() or you can choose a date. and the student(s) is of type enumlist with a base type of ref.
each record is stored in the attendance_table using a looping behavior action.

what I am trying to figure out is how to create records for each of the students that were absent and set the present field to “false”.

I’ve been thinking about just creating a separate table for absent students and using a behavior action to fill the table. however, I am not certain that is the most efficient way to do it. I figure if I can reference the non-selected students there might be a better way.
Thank you for your help.
Flan

[SkrOYC · Accepted solution]

flan828:

I’ve been thinking about just creating a separate table for absent students and using a behavior action to fill the table

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?

[flan828]

well because if they miss a certain number of classes we want to know.

[SkrOYC]

SkrOYC:

on the students

This part is the key.
Ths students table should have info about the students that is not changing all the time, like their birthday, gender, name, etc.
If they were on a class or not should not be on the students table

[flan828]

Yes. Agreed. If the student attended class that is part of the attendance_table. What I don’t have is a record that says if a student did not attend class.
This is what I am trying to figure out how to do.

Thank you for your help.

[flan828]

SkrOYC:

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

the Y/N isn’t in the student_table… Its in the attendance_table

[flan828]

created a new table with an action to copy using your formula… thanks for the guide

[flan828]

In the Add Attendance form, I have a drop down that is of type ref it references the academy_table. At the moment I have two academies ‘a’ and ‘b’. In the same form I have an enumlist that I was able to filter down to a list of students by the academy selected in the aforementioned academy drop down.that they are currently assigned to. In the attendance_table[student_id] validif section I used FILTER(“STUDENT_TABLE”, ([ACADAMY] = [_THISROW].[ACADAMY_ID]))
this currently works to list out the students only in that academy. However, what I have come to find out is that in filling the absent table I use list subtraction with the following filter((student_table[_thisrow]-[STUDENT_ID]).
This does filter out the students that were selected but also includes the students from the academy that were not in the original enumlist. I’ve tried all sorts of different filter() and select() statements and haven’t been able to find one that works. Perhaps something like filter(“student_table”,([student_id] = [_thisrow]-[student_id])and ([acadamy] = [_thisrow].[acadamy_id])) ???

[SkrOYC]

flan828:

filter((student_table[_thisrow]-[STUDENT_ID])

This expression doesn’t make sense, it has an extra parentheses also

[flan828]

(student_table[_thisrow]-[STUDENT_ID]) <— this works. In that it gives me a list of students per the academy selected.
sorry for the extra paren and the filter() not sure how that got there.
… type-o. STUDENT_ID is the enum list.

[flan828]

I guess what I need is (student_table[_thisrow] - [STUDENT_ID] filtered by [ACADEMY] just don’t know how to do it.