# 🆕 Event Picker **URL:** \ **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:** 6
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 29, 2020, 7:51pm UTC](https://community.glideapps.com/t/event-picker/15965/102 "2020-09-29T19:51:02Z")
Found it… My mistake. I set a filter it doent need to be there 🤦‍♂️ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/db5d1c4fb4a1e5c392daf2519756cca2ff17b28a.jpeg) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 29, 2020, 9:08pm UTC](https://community.glideapps.com/t/event-picker/15965/103 "2020-09-29T21:08:26Z")
Now, with everything set up, it’s so smooth 🤩 ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [September 29, 2020, 9:19pm UTC](https://community.glideapps.com/t/event-picker/15965/104 "2020-09-29T21:19:35Z")
Brilliant 👏 ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [October 1, 2020, 11:14am UTC](https://community.glideapps.com/t/event-picker/15965/105 "2020-10-01T11:14:19Z")
WOW! Great work! ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [October 1, 2020, 11:51am UTC](https://community.glideapps.com/t/event-picker/15965/106 "2020-10-01T11:51:34Z")
Beautiful. Well done. Really. ---
**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:** [October 1, 2020, 3:17pm UTC](https://community.glideapps.com/t/event-picker/15965/107 "2020-10-01T15:17:30Z")
Looks great! ---
**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:** [October 1, 2020, 3:19pm UTC](https://community.glideapps.com/t/event-picker/15965/108 "2020-10-01T15:19:02Z")
Does the user get the same conflict error if the end time runs into another meeting? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 1, 2020, 3:39pm UTC](https://community.glideapps.com/t/event-picker/15965/109 "2020-10-01T15:39:17Z")
@Robert_Petitto Only when end or start time is within another meeting Take a look ---
**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:** [October 1, 2020, 3:43pm UTC](https://community.glideapps.com/t/event-picker/15965/110 "2020-10-01T15:43:44Z")
Okay—that’s amazing. How did you manage to instantly check if an end time falls in the middle of another booking using the event picker??? I’ve been racking my brains for _months_. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 1, 2020, 4:07pm UTC](https://community.glideapps.com/t/event-picker/15965/111 "2020-10-01T16:07:55Z")
It’s kind of hard to explain, but once you’ve already managed MeetMe and another booking apps, I guess if I give the north, you can try it out… Well, the logic starts when I needed this > [@Date "is on or before/after" only for Today?](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471): > > I’m trying to use the new Event Picker, but while it doesnt have a way to block days/hours, I need to check if the date-time i’m picking is on or before a date-time already scheduled I don’t wanna create 2 columns if I can do it with one only… @Mark is it normal? [image] Why? I dont have to check if a booking time is within, I have to check if the time I’m picking: _(Everything in my **Booked** table)_ - Start picking time **is on or before** and **is on or after** Start time booked. - Start picking time **is on or before** and **is on or after** End time booked. - End picking time **is on or before** and **is on or after** Start time booked. - End picking time **is on or before** and **is on or after** End time booked. In my case I made a IF Then Else column to check both **Start Times** are available brings me the value 1, same to **End Time**. A Math column to multiple both values, cuz if one isnt equals to 1, the multiplcation will be 0. Finally, I create a Template to concatenate what you have more to check + If Then Else if it’s available (check the last column in the screenshot here down). Or in my case, brings me the value Space1 (we book coworker space in the app). In the table where user is picking a time, we create a a Template column too, but with Space0, we **have** really to write “0”, cuz we wanna check only if a booking time **it’s not available.** And If Then Else column only to brings me those value only when start or end picking time is not empty. So, a Relation tells me if this is available (empty) or is not (is not empty) 😌 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/54c13c83f2577663a199139bdef6a45c5d3331a2.png) @ThinhDinh as you also asked. ---
**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:** [October 1, 2020, 4:15pm UTC](https://community.glideapps.com/t/event-picker/15965/112 "2020-10-01T16:15:16Z")
👍👍👍👍👍 ---
**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:** [October 1, 2020, 4:24pm UTC](https://community.glideapps.com/t/event-picker/15965/113 "2020-10-01T16:24:38Z")
Superb! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [October 1, 2020, 5:18pm UTC](https://community.glideapps.com/t/event-picker/15965/114 "2020-10-01T17:18:01Z")
Fantastic, well done for working this out. Mind blown ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 1, 2020, 5:43pm UTC](https://community.glideapps.com/t/event-picker/15965/115 "2020-10-01T17:43:31Z")
Thank you guys! @Wiz.Wazeer @ThinhDinh @Rosewebstudio ---
**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:** [October 1, 2020, 5:48pm UTC](https://community.glideapps.com/t/event-picker/15965/116 "2020-10-01T17:48:24Z")
> [@Lucas\_Pires](#): > > - Start picking time **is on or before** and **is on or after** Start time booked. > - Start picking time **is on or before** and **is on or after** End time booked. > - End picking time **is on or before** and **is on or after** Start time booked. > - End picking time **is on or before** and **is on or after** End time booked. I’m a bit confused here. How can a Start picking time ever satisfy **on or before** _ **AND** _ **on or after** another start time? Same for the other three? ---
**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:** [October 1, 2020, 5:57pm UTC](https://community.glideapps.com/t/event-picker/15965/117 "2020-10-01T17:57:55Z")
Anytime @Lucas_Pires. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 1, 2020, 6:35pm UTC](https://community.glideapps.com/t/event-picker/15965/118 "2020-10-01T18:35:02Z")
Actually, they’re separated things ---
**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:** [October 1, 2020, 6:37pm UTC](https://community.glideapps.com/t/event-picker/15965/119 "2020-10-01T18:37:26Z")
So 8 different if-then columns and then 4 math columns to serve as the “And”? ---
**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:** [October 1, 2020, 7:27pm UTC](https://community.glideapps.com/t/event-picker/15965/120 "2020-10-01T19:27:44Z")
# @Lucas_Pires!!! YOU ARE THE MAN. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 1, 2020, 7:28pm UTC](https://community.glideapps.com/t/event-picker/15965/121 "2020-10-01T19:28:18Z")
If we **is on or before/after** was working… I had to create 16 to do it [Previous page](https://community.glideapps.com/t/event-picker/15965.md?page=5) [Next page](https://community.glideapps.com/t/event-picker/15965.md?page=7)