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
Sure thing! Hereās the Integromat that I developed:
Ohā¦and this:
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:
7 Likes
Hereās the link to the template:
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.
2 Likes
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.
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.
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.
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?
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.
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.
1 Like
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?
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.
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?
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.
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.
Ya, most likely, that and itās a template so nothing actually gets written to the sheet.
1 Like
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!
1 Like
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 is in the middle of developing a date functionality that will solve the issue.
2 Likes
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.
1 Like
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?
1 Like