Continuously running Script

[Liz Loper]

Hi,
I am trying to build a template where the app script would run every few minutes to clean up data. Is that possible to create? 

I also need some help building a sheet to make sure external clients can use the template but are unable to change how the overall structure of the sheet works. 

Thanks

Liz

[George Ghanem]

Hi Liz,

I would not do that. Having a script running every few minutes is wasteful and in some aspect too slow.

What you should do is an on edit script so that whenever anything changes in the sheet, you do the cleanup at same time.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/25633ded-7d4c-4fd7-a1f7-a2063311f948n%40googlegroups.com.

[Liz Loper]

Thanks George, any chance you can help me with creating the on edit Script? 

[Liz Loper]

Thanks George, 
Any chance you could help me write the on-edit script? 

On Thursday, February 20, 2025 at 1:46:19 PM UTC-5 George Ghanem wrote:

[Andrew Roberts]

It is possible to have a script running every few minutes, but you need to make sure that the script doesn't use up your daily quota of 6 hours run-time a day - I'll let you do the maths! But as George says it would make more sense to just have the script run when it needs to.

andrewroberts.net

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/84387f92-b056-4b6c-ace3-4920bd092a7fn%40googlegroups.com.

[George Ghanem]

Sure. I can help. Let me know what you want the script to do. Also creat a sample template spreadsheet and share it with me.

Email address is ggha...@gmail.com 

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/b80309dc-a5f1-4374-88c1-52d2953325c3n%40googlegroups.com.