Calling Google Script functions from if statement

Question

I am using Google Scripts and I just want to run a function based on cell contents. I know this looks like a formula but I want it as a script!

=if(T2="*",SplitNames,fullNames);

So if T2 contains any text then run function SplitNames. Otherwise run function fullNames.

How do I write this please? Thanks.

Are you trying to write this as a Google Sheet formula or within your google-apps-script? — ross
– ross, Commented Jul 12, 2019 at 12:30
Within the google apps script. The only way I know how to express what I mean is making it look like a formula!! haha — Stephen Cousins
– Stephen Cousins, Commented Jul 12, 2019 at 12:45
Apologies @TheMaster did I miss something. Obviously new to the forum so still finding my way. Any help appreciated. — Stephen Cousins
– Stephen Cousins, Commented Jul 12, 2019 at 13:03
@TheMaster it would have been if the user was trying to execute this via formula - I didn't realise until afterwards that they may have been trying to portray the logic using the formula as an example. — ross
– ross, Commented Jul 12, 2019 at 13:50

ross · Accepted Answer · 2019-07-12 13:56:51Z

2

All you need is a simple if statement based on the value of cell "T2" which I have defined below as var cell:

function checkT2() {
  var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var cell = sh.getRange("T2").getValue();

  //check if cell is not empty
  if (cell) {
    SplitNames();
  } else {
    fullNames();
  }
}

References:

if statement

edited Jul 12, 2019 at 13:56

answered Jul 12, 2019 at 12:29

ross

2,7842 gold badges15 silver badges22 bronze badges

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

Comments

LALLEMENT.E · Accepted Answer · 2019-07-15 15:05:17Z

0

What you have to is get the content of your cell and then make your test :

yourFunction()
{
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var T2 = ss.getRangeByName("T2").getValue()//get the content of the cell T2 in the variable T2
  if(T2=="*")
    splitnames();//assuming you have a function splitnames in your script file
  else
    fullnames();

}

edited Jul 15, 2019 at 15:05

answered Jul 12, 2019 at 12:56

LALLEMENT.E

811 silver badge9 bronze badges

5 Comments

Stephen Cousins Over a year ago

Thank you @LALLEMENT.E this script is definitely doing something. Does it make a difference if the contents of T2 is text? I was thinking "*" means ANY text. Seems it only wants to run the SplitNames function regardless of what is between the quotes. Thanks

LALLEMENT.E Over a year ago

I think the test T2=="*" is only true when the value in the cell T2 is the character *. If you want to test the type of the content of T2 you should do this instead : if(T2 instanceof String). Now if I understood correctly what you want to do, you should pass your variable T2 in the parameters of your function splitnames(), and fullnames(). So you should write something like this : splitnames(T2); Also can you tell me what is the code of your function splitnames and fullnames ?

Stephen Cousins Over a year ago

Aaaah that makes sense. I want to test for ANY TEXT at al in T2 and then run one function or the other dependent on the result. Thank you, I'll have a play!

LALLEMENT.E Over a year ago

Alright but are your functions splitnames() and fullnames() in the same file as your script ?

ziganotschka Over a year ago

T2 is not the content of the cell, if you want to access the content you need the method T2.getValue(), and if you want to check if T2 is empty, you do it by if(T2.getValue=="")

Collectives™ on Stack Overflow

Calling Google Script functions from if statement

2 Answers 2

References:

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

References:

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related