# Rotating school schedule and student's current location!
**URL:** https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323
**Category:** Project Showcase
**Created:** [August 21, 2020, 2:21pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323 "2020-08-21T14:21:03Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 21, 2020, 2:21pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/1 "2020-08-21T14:21:03Z")
At my school, we have a rotating schedule. Students attend five of their seven classes on any given day. The next day starts with the next class in the rotation. After seven days, the rotating schedule resets. Since many students are learning remotely, we need to find a way to provide clarity to their daily schedule. Using some now formulas and date comparisons along with conditional Cloudinary images, I’ve managed to provide a solution for my students and colleagues.
Here is an excerpt from my recent newsletter:
Quite complicated on the backend:
But man, will this help our staff and students navigate these crazy times!
---
### Author:  [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [August 21, 2020, 2:31pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/2 "2020-08-21T14:31:52Z")
This is amazing!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 21, 2020, 2:37pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/3 "2020-08-21T14:37:06Z")
This only works as a Pro app because we need to leverage the Now() formula. Would be _killer_ if Glide ever allows us a Single Value Now() column (@Mark 🙏) …no lag. Right now there is a 3 minute lag between the sheet updating and then the Glide app sync—but all in all I love it!
---
### Author:  [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [August 21, 2020, 2:43pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/4 "2020-08-21T14:43:46Z")
@Robert_Petitto Are you building these as commissioned by schools? NYC schools are a hot mess and getting ready to have this type of rotating schedule for blended learning. Are you looking to build more apps like this? I would bring this to my son’s school principal. I wanted to offer to do something for them myself, but I don’t have any hours left in the day. You probably don’t either but I thought I would ask.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 21, 2020, 2:44pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/5 "2020-08-21T14:44:33Z")
Robert sleeps like 2 hours a day, surely he will have time 😆
---
### Author:  [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [August 21, 2020, 2:45pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/6 "2020-08-21T14:45:09Z")
Well then we found the one person who might be sleeping less than you. 😂
---
### Author:  [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [August 21, 2020, 2:47pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/7 "2020-08-21T14:47:19Z")
@Robert_Petitto, not to be dramatic, but I NEED to know how you do the birthdays. I need to create that in my app for employees with birthdays, anniversaries, and new hires. I understand from @ThinhDinh that this may require scripts…is there a more straightforward way to do it?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 21, 2020, 2:51pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/8 "2020-08-21T14:51:59Z")
Hey, if you’re willing to send work my way, I’d be happy to listen! As for the birthdays, I don’t use any scripts. As long as the app is a pro app, it will work. I just use some spreadsheet `Text()` formulas to grab the month and day of the birthday and the same for the `Today()` formula. Then I do a mult relation to get a list of all birthdays that match today. Then I use the Join Text column to separate the relation with a birthday cake emoji 😉
---
### Author:  [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [August 21, 2020, 3:33pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/9 "2020-08-21T15:33:46Z")
Robert, do you have a demo app available OR just some screenshots? You can email me directly at [deena@brightfox.com](mailto:deena@brightfox.com) - I’d like to then start a thread with the school’s principal.
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [August 21, 2020, 3:38pm UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/10 "2020-08-21T15:38:21Z")
Very nice app and process issue solved. I use the NOW() function as well for a similar [Work-from-home app](https://www.glideapps.com/templates/bsP41ggpAlZZtp80a9RZ-template) that I built and it would be great if Glide offered a “now” solution natively. My assumption is that they will (along with other date calcs, etc.) once the Glide Sheets feature is in production.
---
### Author:  [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [August 22, 2020, 11:29am UTC](https://community.glideapps.com/t/rotating-school-schedule-and-students-current-location/14323/11 "2020-08-22T11:29:11Z")
Good job 👍