Never Ending loop, need suggestions

[Krishnendu Panja]

Kindly check this script i want to put it in a never ending loop 

Please suggest.

(for(var i=0;i<50;i++) i have tried it with i<500000, it extened the loop but not to infinite

function onEdit(e)
{
var ss = SpreadsheetApp.getActiveSpreadsheet();
var mysheet = ss.getSheetByName("Sheet1");
var activeCell = ss.getActiveCell().getA1Notation();

if( activeCell == "A1" )
{
for(var i=0;i<50;i++)
{
if( i%2 == 0 )
mysheet.getRange("A1").setBackground("RED");
else
mysheet.getRange("A1").setBackground("WHITE");

SpreadsheetApp.flush();
Utilities.sleep(500);
}
}
}

[Andrew Roberts]

A single Apps Script execution will only run for a limited time before timing out: 6 mins  for GMail accounts, 30 mins for Workspace. 

--
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 on the web visit https://groups.google.com/d/msgid/google-apps-script-community/6ced8ff2-41a9-4c31-922d-9f3ac1415d8cn%40googlegroups.com.

[Clark Lind]

Wouldn't it be easier to just use Sheet Protection to protect the cell and give a warning?

[CBMServices Web]

Or put an onEdit trigger to cause the function to run.

Infinite loops are never a good thing!

--

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 on the web visit https://groups.google.com/d/msgid/google-apps-script-community/ba6413d1-fdde-46bd-afd0-4f1a6dfe996dn%40googlegroups.com.