Looping code to run continuously in (Excel) Google sheets

Hi,

I have a Looping code that will perform an action every 10 seconds.

Please Login or Register  to view this content.

I want to add this to a Googlesheet and I'm concerned about running a Macro that will run continuously, perhaps adding a processing load to the PC.

Maybe there's a better way to do this?

There may be other methods and the only thing that must be used is Googlesheets.

Thanks.

To clarify, apps scripts run on the server, not in your computer: https://developers.google.com/apps-script/overview

Moving on, the script appears to be making a popup then running a procedure (function) every 10 seconds, is that right?

If so, a few things you should be aware of:
* simple trigger apps scripts must complete within 30 seconds
* installable trigger apps scripts must complete within 6 minutes
* installable triggers can not be run in shorter timeframe than 1 minute intervals
* if you abuse the quotas then your apps scripts may be restricted

Thanks janmorris,

Yes this example is a quick example to prove the repetition loop will work by showing a Popup & running the Function.

What I will add is the functionality run when new data is populated to a certain worksheet.

It would then distribute the values to a worksheet depending in it's value type.

It looks like I can add this code to a Google sheet and run it to suit the parameters you have described.

Re my question about having a macro running constantly, maybe a trigger is a better idea.

Thanks for your comments.

"macro running constantly, maybe a trigger is a better idea"

The way Apps Scripts work is ALWAYS from a trigger of some kind, they never "run constantly".

See:
https://developers.google.com/apps-s...uides/triggers
https://developers.google.com/apps-s...rs/installable

To have the effect of running constantly will require an apps script to stop after running for N minutes (where N is anything less than or equal to 6 minutes) and to be retriggered at any time greater than the time it was halted.

NOTE: Technically speaking, macros are apps scripts that run based on keystrokes. All macros are apps scripts, but not all apps scripts are macros, if that makes sense.
https://developers.google.com/apps-s.../sheets/macros