Logical Functions
You can use mathematical functions in custom tables and fields. See Adding a Custom Table and Editing Field Formulas for further details. Below are explanations of 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.
The Lookup function imports a field from one table into another table, by matching two other corresponding fields from both tables. The result will be the value in remote_result_column for which the corresponding remote_match_column equals the current_match_column.
When there is no match between the fields, the returned value is 'N\A'.
For a short video demonstration of the Lookup function, see below:
.r.