Google Apps Script Conditional Statements

-

Conditional statements are used to perform different actions based on different conditions.
Very often when you write code, you want to perform different actions for different decisions.
You can use conditional statements in your code to do this.

Google Apps Script will have the following conditional statements:

  1. Use if to specify a block of code to be executed, if a specified condition is true
  2. Use else to specify a block of code to be executed, if the same condition is false
  3. Use else if to specify a new condition to test, if the first condition is false
  4. Use switch to specify many alternative blocks of code to be executed

if Statement

Use the if statement to specify a block of Google Apps Script code to be executed if a condition is true.
Syntax
if (condition) {
block of code to be executed if the condition is true;
}
Example
“Check voting age in India”
function ifCond() {
 try{
   var age=18;
   if (age >= 18) {
     Logger.log("You are eligible for voting in India");
   }
 }catch(ex){
   Logger.log(ex);
 }
}
Logs:  [18-03-11 23:17:16:958 IST] You are eligible for voting in India

else Statement

Use the else statement to specify a block of code to be executed if the condition is false.
Syntax
if (condition) {
block of code to be executed if the condition is true;
} else {
block of code to be executed if the condition is false;
}
Example
function ifElseCond(){
 try{
   var age=17;
   if (age >= 18) {
     Logger.log("You are eligible for voting in India");
   }else{
   Logger.log("You are not eligible for voting in India");
   }
 }catch(ex){
   Logger.log(ex)
 }
}
Logs : [18-03-11 23:18:51:898 IST] You are not eligible for voting in India
else if Statement
Use the else if statement to specify a new condition if the first condition is false.
Syntax
if (condition1) {
block of code to be executed if condition1 is true;
} else if (condition2) {
block of code to be executed if the condition1 is false and condition2 is true;
} else {
block of code to be executed if the condition1 is false and condition2 is false;
}
Example
function ifElseIfCond(){
 try{
 var greeting="Shiv have a ";
   var time = new Date().getHours();
   if (time < 10) {
       greeting += "Good morning..!";
   } else if (time < 20) {
       greeting += "Good day..!";
   } else {
       greeting += "Good evening..!";
   }
   Logger.log(greeting)
 }catch(ex){
 Logger.log(ex)
 }
}
Logs: [18-03-11 23:27:32:491 IST] Shiv have a Good day..!

 

Switch Statement

The switch statement is used to perform different actions based on different conditions.
Use the switch statement to select one of many blocks of code to be executed.
Syntax
switch(expression) {
case n:
    code block
    break;
case n:
    code block
    break;
default:
       code block
}
This is how it works:
  • The switch expression is evaluated once.
  • The value of the expression is compared with the values of each case.
  • If there is a match, the associated block of code is executed.
Example
The getDay() method returns the weekday as a number between 0 and 6.
(Sunday=0, Monday=1, Tuesday=2 ..)
This example uses the weekday number to calculate the weekday name:
function switchStatement(){
 try{
   var day="";
   switch (new Date().getDay()) {
     case 0:
       day = "Sunday";
       break;
     case 1:
       day = "Monday";
       break;
     case 2:
       day = "Tuesday";
       break;
     case 3:
       day = "Wednesday";
       break;
     case 4:
       day = "Thursday";
       break;
     case 5:
       day = "Friday";
       break;
     case 6:
       day = "Saturday";
   }
   Logger.log("Today is "+day)
 }catch(ex){
   Logger.log(ex)
 }
}

Logs : [18-03-11 23:31:35:643 IST] Today is Sunday


Happy Coding......

Location: India

Comments

Post a Comment

Popular posts from this blog

Google Apps Script Exception Handling

-
Image
Errors In Computer Programming There are three types of common errors in programming: Syntax Errors Runtime Errors Logical Errors i) Syntax Errors Syntax errors, also called parsing errors , occur at compile time in traditional programming languages and at interpret time in Google Apps Script. For example, the following line causes a syntax error because we used Variable name V caps. function errorTest(){ Var num1=100; } Try to Save ( Ctrl+S ) Error log:  Missing ; before statement. (line 47, file "RegEx") When a syntax error occurs in Google Apps Script, IDE don't allow to save the last changes. ii) Runtime Errors Runtime errors, also called exceptions , occur during execution (after compilation/interpretation). For example, the following line causes a runtime error because here the syntax is correct, but at runtime, it is trying to call a function that does not exist. function errorTest2(){ var test=method(); Logger.log(t
Read more

Google Apps Script Regular Expressions

-
Image
RegEx A regular expression, also called a regex , is a method for matching text with patterns. For example, a regular expression can describe the pattern of email addresses, URLs, telephone numbers, employee identification numbers, social security numbers, or credit card numbers. What Is a Regular Expression? A sequence of symbols and characters expressing a string or pattern to be searched for within a longer piece of text. When you search for data in a text, you can use this search pattern to describe what you are searching for. A regular expression can be a single character or a more complicated pattern. Regular expressions can be used to perform all types of text search and text replace operations. Ref Google: For additional instructions and guidelines, see also Guidelines for using regular expressions and RE2 Syntax . Syntax /pattern/modifiers; var patt = /googleAppsScript/i; / googleAppsScript /i  is a regular expression. googleAppsScript   is
Read more

Responsive Web Apps using Google Apps Script

-
Image
Hi Apps Script developer's, Google apps Script allows to develop Dynamic and Static Web applications like fetch data from Google Sheet and create dynamic cards, intelligent data entry form, Workflows, Help Desk, etc. When you create Web apps using Google Apps Script, it will  not be responsive . You can make applications responsive using third party framework like Bootstrap , Material design or other HTML responsive framework. In this post I am explaining how to create responsive(Using Bootstrap 4.0) Google Apps Script Web application from scratch *Required Basic HTML & responsive framework knowledge  Go to your Google Drive Open Google Apps Script Editor   Create new blank apps script Project & save it Add 3 more Html files Index.html, JavaScript.html & Stylesheet.html with given code For any Web application it requires 4 main components(I am explaining best practise here, you can add HTML, JS & Stylesheet in to two files if you want) For code files
Read more