Daily Attendance with Google Forms and Sheets

preview_player
Показать описание
Use Google Forms and the corresponding Response Sheet to quickly and easily view Daily Attendance. Watch the video to learn how to customize formulas and conditional formatting to automate this process. Perfect option for attendance tracking, lunch counts, field trip counts, special day selections, and much more.
  1. CottenTechCoach
  2. google
  3. google sheets
  4. sheets
  5. google forms
  6. forms
Комментарии
Автор

Yay! I got it! The problem was that I had started working on it in my personal Gmail account instead of my school account. Once I made a copy of the Daily Attendance in my work account, set up restrictions for only those within my organization, the problem of the extra column to collect emails was gone, and the original formula worked! Thanks again for this awesome video! Woohoo!

claudiaborrego
Автор

can i use the same form for multiple periods? how does that work by linking the same form to the spreadsheet for multiple periods?

sinzdkc
Автор

I also tried this formula to compensate for the fact that my original data has the students' names in column "C". =QUERY(FormResponses, "select C, D, A where A > date '"&TEXT(TODAY(), "yyyy-mm-dd")&"'order by C ASC", 1). I added back some of the spaces to this one as well. Still doesn't work. Please help!

claudiaborrego
Автор

How do you know if they "popped in" while in the classroom? If the link is available online and they are remote, isn't it possible for them to "attend" without actually showing up?

underfoot
Автор

I love this idea and have been working on it for several hours but, like Jamie, cannot seem to get the formula right. I'm using this one: =QUERY(FormResponses, "select B, C, A where A>date'"&TEXT(TODAY(), "yyyy-mm-dd")&"'order by B ASC", 1). I also think I have my spacing wrong, but there is also another issue. My Google Form collects the students' email addresses, so my "B" column in my "FormResponses" is their emails, and the "C" is their names. Is that what could be causing the error that keeps coming out? I've tried switching out the "C" for the "B", but I keep getting the same message (Error: Array result was not expanded because it would overwrite data in B1.") Any help you can give me would be GREATLY appreciated. Thanks!

claudiaborrego
Автор

I can't get the query right, keeps giving me errors....=QUERY (Period1, "select B, C, A where A > '"&TEXT(TODAY(), "yyyy-mm-dd")&"'orderby B ASC", 1)? Im sure its about spacing

jamienoyes
Автор

How would I do this if I had multiple periods

vaquashadean