Skip to main content

Expression builder

In various places in your Applaud tenant, you can type your own bespoke messages and include dynamic content using field and function expressions.

Fields

Fields are look-ups to model property values.

To insert a model's property value, type "@" or select the Token located to the right of the field and select one from the list.

FieldList.png
Expression Description
triggeringUser.Name The user's name who made the change to the property value.
triggeringUser.Email The user's email who made the change to the property value.
triggeringInstanceOwner.Name The user's name who created the model property in your Applaud tenant.
triggeringInstanceOwner.Email The user's email who created the model property in your Applaud tenant.
triggeringInstance.Owneruser Tenant-specific user record, which is only on that single tenant.
triggeringInstance.StartDate Displays the model's property value. For example, this would show the start date value, for example, 12/03/2021. The rest of the list shows the rest of the model's properties. For example:
  • triggeringInstance.FullName
  • triggeringInstance.Job
  • triggeringInstance.Department

User IDs

There are two user IDs used in the Applaud system. One is for when customers have multiple tenants and so can be used across all tenants. One is for use on a single tenant only.

triggeringInstance.Owner Application-wide user record, which is used across multiple tenants.
triggeringInstance.Owneruser Tenant-specific user record, which is only on that single tenant.

Functions

To use a function to format or alter your property value, type "#" or select Token to the right of the field and select one from the list.

FunctionList.png

When you select the function to use, most functions open some options for you to select.

Numbers

For example, if you have a Salary property, you could want to make sure that any values are rounded up to two decimal places.

Expression Description Example Output
Number Round()

Rounds the value to the selected number of decimal places.

You can choose to round:

  • Up
  • Down
  • Nearest - either up or down, whichever is nearest. For example, anything over 0.5 would be rounded up, and anything under 0.5 would be rounded down.
 NumberRound(NumberTypeProperty, 2, nearest)
NumberRound.png
 30000.00
Number To Text() Changes the property type from a number type property to a text type property. NumberToText(NumberTypeProperty)
NumberToText.png
 30000
Number To Date() Converts the JavaScript of a date number to an ISO date string. NumberToDate(NumberTypeProperty)
NumberToDate.png
 2021-06-22
Number To Boolean() Converts the selected number property to Boolean values given. NumberToBoolean(NumberTypeProperty, 1, 0)
NumberToBoolean.png

Output:

1 = True Boolean value

0 = False Boolean value.
Random Number() Generates a random number in a given range of min and max value with specified decimal places. RandomNumber(1, 10, 2)
RandomNumber.png
 For example, a random number like 4.25.

Boolean

Use these expressions to configure true or false statements.

For example, we have a Boolean-type property called "On annual leave."

Expression Description Example Output
Boolean Invert() Returns Invert of selected Boolean property value. BooleanInvert(BooleanTypeProperty)
BooleanInvert.png
 true
Boolean To Text() Returns selected Boolean property selected true or false values. BooleanToText(BooleanTypeProperty, On Leave, Not On Leave)
BooleanToText.png
 False-F
Boolean To Number() Returns selected Boolean property to number. BooleanToNumber(BooleanTypeProperty, 1, 0)
BooleanToNumber.png
 0

String

Use these expressions to format text.

For example, we have a text-type property with the value of "the quick brown fox."

Expression Description Example Output
To Upper Case() Converts all the characters in the property to capital letters. ToUpperCase(triggeringInstant.TextTypeProperty)
UpperCase.png
 THE QUICK BROWN FOX
To Lower Case() Converts all the characters in the property to lower case letters. ToLowerCase(triggeringInstant.TextTypeProperty)
LowerCase.png
 the quick brown fox
To Camel Case() Converts all the characters in the property to camel case, which removes spaces and capitalizes the first letter of each word. ToCamelCase(triggeringInstant.TextTypeProperty)
CamelCase.png
 TheQuickBrownFox
To Title Case() Converts the selected text property to title case. ToTitleCase(triggeringInstant.TextTypeProperty)
TitleCase.png
 The Quick Brown Fox
To Sentance Case() Converts the selected text property to sentence case. ToSentanceCase(triggeringInstant.TextTypeProperty)
SentenceCase.png
 The quick brown fox
First Few Characters() Accept and store only the selected number of the first few characters of the selected text property. FirstFewCharacters(triggeringInstant.TextTypeProperty, 3)
FirstFew.png
 the
Last Few Characters() Accept and store only the selected number of the Last few characters of the selected text property. LastFewCharacters(triggeringInstant.TextTypeProperty, 3)
LastFew.png
 fox
Remove White Space() Removes the white-spaces in the selected text property. RemoveWhiteSpace(triggeringInstant.TextTypeProperty)
RemoveWhiteSpace.png
 thequickbrownfox
Replace Text() Finds the text you specify and replaces with the text that you specify. ReplaceText(triggeringInstant.TextTypeProperty, quick, slow)
ReplaceText.png
 the slow brown fox
Split Text() Splits the selected text property with the given separator and the occurrence of it. The separator can be a space " ", hyphen "-", underscore "_", or colon ":". The index is the text you want to display. SplitText(triggeringInstant.TextTypeProperty, separator, index)
SplitText.png

SplitText("The quick brown fox", , 2)

Output:

quick
String To Number() Converts convert the string "1234" to number 1234. StringToNumber(triggeringInstant.TextTypeProperty)
StringToNumber.png
 Text type property converted to a number type property. For example, if the Salary property value was 30000, this would convert the text to a number.
String To Date() Converts the ISO date string to the moment date object. StringToDate(triggeringInstant.TextTypeProperty)
StringToDate.png

Examples of what format the date string needs to be in for this to work:

Input:

  • 2020-06-18
  • 2020/06/18
  • 03/25/2020
  • UTC: 2020-03-25T12:00:00-06:30
  • ISO: 2020-03-25T12:00:00Z

Output:

  • 2020-06-17T18:30:00.000Z
String To Boolean() Converts the selected text property, whatever that is, for example, "Yes", "No" or "True", "False" to a Boolean True or False value. StringToBoolean(triggeringInstant.TextTypeProperty, True, False)
StringToBoolean.png

True = 1

False = 0

Date

Use the date functions to modify a date property.

For example, we have a date-type property with the value of Wednesday 10th November 2021 or "11/10/2021."

Expression Description Example Output
Date Add()

Adds a unit of time to your original date.

Units include:

  • Seconds
  • Minutes
  • Hours
  • Days
  • Months
  • Years

DateAdd(DateTypeProperty, 10 days)

DateAdd.png
 Sat Nov 20 2021 00:00:00 (Time zone)
Date Subtract()

Removes a unit of time from your original date.

Units include:

  • Seconds
  • Minutes
  • Hours
  • Days
  • Months
  • Years

DateSubtract(DateTypeProperty, 5, days)

DateSubtract.png
 Fri Nov 5 2021 00:00:00 (Time zone)
Date To Number()

Changes the date to a number format.

Formats include:

  • Seconds
  • Minutes
  • Hours
  • Day of month
  • Day of week
  • Week number
  • Month Number
  • Full Year

DateToNumber(DateTypeProperty, dayofmonth)

DateToNumber.png
 10
Date To Text()

Changes the date to a text format.

Formats include:

  • Seconds
  • Minutes
  • Hours
  • Day of month
  • Day of week
  • Week number
  • Month Number
  • Full Year

DateToText(DateTypeProperty, dayofweek)

DateToText.png
 Wednesday
Today() Shows today's date. Today() Today's date.

Sections in this article