Logical Functions
  • 18 May 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Logical Functions

  • Dark
    Light
  • PDF

You can use mathematical functions in custom tables and fields. See Adding a New Custom Table and Defining and Editing Field Formula for further details.

Following are descriptions for the available logical functions:

IFBIGINT(condition, true value, false value)
Returns the first value if the boolean evaluate is true, else returns the second value.

IFDATETIME(condition, true value, false value)
Returns the first value if the boolean evaluate is true, else returns the second value.

IFDOUBLE(condition, true value, false value)
Returns the first value if the boolean evaluate is true, else returns the second value.

IFINT(condition, true value, false value)
Returns the first value if the boolean evaluate is true, else returns the second value.

IFSTRING(condition, true value, false value)
Returns the first value if the boolean evaluate is true, else returns the second value.

INRANGE(value, start, end)
Returns true if a given value is between start and end.

ISNULL(value)
Returns true if a given value is null.

LOOKUP(remote_table,remote_result_column,current_match_column, remote_match_column) The Lookup function imports a field from a remote table into the current table, by matching the values of current_match_column and remote_match_column, and importing the value from remote_result_column. When there is no match between the fields, the returned value is 'N\A'.

The LOOKUP function is only for defining custom columns. It cannot be used for custom tables.

The following is a video demonstration of the Lookup function.


Was this article helpful?