is the app script stuck in the loop?

It migth be possible that ss.deleteRow(row) is triggering your on change trigger. Another possible situation is that IFTTT is triggering multiple times the on on change trigger. In any case try the following:

replace

function phototable(){ 

by

function phototable(e){
  if(e.changeType !== 'INSERT_ROW') return;

The above will make that rest of the code will only be executed when a new row is inserted.

The side effect is that you will not be able to execute the function directly but you can use the following

function test_phototable(){
  var e = {changeType:'INSERT_ROW'};
  phototable(e);
}

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top