My app’s URL: https://omfnp.glideapp.io/ I am trying to recreate @Robert_Petitto ’s Meet with Me app, with buffer and meeting duration pre-selected. As part of the slots availability check, I am subtracting 2 dates expressed as numbers (Robert - here’s a hint for you to add/subtract dates in Glide …

Right. I tried building in a 15 minute buffer. That’s why it was unavailable.

I agree that the lag is frustrating. The only source of the lag right now is that I’m converting a date time concatenation to a date value.

Robert - to give you an idea of what the implementation is like, this is wild web of a number of calculations. :sweat_smile: :sweat_smile: [image] Others testing the app: the app is broken now. I tried changing the format for the desired date in my app and it is not getting carried over int he ri…

Oh my goodness…I’m SO close. All I need to do is somehow get my date picker to write the datevalue (as a number) in Glide…thought maybe writing the date picker to a num column would work but it writes 0.0000 instead. Tried formatting my spreadsheet to be a number in 00000.0000 format and it works …

Ok…I went a bit crazy. I finally got it to instantly calculate by creating my own datevalue calculation using a several if/then columns. [Meet_with_Me_·Glide·_Create_Apps_from_Google_Sheets] Used two sets of unavailable time columns and two relations to check for conflicts: numeric start datet…

It should be sufficient to format the whole date/time column in Google Sheets as a number. Then next time you let Glide write a date/time to that column, it should honor that format.

It doesn’t. When I write to that column, Google sheets switches the Date value back to timestamp which Glide then interprets as date/time column which means I can’t do calculations.

Nevermind. Faulty logic lol. [image]

I almost made it work with rounding up the numbers in the Google Sheets. But it again broke at some other places for other times. I am going to take a break from this! :wink: Robert - I can send you a link to copy the app in case you’re interested.

Math formula with Precision

Report a Bug

Jeff_Hager May 19, 2020, 3:13am 30

In all honesty, it was a collaborative effort including @Robert_Petitto, @kyleheney and several others to get to this point.

Topic		Replies	Views
Meet with Me: A Booking App that Prevents Conflicts Project Showcase	76	6552	June 30, 2021
🆕 Date-time Math General data-editor	126	14074	September 27, 2023
📅 Guide on Dates & Times Community Resources	22	1668	April 2, 2025
Date math lacking precision Ask for Help	15	688	February 21, 2022
Fun with Dates Project Showcase	156	6939	April 19, 2022

Math formula with Precision

Related topics