Hello all,
I have a report to track attendance of students in classes.
The report has values from many tables, including students, subject, class, class_meeting etc.
The report includes all students registered in class and it has one checkbox field which is used to show if they were present or not at the specific class meeting.
The checkbox is the student_id column and it is checked when the "present" field is 1 and unchecked when the "present" field is 0, it's implemented like this:
apex_item.checkbox2(1, student_id, DECODE(present, 1, 'CHECKED', null))
as per the api documentation.
I have also created an on submit process which looks something like
FOR I in 1..APEX_APPLICATION.G_F01.COUNT LOOP
UPDATE class_meeting SET present = 1 WHERE student_id = APEX_APPLICATION.G_F01(i);
END LOOP;
So far so good. What I want to do is, let's say the professor opens the report again and unchecks one of the students and submits the page, how do I set "present" back to 0 for the unchecked student?
The main question I guess is, how do you access the values of the unchecked checkboxes, with an on submit process.