# Call for Templates: Group Scheduling/Availability **URL:** \ **Category:** Ask for Help\ **Created:** [September 6, 2020, 7:52pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374 "2020-09-06T19:52:08Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [September 8, 2020, 4:13am UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/21 "2020-09-08T04:13:53Z")
Dates! Working with dates is the hardest thing. I started to dabble with this project, but we’ll see how far I pursue it. I have an idea for users to set general availability (not specific dates), but then have the ability to show any people that are available for booking on a specific date based on rules. I think the idea might be good as far as row efficiency, but I’m starting to run into several columns just for simple but multiple repeated if statements. The ability to do mixed AND/OR conditions in IF/THEN columns would also help. …and…ahem…conditional relations. 😉 ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [September 8, 2020, 7:37am UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/22 "2020-09-08T07:37:51Z")
Good words Robert. I had exactly that issue yesterday - Trying to use a Lookup within an If-Then column. I had to do the same as you as a workaround. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 8, 2020, 10:42am UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/23 "2020-09-08T10:42:24Z")
Really nice! Is the previous screen visibility issue fixed for forms, or are you using relations to hide earlier times in the endtime field? Just curious! ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 8, 2020, 10:45am UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/24 "2020-09-08T10:45:52Z")
Not sure if it’s helpful or not, but in my app, I have a NOW() and I check if any of the unavailable times are within NOW(). This is geared more towards a real-time app where you want to know if someone is available as you’re looking at the app, as opposed to wanting to book them for future availabilities. ---
**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:** [September 8, 2020, 12:01pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/25 "2020-09-08T12:01:13Z")
Those choice components took the longest to build. The choice components are running off a user specific relation that’s filtered based on whether the times have already been assigned. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 8, 2020, 12:10pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/26 "2020-09-08T12:10:49Z")
Makes sense. Really wish the screen filtering conditions worked for forms — for this very reason. Could, theoretically, say filter EndTime where time is greater than the Start Time chosen. No extra columns, quick and easy to configure. ---
**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:** [September 8, 2020, 12:22pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/27 "2020-09-08T12:22:21Z")
That’s what I did…but I’m not in a form. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 8, 2020, 1:54pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/28 "2020-09-08T13:54:18Z")
Does the filtering not work in a form? ---
**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:** [September 8, 2020, 1:56pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/29 "2020-09-08T13:56:46Z")
It doesn’t—identical screen filtering results in an empty choice component. ---
**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:** [September 8, 2020, 2:32pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/30 "2020-09-08T14:32:52Z")
Hey @david, Also really need the ability to multi sort (eg. Sort by Date, THEN Sort by Time). Have to do this in Sheets to get what I need: `={"Sort";ArrayFormula(if(len(A2:A),VALUE(left(C2:C,10))&text(D2:D,"00"),""))}` ---
**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:** [September 8, 2020, 5:29pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/31 "2020-09-08T17:29:07Z")
## 🥳 Submitted! [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/757103167233fad087816d1b3bf0b24ab410ffb2.jpeg "Glide: Our Availability Promo") ](https://www.youtube.com/watch?v=i3yx0G3u9U0) @david ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 8, 2020, 6:34pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/32 "2020-09-08T18:34:51Z")
Any caveats? Like, is there special setup required in the sheet? Please add notes in the app if needed! Will review now. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 8, 2020, 6:39pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/33 "2020-09-08T18:39:19Z")
@ThinhDinh Update! This seems to be working with the new “includes” filters, but still not quite there for Dates and Times. > [@new New containing screen context for conditions](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/53): > > This looks to be working more than it has been in the past. It’s still not 100% functional for dates/times though. This seems to be part of the “is Included in” conditions that were recently added. See screenshots of a FORM: Dept 2 choices after selecting Dept1 in the first choice component (Dept 1 is no longer a choice) Filter conditions for 2nd choice component (where the “Dept 1” is Screen --\> Dept 1): [image] Still an issue — Dates and Times! When I try to perform s… ---
**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:** [September 8, 2020, 7:07pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/34 "2020-09-08T19:07:30Z")
Hm. I’ll add to the template. The Sheet is a beast, unfortunately. Fortunately, there isn’t much set up that needs to happen in the sheet except for updating the Calendar dates (stinks that it uses up 365 rows per year, but oh well), the available “Roles” for employees. Last caveat is that, at least for v1, availability is in hour-long durations. ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [September 8, 2020, 7:10pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/35 "2020-09-08T19:10:28Z")
Is the reason a Date component can’t be used for the Date field (so that the 365 choices aren’t necessary) purely due to the regional formatting issues that have been previously identified? That’s the main reason I’ve started defining dates manually in the sheet versus using the Date field, but I’m curious if you’re doing it for other reasons beyond that issue. ---
**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:** [September 9, 2020, 2:35am UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/36 "2020-09-09T02:35:03Z")
# Hey all, Want better date formatting? ### [Direct link to vote for this feature](https://features.staging.glideapp.io/ewAiAHQAIgA6ADMALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0ARgBlAGEAdAB1AHIAZQBzACIALAAiAHIAIgA6ACIAMwBDAHYAYQBtAC4ARQBMAFEASgBtAEMARABlAHMANAB0ADYAMwBsAEQAZwAiACwAIgBuACIAOgAiAEQAZQBkAGkAYwBhAHQAZQBkACAARwBsAGkAZABlACAARABhAHQAZQAgAFQAZQBtAHAAbABhAHQAZQAgAEMAbwBsAHUAbQBuACIAfQA%3D) ---
**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:** [September 11, 2020, 2:16am UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/37 "2020-09-11T02:16:38Z")
# Our Availability Available now in the Template Store 😉 > **[No-Code App Templates - Create Customizable Apps Without Coding | Glide](https://www.glideapps.com/templates)** > > Browse 100+ free, ready-made templates and business apps that you can customize to your needs quickly without code. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/757103167233fad087816d1b3bf0b24ab410ffb2.jpeg "Glide: Our Availability Promo") ](https://www.youtube.com/watch?v=i3yx0G3u9U0&t=2s) ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 11, 2020, 9:20pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/38 "2020-09-11T21:20:33Z")
![ADMIN](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/840ba6a4c537d47710e8dd4aac902ce4738d06e9.png) ![gsh](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f7415f8b7875332da1b3d26e6b3edbe8c79e55b6.png) ![STAFF AVAILABILITY](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f6ee03f54648eb6626064fe62005740d7ee3342f.jpeg) ![STAFF HUB](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/81db9bd1d0aa1df2110925330a6e492154c7124e.jpeg) Mine is done too as promised @david. Just finishing the video presentation. Here is a preview. 4 parts: 1. Group Schedule Tab - all staff members have access here and can see who has been selected. 2. Staff Hub - employees add their availability by date and the 4 traditional shifts (morning/afternoon/evening/night) with start and end times. They can add as many shifts they like say for the morning where they maybe free during certain intervals. 3. Admin - controls everything 4. Staff availability hub - the calendar is based on a fortnightly staff shift rota. It could be increased to any period. The days are auto-added Filtering/sorting By shifts - which open dates by morning, afternoon, evening and night. By date (no formulas used - done inside the editor) By time ( no formulas used - done inside the editor) Shorlisting - admin shortlists all those they need, and then posts all selected ones to the GSH All staff members can see if they have been selected or not. They all also receive confirmation to their profile inbox. Any employees selected are automatically filtered out from the availability list. Many many more features Thank you ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [September 11, 2020, 9:53pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/39 "2020-09-11T21:53:30Z")
Incredible! ---
**Author:** ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)\ **Post date:** [September 11, 2020, 9:55pm UTC](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374/40 "2020-09-11T21:55:08Z")
Thank you @david@Jeff_Hager [Previous page](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374.md?page=1) [Next page](https://community.glideapps.com/t/call-for-templates-group-scheduling-availability/15374.md?page=3)