# 🆕 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:** 1\
**Showing post:** 111

<div class="post-metadata">

**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")

</div>

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.

---

_[View the full topic](https://community.glideapps.com/t/event-picker/15965)._
