# 🆕 Event Picker
**URL:** https://community.glideapps.com/t/event-picker/15965
**Category:** General
**Created:** [September 17, 2020, 7:14pm UTC](https://community.glideapps.com/t/event-picker/15965 "2020-09-17T19:14:17Z")
**Posts on this page:** 20
**Page:** 7
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [October 1, 2020, 8:12pm UTC](https://community.glideapps.com/t/event-picker/15965/122 "2020-10-01T20:12:03Z")
Perfect Bob!!! 🤩🔥 I’m glad you achieved that! I did exactly how you did, you got it right
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 1, 2020, 8:13pm UTC](https://community.glideapps.com/t/event-picker/15965/123 "2020-10-01T20:13:56Z")
It was a brilliant solution. Works well for open ended bookings. For those with set durations and limitations, it isn’t the best UI yet. Event picker needs more data validation to make that happen.
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [October 1, 2020, 8:15pm UTC](https://community.glideapps.com/t/event-picker/15965/124 "2020-10-01T20:15:53Z")
> [@Robert\_Petitto](#):
>
> Event picker needs more data validation to make that happen.
100% agreed. When we got it and also the calendar similar to event picker layout, as @Antonio showed us, will be amazing
---
### Author:  [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)
#### Post date: [October 1, 2020, 8:49pm UTC](https://community.glideapps.com/t/event-picker/15965/125 "2020-10-01T20:49:42Z")
Anyone that can notice a fix in real time should be afforded the title of Expert.
Everyone who understands and contributes to this specific topic should also be afforded the higher rank.
Do not even consider me worthy of such acclaim.
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [October 1, 2020, 9:37pm UTC](https://community.glideapps.com/t/event-picker/15965/126 "2020-10-01T21:37:03Z")
@Les_Henderson I’m here for the equalist pursuit of making this s\*&t work. Don’t believe in ranks of any sort. Just tables of 40 columns for validation and glad I’m not the only stubborn creature doing it. But you are kind and an expert in your own right, I’m sure of it.
Important: the above is not characterization of Glide as a platform but rather, the quirkiness of datetime stuff.
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [October 1, 2020, 9:40pm UTC](https://community.glideapps.com/t/event-picker/15965/127 "2020-10-01T21:40:43Z")
@Rasha I’ve been struggling with those points for months, and said here many times!!
---
### Author:  [@Rasha](https://community.glideapps.com/u/Rasha)
#### Post date: [October 1, 2020, 9:43pm UTC](https://community.glideapps.com/t/event-picker/15965/128 "2020-10-01T21:43:56Z")
great work @Lucas_Pires! your approach is very efficient and tidy.
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [October 1, 2020, 9:45pm UTC](https://community.glideapps.com/t/event-picker/15965/129 "2020-10-01T21:45:19Z")
Thank you!
---
### Author:  [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)
#### Post date: [October 1, 2020, 9:49pm UTC](https://community.glideapps.com/t/event-picker/15965/130 "2020-10-01T21:49:47Z")
It’s the mutually beneficial interactions of like-minded altruistic people that ultimately make the world go round.
All the rest is a detractive distraction.
---
### Author:  [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)
#### Post date: [October 2, 2020, 7:54am UTC](https://community.glideapps.com/t/event-picker/15965/131 "2020-10-02T07:54:40Z")
Legend!! đź‘Ź
---
### Author:  [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)
#### Post date: [October 5, 2020, 4:04pm UTC](https://community.glideapps.com/t/event-picker/15965/132 "2020-10-05T16:04:00Z")
Wrapped my head around how you did that for your use case and want to apply it to my Flight Scheduling app where a PILOT has to choose an AIRCRAFT and an INSTRUCTOR where none of those 3 variables can ever be double booked but because of the multiple PILOTS/INSTRUCTORS/AIRCRAFTS there can currently be up to 6 flights at the exact same time until we add additional AIRCRAFT.
There are 30+ Pilots/Instructors and 6+ Aircraft.
How might your method change to accommodate a USER/GUEST/ROOM whereas mine would be a PILOT/INSTRUCTOR/AIRCRAFT?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 5, 2020, 6:27pm UTC](https://community.glideapps.com/t/event-picker/15965/133 "2020-10-05T18:27:50Z")
Was there a solution that I missed about being able to scroll through (or at least choose) a different week than the current one using the Event Picker?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 5, 2020, 7:11pm UTC](https://community.glideapps.com/t/event-picker/15965/134 "2020-10-05T19:11:11Z")
You mean on a desktop browser? I haven’t seen anything regarding that. Works fine on my android by tapping the date in the picker.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 5, 2020, 7:34pm UTC](https://community.glideapps.com/t/event-picker/15965/135 "2020-10-05T19:34:07Z")
Exactly. Works on a phone…not in the browser.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [October 6, 2020, 1:13am UTC](https://community.glideapps.com/t/event-picker/15965/136 "2020-10-06T01:13:26Z")
I was scrolling like a maniac yesterday on Chrome thinking why does it not go over next week lol.
---
### Author:  [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)
#### Post date: [October 6, 2020, 3:08pm UTC](https://community.glideapps.com/t/event-picker/15965/137 "2020-10-06T15:08:42Z")
On your next layer when choosing a ROOM and/or PERSON…
Doesn’t your 0/1 have to be dynamic and change based on if the ENDTIME is before NOW? The way your current build looks, your ROOM/PERSON variables would be a static ROOM#/PERSON# and would never become available after they have been booked a single time.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 6, 2020, 3:16pm UTC](https://community.glideapps.com/t/event-picker/15965/138 "2020-10-06T15:16:46Z")
Sorry…having a hard time following. The way I have this built is by using a template `0-ROOM#` and relating this to any time there’s a `0-ROOM` in the booking submission log. The `0` appears when there is a conflict and a `1` appears when there is no conflict _for each time already booked_. So, a time is available only when there are no conflicts (`0`s). If the `0-ROOM#` returns a match, that means there must be at least one conflict and thus prevents the user from booking.
If you wanted to add additional layers (`0-ROOM#-INSTRUCTOR`) for instance, then you’d simply add `INSTRUCTOR` to the template columns in both sheets which would open up availability. Or, if you wanted to allow max 3 bookings per room, you’d do a rollup on the relation to get the count and if the count is \>=3, then you’d prevent the user from booking.
---
### Author:  [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)
#### Post date: [October 6, 2020, 3:40pm UTC](https://community.glideapps.com/t/event-picker/15965/139 "2020-10-06T15:40:03Z")
So using your method, I can allow 2 students to book 2 different rooms with 2 different instructors at the exact same/overlapping time AND prevent others from booking those same rooms/instructors during those times.
I’m assuming the way your method works is only based on finding conflict in TIME and not on TIME + ROOM.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [October 6, 2020, 3:49pm UTC](https://community.glideapps.com/t/event-picker/15965/140 "2020-10-06T15:49:23Z")
Exactly. And no, my method is finding conflicts with TIME+Room.
---
### Author:  [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)
#### Post date: [October 6, 2020, 3:52pm UTC](https://community.glideapps.com/t/event-picker/15965/141 "2020-10-06T15:52:55Z")
Last question before I build it out, and delete over 500 columns, is template column looking like Time + Room & Time + Instructor or Time + Room + Instructor?
Breaking them up would allow you to reference which variable needs to be changed in order for a successful booking correct?
[Previous page](https://community.glideapps.com/t/event-picker/15965.md?page=6)
[Next page](https://community.glideapps.com/t/event-picker/15965.md?page=8)