I need to track attendance every week for a series of classes, but with over 500 students in the program it would take too long to enter a new record for each student one at a time.
Is there a way to set up a page where I can just go down a list and check students absent or present?
Additionally I’d like for parents to be able to submit absences in advance and have that show up on the list when I am taking attendance.
Thank you!
Hey @Patrick8, I agree that would be quite cumbersome to enter each one at a time.
Firstly, I suggest having Session Attendance records generated at the start of the week for each Class Session that exists within the week. This can be achieved via Make/Zapier.
You’ll then be able to have a page with a grid of Session Attendance records on a Class Session page, which should have a default attendance of ‘No’.
On this grid, you can either add an action button that toggles their attendance status or some nifty JavaScript I’ve used in the past to toggle their status between ‘Yes’ and ‘No’ a lot faster in the background.
Parents should be able to log in and set that existing Session Attendance record to ‘absent’.
Hope that gives you a starting point, let me know if you’d like some further assistance!
I agree with my good friend @StephenChapman - my preference would be to create the related line items on a weekly schedule.
I thought I’d share a snippet of a full video which includes the “Quick Toggle” feature, which is part of the KTL by @NormandDefayette_CortexRD
This is an open source code library available for you to use free of charge. It is used by a number of Knack Experts and a growing number of users.
Cortex R&D Inc
There are also some videos on my channel explaining more about KTL including a recent interview with Normand.
Hi @Patrick8,
I’ve created a Demo page for you to test the Quick Toggle feature.
See it here: Quick Toggle Demo Page
The keyword used has this syntax:
_qt=palegreen, transparent
If the value is Yes, the background color will be pale green. Otherwise, it will be transparent (default cell color).
Try to click as fast as you can. All clicks will be queued in memory and executed in a background loop.
Have fun!
Norm
Hey @StephenChapman,
You should join the contributors club!
You’re a good Javascript coder I think.
Or maybe share some code snippets with us, that could be integrated to the KTL?
Norm
Thank you! That is for sure what I needed.
Thank you all for your help! I will be checking out KTL more as I buld out my stuff.
I immediately thought of the KTL Quick Toggle feature and a scheduled task to create the new records.
I was thinking after hours each day for the next day’s attendance records.