Skip to content

Variables

There are 2 different variables:

  1. System Variables
  2. Logical Column Variables

System Variables

Statement returning system data. Below the entire list with syntax and description:

System Variable Syntax Description
Current Date $CURRENTDATE returns the current system date
Current Domain Id $CURRENTDOMAIN.ID returns a string containing the Id of the current Domain
Current Domain Name $CURRENTDOMAIN.NAME returns a string containing the name of the current Domain
Current User Logon Date $CURRENTUSER.CURRENTLOGONDATE returns a date time containing the current logon date for the current User
Current User Departments $CURRENTUSER.DEPARTMENTS returns a string containing a list of the departments for the current User
Current User Email $CURRENTUSER.EMAIL returns a string containing the email of the current User
Current User Group Ids $CURRENTUSER.GROUPIDS returns a string containing the Ids of the Group the current User belongs to
Current User Group Name $CURRENTUSER.GROUPNAMES returns a string containing the names of the Groups of the current User
Current User Last Logon Date $CURRENTUSER.LASTLOGONDATE returns a date time containing the last logon date for the current user
Current User Logon Name $CURRENTUSER.LOGONNAME returns a string containing the logon name of the current User
Current User Name $CURRENTUSER.NAME returns a string containing the name of the current User
Current User Surname $CURRENTUSER.SURNAME returns a string containing the surname of the current User
Current User Id $CURRENTUSER.USERID returns a string containing the system-id of the current User

Logical Column Variables

Statement based on Calculated Logical Columns.

After creating a Calculated Logical Column in Design Mode, there's a tooltip near the Select Type, to copy the variable name (1) and, after the operation was successful (2), paste it in a Formula Editor (3):

Syntax

The variable's name is generated by:
- two dollars symbols ($$)
- the name assigned by the User
- no special characters
- underscore symbol instead spaces

$$Calculated_Logical_Column

Usage

It's possible to use Calculated Logical Columns variables mainly in Design Mode Layout formulas.

Example:

1
2
3
4
5
=CELLIF(
    =CELLEQ($$Calculated_Logical_Column; 0);
    "red";
    "green"
)