I’m working on marking rows “This Week”. I realized I would need to first convert the Now date into a serial number date. Here’s the algorithm for converting a date’s month, day, year into to serial number: Trunc(( 1461 * ( nYear + 4800 + Trunc(( nMonth - 14 ) / 12) ) ) / 4) + Trunc(( 367 * ( nMon…

There are some workarounds with google sheets, Glide will update every edit, and when the sheets are closed and the google servers are taking the work load its around a 2 second delay. With this being said you can utilize a onChange script to force the edit and force the 2 second update.

I need the Today () function to update at midnight though. That’s not always happening.

run a timer script that just types a number 1 in a cell you dont use. it will force the edit update. So set timer for 12am and cell a1 on sheetnoonesheardoforuses is value 1. I can write the script out if you tell me sheet name and cell.

I read that Glide wont update when scripts make changes. Have you tried it? Does it work?

yes, it works. the scripts wont update if used as a onedit script, but a onchange script will. I use them like they aregoing out of style.Literally every app I make uses them. Glide isnt robust enough to do everything just yet so I make scripts even write formulas when onchanges occur.

But you are talking about a time based trigger change. This isn’t onedit or onchange. Have you used that?

right, since you only need it at midnight then it will make the change on its own and glide will post the change.Glide doesn’t know the difference between you making the change and a script. Google knows the difference between glide making a change and a formula making a change and us making a chang…

Also a quick and easy fix is to just change google updates to every minute and turn on iterative calculations. [image] [image]

It is currently set to every minute. I may try the script! In the mean time, was able to do it completely in GDE (there is one arrayformula in Date Ref to get a base date of 1899-12-30 - will test if that slows it down still). [Glide community - screenshot 1] [Glide community - screenshot 2] [Gl…

Thats great! :grin: Keep us updated.

Calculating This Week in GDE

Ask for Help

Jeff_Hager December 4, 2020, 3:38pm 28

Now you should be able to create a math column and calculate weeknum(today) - weeknum(date) and if it’s zero, then it’s ‘this week’. All within Glide. No google sheet formulas or scripts.

Topic		Replies	Views
Glide App not updating automatically from Google Sheet Ask for Help	11	694	May 27, 2023
🗓 Month, Day, and Year Math Functions Ask for Help	47	3817	July 15, 2023
Display Current Day of Week Ask for Help	7	1717	September 12, 2020
Fun with Dates Project Showcase	156	6939	April 19, 2022
Filter By Week Feature Requests	5	701	March 27, 2024

Calculating This Week in GDE

Related topics