# Meet with Me: A Booking App that Prevents Conflicts

**URL:** <https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916>\
**Category:** Project Showcase\
**Created:** [March 26, 2020, 8:05pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916 "2020-03-26T20:05:59Z")\
**Posts on this page:** 1\
**Showing post:** 67

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [June 20, 2020, 12:48pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/67 "2020-06-20T12:48:51Z")

</div>

Hi @Robert_Petitto,

With regards to your “date calculation” need in the dataeditor, I **might** (?) have found a workaround.

At this stage, it works in my app, so if it can be useful for you I would be happy to make my 1st contribution to this so helpful forum 🙂

- nb 1: the ignition of the idea came from an exchange with @ThinhDinh @Jeff_Hager
- nb 2: I give you the procedure below, and I’m sure that you will be able to make it simpler (as a newbie, I built something quite complicated).

My Use case:  
I have a list of standard recurring challenges among which kids will select some (ie. User Specific) \>\> define a _frequency_ to perform each challenge \>\> and a _starting date_.  
Then, each day, the appropriate challenge has to be displayed according to this initial setup and Today() 's date.

My need:  
GSheet formula would be with a ‘mod’ function on: (“Today” DayNb of the year - “StartDate” DayNb of the year) / (frequency) \>\>\> if it’s an integer multiple (no ‘mod’), challenge is displayed.

My constraint:  
Must be User Specific, hence in DataEditor, but no Date calculations were possible… and here started the nightmare!

Implemented 8 steps solution:  
(1) In DataEditor: ‘Starting Date’ and ‘Frequency’ _User Specific columns_,  
(2) In DataEditor: _template_ column on ‘Starting Date’ to reset the date format,  
(3) In GSheet [datalist] 's sheet: creating all 2020 dates and associated DayNbs of the year; idem with ‘Today()’ formula,  
(4) In DataEditor: _Relation_ to link the ‘Starting Date’ of the [challengeSelect] tab with the [datalist] tab,  
(5) In DataEditor: _LookUp_ to bring back the DayNbs of the related dates (‘StartDate’ & ‘Today’),  
(6) In DataEditor: _Maths_ to do the calculation (Today - startDate / frequency)  
(7) In DataEditor: _If-then-else_ displaying TRUE if the ‘mod’ of the division is 0 [calculation to be checked],  
(8) In Glide layout: _Filter_ on TRUE in the inline list component … !

[https://bac2bazik.glideapp.io/](https://bac2bazik.glideapp.io/)  
_[Edit: modification in-progress on the on-boarding of the app, so you may experience difficulties to test the above explanation]_

Hope this could be a temporary lead, until Glide enables date calculations.

---

_[View the full topic](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916)._