Skip to main content

Script Writing - Using Operators

Scott Carpenter
  • Updated

Overview

Operators are symbols used in App Scripts to perform actions like comparing values, combining conditions, or doing math. Understanding these is key to writing logical and efficient scripts. 

 

🧠 1. Logical Operators

Use these operators when performing logic (e.g. conditional statements such as if()) in App Scripts.

Operator Description Example
&& AND 
if(currentValues["Priority"] && currentValues["Status"]){

}
|| OR 
if(currentValues["Priority"] == "Low" || currentValues["Priority"] == "Medium"){

}
! NOT 
if(currentValues["Status"] && !currentValues["Priority"]){

}

 

👉|👈Relational Operators

Use these operators to compare values of two objects against each other, or set the value of one object to the value of another object.

Operator Description Example
== Test equality between two objects (e.g. is the Status field equal to "Open") 
if(currentValues["Priority"] == "High"){

}
!= Test difference between two objects (e.g. is the Priority field NOT equal to "High") 
if(currentValues["Priority"] != "High"){

}
< Less than 
if(currentValues["Units in Order"] < 25){
currentValues["Order Size"] = "Small"
}
<= Less than or equal to  
if(currentValues["Units in Order"] <= 25){
currentValues["Order Size"] = "Small"
}
> Greater than 
if(currentValues["Units in Order"] > 100){
currentValues["Order Size"] = "Large"
}
>= Greater than or equal to 
if(currentValues["Units in Order"] >= 100){
currentValues["Order Size"] = "Large"
}
=

Set the value on the left of the equals sign (=) to whatever the value is on the right of the equals sign

 
currentValues["Status"] = "Yes"

 

âž• Arithmetic Operators

Use these operators to perform basic math.

Operator Description Example
+ Addition (also used for concatenation of fields) 
int ten = 10 as int
int five = 5 as int
ten + five
//Output
//15
- Subtraction 
int ten = 10 as int
int five = 5 as int
ten - five
//Output
//5
* Multiplication 
int ten = 10 as int
int five = 5 as int
ten * five
//Output
//50
/ Division 
int ten = 10 as int
int five = 5 as int
ten / five
//Output
//2
++ Increment by 1 
//Objective: When "Add Tasks" is "Yes" and Number of Tasks has a value, 
//add that many Task records to the Tasks table
if(currentValues["Add Tasks"] && currentValues["Add Tasks"] == "Yes" && currentValues["Number of Tasks"]){
Int taskRecordsToCreate = currentValues["Number of Tasks"] as Int
Int i = 0
while(i < taskRecordsToCreate){
addChild(("tasksTable"), ("taskRelationship"), [:])
i++
}
-- Decrement by 1 
//Objective Use a Loop with a Counter that decrements by 1 after each loop)
def counter = 5
while (counter > 0) {
logger.info("Countdown: " + counter)
counter-- // reduce by 1 on each loop
}

//Output
Countdown: 5
Countdown: 4
Countdown: 3
//etc.

 

 

Related Articles: 

Related articles

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk