When does the app refresh?

You can change the image url within the app. Any functionality that you can build into the glide data tab will give you instant results without lag because it’s updated on Glide’s internal database first. It’s easy for Glide to send updates to google sheets, but google doesn’t always send instant updates to Glide. That’s why there is a few minute delay sometimes. Any data you update within the app is instantly visible in the app and only takes a few seconds to send to the google sheet. I think Glide performs a query within a few seconds to pull back any formula values you have in the sheet, but if you have scripts or some other processes that take a long time to run, then the opportunity is missed. Also, not every type of sheet update will trigger google to send the update to Glide. That’s where the background refresh comes in and performs a query every few minutes to look for updated data in the google sheet. I’m guessing bandwidth could get out of hand if glide had to query the sheet for updates every few seconds. That’s why it’s best to create as much functionality as you can within the app.