Understand that changes in importrange do not occur in Glide without reloading the sheet. What is the best way force updates automatically?

@George_B That is exactly what I did, thank you! @gvalero It is the triggering of the now() function which solves the refresh problem, the query function has no relevance!

You would need to create a script that does the same thing as importrange, and run it with a Google App Trigger.

@George_B Thanks! I will use a trigger to “refresh” the IMPORTRANGE formula. What is the best way to refresh a formula?

I don’t know of a way to invoke a refresh. What I said was that you would need to write a function that does the same thing as the IMPORTRANGE formula does. I posted something along those lines back in the Spectrum world. Here is a link to that post: [image] I missed the caution about …

Does this help the import range? Works with images. [image] How can I cause my images to update whenever they change? Feature Requests In the glide together meeting today, someone asked about using Dropbox and how glide was caching pics. You asked how this might be used…

@spencersRus No, not from my experience.

We’re introducing a periodic background refresh for Pro apps in the coming days that should make the IMPORT (IMPORTXML, IMPORTRANGE, etc.) and real-time formulas like NOW and google finance formulas refresh every few minutes. We’ll announce this in a day or two, please try it if you have a Pro app t…

Hi guys, Have you ever tried this?: Open you Spreadsheet and click File -> “Spreadsheet” settings. In “Recalculation” section, choose your best setting from the drop-down menu: On change / On change and every minute / On change and every hour. Click “Save Settings”. It’s the 1st thing you sho…

@gvalero Do some tests where you don’t have the spreadsheet with the ImportRange() formulas open in a browser. It won’t refresh the data from the other sheet no matter what settings you have.

Thank you All! This worked for me: Install time based trigger copy now() function from one cell to another

I don’t think so George! Try using this: =Query(ImportRange()) and you will see how fast the data is updated. In my spreadsheets, If I modify or add a new record (I have 150.000 records in my source spreadsheet), my other sheet gets new data in less than 1 min. That is my sintaxys to get it: …

Importrange

Ask for Help

spencersRus November 3, 2019, 4:20pm 5

Does this help the import range? Works with images.

Topic		Replies	Views
Gsheet doubt Ask for Help	12	505	November 1, 2021
Probème de synchronisation google sheets et Glide Ask for Help	2	119	November 14, 2023
Possible to send data to other apps? Ask for Help	21	828	May 21, 2021
Glide doesn't show all the data from Sheets Ask for Help	3	233	July 28, 2022
Give partial access to the spreadsheet through importrange RESUELTO Ask for Help	6	794	May 3, 2020

Importrange

Related topics