I work with a non-profit organization that implements several different programs. One program is an after-school literacy program. This program runs throughout the year and has 20 - 30 individuals participating at any given point in time.
The program manager has been using google sheets to track attendance. I am trying to figure out a way to do this in KNACK. So far I have only found the ability to set up a form where you search for a single participant and record attendance for that individual. This is really tedious to do daily for 20-30 individuals. I am looking for a sort of grid-like solution where you could have a radio button or something like that for each student enrolled, for each day.
It seems the only solution requires some additional javascript coding?
Is there any other way to do this creatively without using additional javascript coding?
Hi @Jacob1, there is a similar discussion that occurred here a couple of years ago that I hope is relevant: Classroom attendance tracking
Let me know if that gets you on the right track?
Yes. I read through that discussion. It seems the solution they provided requires custom javascript, which I cannot curently implement due to limitations on my deployment. (We are piloting the database before full upgrade). I was wondering if there was a solution that would not require additional javascript code.
Hi Stephen - that makes sense. If my understanding is correct, this would require me to set up a table with all dates in it in advance. Meaning, if there were going to be 30 sessions, I would need to set up 30 fields, each for a seperate day? I think I may just need to wait until I can use custom javascript.
Just off the top of my head. By 30, do you mean days of the month? Your attendance table could have fields like Month-Year, D1, D2, D3…D30. You could link your students table to the attendance table, 1:M. You might be able to use Flows to iterate through the students and create a record for the given Month-Year for each student. You might be able to get creative and use formulas to compute dates or days of the week for D1-30, meaning 30 or 60 additional fields. Something like that. It’s probably doable, but you might have to think out of the box to get there.