Skip Iteration Google Apps Script

Question

I have a very simple For Loop in Google Apps Script to check some conditions in a Google Sheet. What I want is to add another condition, if it is met, then I want to skip current iteration and move on to next. This is pretty easy in VBA, but I am not sure how to do it on JavaScript.

Current code:

for (var i=1 ; i<=LR ; i++)
    {
     if (Val4 == "Yes")
      {
       // Skip current iteration...   <-- This is the bit I am not sure how to do
      }
     elseif (Val1 == "Accepted" && !(Val2 == "") && !(Val3 == ""))
      {
        // Do something..
       }
      else
      {
       // Do something else...
      }

    }

Read about loop control statements in JavaScript. Namely, break and continue. Note that if your for loop has only a single logical statement (your if-else if chain), then simply adding that check and using an empty conditional body will suffice. — tehhowch
– tehhowch, Commented Sep 20, 2018 at 12:58
you probably mean continue statement w3schools.com/js/js_break.asp. If not, then showing the VBA alternative should make the question clear — Slai
– Slai, Commented Sep 20, 2018 at 12:58
@Slai - thanks for that. Really useful. Please put that in answer and I will mark as correct. — Oday Salim
– Oday Salim, Commented Sep 20, 2018 at 13:10
This question was solved with a minimum of research. An internet search with generic keywords should have led you to the answer - part of asking a good question. Did you do any research before asking? — tehhowch
– tehhowch, Commented Sep 20, 2018 at 13:29

Slai · Accepted Answer · 2018-09-20 16:49:22Z

12

continue statement can be used to continue to next itteration :

for (var i=1 ; i<=LR ; i++)
{
  if (Val4 == "Yes")
  {
    continue; // Skip current iteration... 
  }
  // Do something else...
}

In your sample case, leaving the if block empty will achieve the same result:

for (var i=1; i <= LR; i++)
{
  if (Val4 == "Yes")
  {

  }
  elseif (Val1 == "Accepted" && !(Val2 == "") && !(Val3 == ""))
  {
    // Do something..
  }
  else
  {
    // Do something else...
  }
}

edited Sep 20, 2018 at 16:49

answered Sep 20, 2018 at 15:34

Slai

23k5 gold badges49 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Skip Iteration Google Apps Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related