Attendance reports
![0618bw](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition?
Please help.
Best Answer
-
You could set up automation with filters. I'd start with the "notify someone on a specific date" template.
- Set your trigger (you would want "when a date is reached")
- Instead of "run once," choose "custom" and set it accordingly
- Choose time of day to trigger email
- Select a condition - your first might be when the "teacher name" is yours
- Add the other needed conditions. For example, you would want only those who were absent and only in the last 30 days, etc.
Then..
6. Select who should receive this email. You can select as many as you want.
7. Click "Customize message" and then
8. Plug in your subject and message.
9. Change to "Links to sheet and specific fields" then select the columns (absent, name, date, etc.) you want the office to see in the email.
Save it and you should be all set!
Answers
-
You could set up automation with filters. I'd start with the "notify someone on a specific date" template.
- Set your trigger (you would want "when a date is reached")
- Instead of "run once," choose "custom" and set it accordingly
- Choose time of day to trigger email
- Select a condition - your first might be when the "teacher name" is yours
- Add the other needed conditions. For example, you would want only those who were absent and only in the last 30 days, etc.
Then..
6. Select who should receive this email. You can select as many as you want.
7. Click "Customize message" and then
8. Plug in your subject and message.
9. Change to "Links to sheet and specific fields" then select the columns (absent, name, date, etc.) you want the office to see in the email.
Save it and you should be all set!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives