Common Text Calculations
Constant Values
"Text Inside Quotes"
Concatenation
Name.First + " " + Name.Last
If-Then-Else
If Temp < 0 then "Snowing" else "Raining"
Is Blank
Name.First = null
Starts With
Name.First.StartsWith("J")
Contains
Name.Last.Contains("th")
Make Lowercase
Name.FirstAndLast.ToLower
Remove Spaces
Name.First.Trim
Common Number Calculations
Addition
Number1 + Number2
Subtraction
Number1 - Number2
Multiplication
Number1 * Number2
Division
Number1 / Number2
If-Then-Else
If Quantity > 5 then 4.50 else 5.00
Minimum
Math.Min(Number1, Number2)
Maximum
Math.Max(Number1, Number2)
Round
Math.Round(Price * Quantity, 2)
Common Date Calculations
Constant Values
"7/14/2022"
Today
DateTime.Today
Days Between
(EndDate – StartDate).Days
If-Then-Else
If FirstDate < SecondDate then FirstDate else SecondDate
Add Days
StartDate.AddDays(10)
In the Future
StartDate > DateTime.Today
Year of Date
StartDate.Year
Date from Parts
DateTime(Year, Month, Day)
Common Yes/No Calculations
Constant Values
true
This Or That
AreYouAttending or AreYouPresenting
Comparisons
StartDate > "12/15/2015"
Equality
Quantity = 5
Choice (Checkboxes) Contains
Choice.Contains("First Choice")