Hello everyone,
I am a new user and am slowly learning how to use Notion.
My main project now is a database for a teacher. I have done quite a bit, but am stuck.
I have the following structure:
Students (ID, Name, Enrolled courses, Year enrolled, notes...)
Courses (Name, semester, year)
Classes (day of the week and period) - I use this to create my schedule and it works! I am proud.
Attendance (connects the class to the date and the student list)
What I want to do:
In the course page I want to have a table with the student list that looks similar to this:
Students
"New Class" - button that adds a field for the current class and date in the attendance table
Name ID Status Present Absent Partial Attendance
James 2 Absent Button Button Button 75%
Problems so far:
-
When adding the buttons, I can't make them only change the status of the student in the current course and day (it changes the status for all classes that day) - when adding a new filter to the template, it doesn't allow me to add a "this file" type of filter.
-
Ignoring the buttons, I can use the table "Attendance" in the Courses page to check the attendance by adding the students to the columns (Present, absent...). This works, but allows me to add the same student to multiple columns.
- Still Ignoring the buttons, I can't filter the "Attendance" column in my example to only use the days related to the course. I tried using a rollup but can't seem to be able to filter it It shows up every field that has that student in the attendance table.
I am sorry if I am not very clear with the issues I am having. Also, since I am new to this, I assume the structure itself might be the issue. Can you point me in the right direction?
Thanks!