We can use formulas to gather data from the other fields into an equation and create a new field with the result.

In order to create a formula, we should first choose the field type of the result; it can be a text, number, date, boolean, website link or a currency.



After choosing the field type of the end result, we can start creating our formula by clicking on the box below ('to be computed'). On the list that will open we can see the fields we have and the operands we can use. A formula can start with a field or with an operands such as MIN(), MAX(), COUNT() or MonthName...

Example - 1 :
We have a social media planning app and we want to automatically add the character count of the post, in order not to exceed the limits of certain platforms.
We are adding the formula : len( {{Copy}} )



Example - 2 :
On our social media planning app, we have a publish date field. We want to create a deadline for the designer to get the image ready 3 days before the publish date, so we will create a new field as a date for the design deadline.
The formula we use : {{Publish Date}} - 3



Operators

- And :The input operands are converted to boolean. See the Convert To Boolean (Object) method for the conversion logic
Operand1 : any
Operand2 : any
Output Type: Boolean

Example: 3 > 2 and 2 > 1

- Or : The input operands are converted to boolean.
Operand1 : any
Operand2 : any
Output Type: Boolean

Example: 3 > 2 or 2 = 1

- Not :

- Equal :

- Not Equal :

- GreaterEqual : Infix GreaterEqual operation.

Operand Count: 2
OperandsOperand1 : anyOperand2 : any
Output Type: Boolean

Usage: 3 >= 2

- GreaterThan : Infix GreaterThan operation.

Operand Count: 2
OperandsOperand1 : anyOperand2 : any
Output Type: Boolean

Usage: 3 > 2

- LessEqual : The LessEqual to operator (<=) returns TRUE if the first value is less than or equal to the second value.

Operand Count: 2
OperandsOperand1: anyOperand2: any
Output Type: Boolean

- LessThan : The LessEqual to operator (<) returns TRUE if the first value is less than the second value.

Operand Count: 2
OperandsOperand1: anyOperand2: any
Output Type: Boolean

- Plus :

- Minus :

- Multiply :

- Divide :

- Mod :

- Power :

- Month :

- Month Name :

- Short Month Name :

- Now :

- Today :

- Year :

- Pad Left :

- Pad Right :

- Pi :

- Rigth :

- Array() :

- Operand Count() :

- Average() : Prefix operation that return the average of a set of numbers

Operand Count: 0 to infinite
Operand Type: Number, if the operand count is 1, it can be an array
Output Type: Number

Example: avg(1, 2, 3, 4, 5) or avg(@(1, 2, 3, 4, 5))

- Round() : Prefix operation that return the Round of decimal numbers

Operand 1: Decimal number will be rounded
Operand 2: Number of digits
Operand Type: Number
Output Type: Number

Example: Round(1.2323) = 1 Round(4.2312321, 2) = 4.23

- Coalesce() : Prefix operation that return the first non null operand

Operand Count: 1 to infinite
Operand Type: any

Example: Coalesce(null, 1, 2, 3) will return 1

- Create Date() : Prefix operation that create an date

Operand Count: 3
Operands year : Numbermonth : Numberday : Number
Operand Type: int
Output Type:DateTime

Usage: CreateDate(2018, 1, 31)

- Date() : Prefix operation that convert input to date. The operand is converted to text first and parsed to a datetime object

Operand Count: 1
Operandsinput : anyOutput Type: DateTime

- Format() : Prefix operation that will take an input and C# format string and produced a formatted string

- If() : Prefix if operation

Operand Count: 2 or 3
Operandscondition: anyresult when true: anyresult when false, if omitted, will be default to null: any
Output Type: any

Usage: if( 3 > 2, "OK", "No")

- Is Blank() : Prefix operation to check if the input IsBlank

Operand Type: any
Null, empty string and string with only white space are considered as blank

- Left() : Prefix operation that return the substring of the input text with the specified length and start index of 0

Operand Count: 2
Operandsinput: stringcount: Number
Output Type: string

Usage: Left("test", 1) should return "t"

- Len() : The Len function returns the length of a given text string as the number of characters. Len will also count characters in numbers, but number formatting is not included.

Usage: Len(text)

- Max() : The Max function returns the largest numeric value in a range of values.

Operand Count: 1 to infinite
Output Type: Number

Max(number1, [number2], ...)

- Min() : The Min function returns the smallest numeric value in a range of values.

Operand Count: 1 to infinite
Output Type: Number

Min(number1, [number2], ...)
Was this article helpful?
Cancel
Thank you!