Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
I am trying to find the most convenient way for teachers to enter student attendance, not interactive report, but they select the date, their class and student names with a switch or check box next to each come up and record gets saved as soon as the switch/checkbox is clicked. I have a student’s table (id, name… Etc), class table and attendance table (date, class id, student id, attendance y/n), rewards table (class id, student id, points, date) How can this be done on oracle apex?
You can create a form manually. For example, Create the field horizontally, ID, Name, etc, then give a button on the right side.
Write PL/SQL code to insert these page items into the table using the SQL insert statement.
Create an interactive or classic report below the page items you created horizontally and refresh the report after each insert.
Sorry, can you elaborate more please?
I meant something similar to the image below, where list of kids populated when I click on the class (without having to add them like the image) and have the yes/no switch. Image
You can use interactive grid to operate the attendance (y/n)for every student. Teacher just load the data according to the date,classname and display the information in interactive grid, set the attendance column as switch or checkbox, and then operate it. Hope to help you.