# 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:** 20\
**Page:** 3

<div class="post-metadata">

**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:** [May 18, 2020, 6:18am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/41 "2020-05-18T06:18:51Z")

</div>

Hi Robert,

You may have shared it on another post but would you be able to share your Integromat logic for syncing a calendar?

Thanks

---

<div class="post-metadata">

**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:** [May 18, 2020, 11:37am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/42 "2020-05-18T11:37:44Z")

</div>

Sure thing! Here’s the Integromat that I developed:

 ![Screen Shot 2020-05-18 at 7.36.40 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8dccd0a8d4f3e02d09ea4e2f1d693973d5ae3de3.png) …email me and I’ll send you the blueprint if you’d like.

Oh…and this:

---

<div class="post-metadata">

**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:** [May 18, 2020, 8:52pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/43 "2020-05-18T20:52:56Z")

</div>

# 👋 Hey All!

I just completed the Meet with Me template! Check the Template store in the next day or two. Until then, here’s the promo video:

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4de276d719ffd210fcb85c4f119ee1f592feb0d3.jpeg "Glide: Meet with Me Promo") ](https://www.youtube.com/watch?v=RHOpFMLpTuI)

---

<div class="post-metadata">

**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:** [May 19, 2020, 1:20am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/44 "2020-05-19T01:20:29Z")

</div>

# Here’s the link to the template:

> **[Meet with Me](https://go.glideapps.com/app/ss6D3kyvZEKDXqxb6tob-template)**
>
> A personalized booking app that prevents conflicts.

## Note:

The app only works for devices set to English for the time being. If and when Glide enhances their Date/Time columns, I’ll be able to expand the template globally.

#### Special Thanks:

Huge shout out to @Jeff_Hager for the idea of using custom timevalues to bypass some of the inconsistencies I was experiencing. Special mention to @sardamit who took time to brainstorm ways to use datevalue over date string for calculations.

---

<div class="post-metadata">

**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:** [May 19, 2020, 10:55am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/45 "2020-05-19T10:55:06Z")

</div>

Looks good! Does this new version get around the bit of lag you were experiencing in the earlier version when the duration was moved to the pre-form area? That was the kicker for me to change my version of the app from the duration captured in the form to duration captured before the form.

---

<div class="post-metadata">

**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:** [May 19, 2020, 11:31am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/46 "2020-05-19T11:31:01Z")

</div>

Hey!

Yes. It still isn’t perfect… the only way to get around the lag was to use math columns not date columns. This means I needed to convert my date time column to a number without Google Sheets. To do this I had to do a series of if-then that reference the English format of the date column. So, for now, my booking app only works for phones set to American English.

---

<div class="post-metadata">

**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:** [May 19, 2020, 1:35pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/47 "2020-05-19T13:35:50Z")

</div>

Oh wow that’s quite the work-around!I’m really hopeful the date/time issues get resolved through more of a standardized approach on the Glide side… then time calculations added to the Editor’s Math column! Both of these changes would be huge for this sort of app and another I’ve created.

---

<div class="post-metadata">

**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:** [May 19, 2020, 1:56pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/48 "2020-05-19T13:56:43Z")

</div>

Agreed! Even if we could just have an option to format the date time columns as datevalues to do calculations, that would be awesome…the tricky part, I guess, would be converting a math column back to date/time column?

---

<div class="post-metadata">

**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\
**Post date:** [May 19, 2020, 2:08pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/49 "2020-05-19T14:08:17Z")

</div>

While we are at that, I would also hope that the precision setting applies to the data, and not just for the presentation of the data.

Currently, if I set precision to 1.00, 1.236 is rounded to 1.24 visually, but in the backend it is still processed as 1.236. In essence, precision should also round the data.

---

<div class="post-metadata">

**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:** [May 19, 2020, 2:28pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/50 "2020-05-19T14:28:13Z")

</div>

Agreed. I was pulling my hair trying to decide whether to roundup or truncate based on precision…instead I went with Jeff’s method and it worked…just needed to create a lot more lookups.

---

<div class="post-metadata">

**Author:** ![maschera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maschera/32/6730_2.png) [@maschera](https://community.glideapps.com/u/maschera)\
**Post date:** [May 30, 2020, 12:11pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/51 "2020-05-30T12:11:26Z")

</div>

This is great Robert, thanks a lot.

However, would it be possible to accept / deny events automatically based on availability? Most importantly, the user should know if the event has been accepted / declined automatically within the app.

Possible?

---

<div class="post-metadata">

**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:** [May 30, 2020, 1:52pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/52 "2020-05-30T13:52:38Z")

</div>

Hey there. Based on availability of the one who’s booking or availability of the calendar owner? If Calendar owner, that’s what I’m trying to accomplish with the app…prevent conflicts by only allowing certain durations and by hiding the booking button if the time slot is already taken.

---

<div class="post-metadata">

**Author:** ![maschera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maschera/32/6730_2.png) [@maschera](https://community.glideapps.com/u/maschera)\
**Post date:** [May 30, 2020, 2:16pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/53 "2020-05-30T14:16:23Z")

</div>

That’s wonderful, I’m going to purchase the app.

One question though - when I try to schedule an appointment, although the timeslot is available and the booking goes through, I get an error message.

Is that an issue with the demo or does this happen also in production?

Also, not sure if I understood - is the template going to create an event on the App Owner’s calendar or that needs to be configured later on?

---

<div class="post-metadata">

**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:** [May 30, 2020, 4:10pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/54 "2020-05-30T16:10:03Z")

</div>

What error message are you receiving? Currently, I have Zapier turned off because it’s not allowed for template submissions. You would have to configure it yourself afterwards.

---

<div class="post-metadata">

**Author:** ![maschera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maschera/32/6730_2.png) [@maschera](https://community.glideapps.com/u/maschera)\
**Post date:** [May 30, 2020, 6:38pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/55 "2020-05-30T18:38:42Z")

</div>

Instead of the typical iPhone dialog box that says “Sent” I get the same but saying “Error”.

It might be due to the Zapier integration turned off.

---

<div class="post-metadata">

**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:** [May 30, 2020, 6:40pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/56 "2020-05-30T18:40:09Z")

</div>

Ya, most likely, that and it’s a template so nothing actually gets written to the sheet.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [June 3, 2020, 11:40pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/57 "2020-06-03T23:40:44Z")

</div>

Hey @Robert_Petitto! This is awesome!!! What route did you take to manage to lock the mid intervals?

I’m working on an app for my wife’s massage business but I’m struggling big time with locking the mid intervals.

By mid intervals, I mean the time slots in between hours.

Thanks!

---

<div class="post-metadata">

**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:** [June 4, 2020, 12:48am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/58 "2020-06-04T00:48:29Z")

</div>

That was the trickiest part, for sure, and it still isn’t perfect. I had to create a pair of array columns using the known unavailable times. Then I related the user’s selection of date and time to the array column to determine if it was available or not. The issue I ran into is that it was showing that a 60 minute slot was available (due to the way the times worked out) even though a 15 minute slot wasn’t. So I had to create a cascading series of if-then-else columns to check if each duration was available starting from the smallest duration.

In the end, the logic is really sound…but it still fails because date syntax is recorded differently based on locale and by language of the device. Hopefully [@Mark Probst](mailto:mark@glideapps.com) is in the middle of developing a date functionality that will solve the issue.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [June 4, 2020, 2:57am UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/59 "2020-06-04T02:57:45Z")

</div>

Thanks @Robert_Petitto! I was thinking on using if/then/else. My slots are either 60 or 90 minutes. Hopefully I can work it out that way.

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [June 8, 2020, 3:48pm UTC](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/60 "2020-06-08T15:48:58Z")

</div>

Hey @Robert_Petitto I keep hitting walls and I’m terrible with G Sheets formulas. Do you have a price for your meet me app?

[Previous page](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916.md?page=2)

[Next page](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916.md?page=4)
