Hello, I would like to know how the update works when the application is connected to Google Sheets. I’m developing a scheduling application and much of the logic is in Google Sheets, the part that bothers me the most is when the user records the start date/time and end date/time, after which Shee…

The app is connected to Glide’s backend copy of your google database. The backend will then sync to your google sheet. Glide may request updates from Google periodically, and sometimes Google will send data to Glide. None of it is meant to be instantaneous. You would be better off moving your lo…

That could very easily be done with all of the logic in Glide and no formulas in the Excel sheet. In addition to the slowness, you are also restricting yourself to only one user using your app at a time by having the logic in your Excel sheet. All you really need is to have a checkout table with t…

I would like to thank you for spending your time helping me, it worked exactly as you said, I spent countless hours to find a solution, and only yours worked. I am eternally grateful.

Actually the problem was not solved, I tried just using IS BEFORE and IS AFTER, but it wasn’t. I used IS ON OR BEFORE and IS ON OR AFTER but it worked for a while and then stopped. I don’t use the DATE & TIME component, just DATE. I use a CHOICE with a specific table and the times are every 30 mi…

[image] FelipeMilian: Actually the problem was not solved, I tried just using IS BEFORE and IS AFTER, but it wasn’t. I used IS ON OR BEFORE and IS ON OR AFTER but it worked for a while and then stopped. ON OR BEFORE/AFTER only accounts for Dates. It does not look at time. IS BEFORE/AFTER i…

[image] date Guide: Mastering Dates & Times Community Resources The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble…

Thanks. I’ll see what I do. The Date & Time component leaves a lot of room for the user to make mistakes, for example: I can’t block a timetable. If the user selects a schedule to start at 15:00, they can select the time 09:00 to return, and I can’t block it like that, much less block times that ar…

It probably worked because you were using ‘ON OR BEFORE/AFTER’ which looks at the whole day without looking at time. If you look at the post I shared, there is math to convert your date into YYYYMMDD. Make sure you select no decimals and no group separators. Start with that. Then use a template c…

Thanks again for your attention. I recorded a quick video to show you how the tables and the application are, if you can see it I would really appreciate it. You are helping me understand Glide. glide.mp4 Google Drive file.

The biggest problem is that you haven’t created the logic to join the date and time into one date value. That’s the part I tried to explain in my previous post. What you have right now is 4 date columns instead of 2. So your query is looking at all 4 as individual dates and times. Let say you ma…

Google sheets takes time to update!

Ask for Help

Jeff_Hager April 25, 2024, 6:52pm 8

Topic		Replies	Views
Glide App not updating automatically from Google Sheet Ask for Help	11	762	May 27, 2023
Sync rule with google sheets Ask for Help	4	331	January 3, 2023
App won't refresh with google sheets Ask for Help data-sync	15	502	October 8, 2023
Google spreadsheet update in data taking time, Ask for Help	14	1853	August 15, 2023
Speed optimization of the app Ask for Help	10	553	January 19, 2022

Google sheets takes time to update!

Related topics