Google Time Trigger

Ask for Help
1

Since there are 1000 edit limitation when using personal version of Glideapps. If the googlesheet edit is done by the googlesheet built in “Time Trigger”, does that edit count towards the 1000 edit limit?

Thanks!

2

I don’t believe that has any effect on how often Glide checks for Sheet updates. I don’t believe that will force any quicker updates to be made by the app itself.

3

Thanks for your reply. I am still trying out the free version before subscription.

Since the googlesheet built in “time trigger” update the cell with function

=IMPORTRANGE("https://docs.google.com", "sheet1!A751:V762")

which also automatically update all the cell from A1 to Q11 at once.

So I would like to confirm if that count as one edit or count as 187 edits as the function updates 187 cells at once?

4

I am not 100% on this, but Glide checks for sheet updates (not individual cell updates), so if multiple cells change between the time Glide checks for updates, then multiple cell updates would only be seen as one Glide Sheet Edit/Update.

A few tests would show you the answer pretty quickly though!

5

Thanks! I will try that out, if everything goes well I will consider subscription