# Use a checklist to record attendance and record students name and date attended on a separate google sheet **URL:** \ **Category:** Ask for Help\ **Created:** [March 31, 2022, 11:45am UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287 "2022-03-31T11:45:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![twobob](https://avatars.discourse-cdn.com/v4/letter/t/d26b3c/32.png) [@twobob](https://community.glideapps.com/u/twobob)\ **Post date:** [March 31, 2022, 11:45am UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287/1 "2022-03-31T11:45:18Z")
Hi Folks I am trying to mark attendance on a checklist screen (names are on a google sheet called “NamesData"and have it record on a separate google sheet called “RollHistory”. I want to use a checklist so that I don’t have to go to a second screen and click a “Present” button which then updates the RollHistory sheet with ‘Date’ and ‘Name’. (it is currently working like this but it is too slow and I can’t quickly see a list of who has been marked off.) I have set up the checklist screen and I have added an action to “add row to RollHistory” and put two columns in this sheet being ‘Date’ and 'Name” which have been added to the action but when clicking the checkbox the RollHistory sheet does not add a row with the date and name. Any ideas on what I am neglecting to do would be greatly appreciated? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 31, 2022, 11:48am UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287/2 "2022-03-31T11:48:46Z")
If you’re using Google sheets, there will be a lag for sure. Best to build in glide tables for any sort of “log” functionality. It gets worse the more records you have that are being rolled up. ---
**Author:** ![twobob](https://avatars.discourse-cdn.com/v4/letter/t/d26b3c/32.png) [@twobob](https://community.glideapps.com/u/twobob)\ **Post date:** [March 31, 2022, 12:00pm UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287/3 "2022-03-31T12:00:54Z")
Hi Robert. Many thanks for your reply and thanks for the youtube videos you have posted. I have really enjoyed watching them and have been blown away by the the things you have managed to achieve and share. With regard to the RollHistory I will re-do it with a glide sheet. Is clicking the checkbox on a checklist the trigger that will cause the action to occur ie add the current time and student name to the RollHistory sheet or is there something else I need to do? Thanks again and kind regards Bruce ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 31, 2022, 1:13pm UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287/4 "2022-03-31T13:13:55Z")
Thanks for the kind words! Unfortunately, checking a checklist box can’t trigger an action. You’ll need to add the action to the inline list itself. I’ve built a few different attendance apps for teachers/coaches, and the leanest approach I’ve been able to come up with looks something like this: Here’s the template I was referring to: > **[Attendance Tracker Template • Glide](https://www.glideapps.com/templates/attendance-tracker-1w)** > > Attendance Tracker allows admins to create teachers, assign classes, and add rosters of students to a class. Afterwards, teachers/admins can take daily attendance for each class. Admins can set attendance calendar, define holidays and view analytics... ---
**Author:** ![twobob](https://avatars.discourse-cdn.com/v4/letter/t/d26b3c/32.png) [@twobob](https://community.glideapps.com/u/twobob)\ **Post date:** [April 1, 2022, 3:46am UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287/5 "2022-04-01T03:46:29Z")
Thank you very much Robert for pointing out that “checking a checklist box can’t trigger an action. You’ll need to add the action to the inline list itself.” ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 2, 2022, 3:46am UTC](https://community.glideapps.com/t/use-a-checklist-to-record-attendance-and-record-students-name-and-date-attended-on-a-separate-google-sheet/40287/6 "2022-04-02T03:46:44Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.