Use Mapsly formula builder to define criteria for a view or a layer. Only records that match these criteria become be shown within this view or layer.
The formula may contain one or multiple logical expressions connected with a logical AND or OR operator. Expressions can be nested.
An expression consists of two operands and a logical operator:
- the left operand is always a record field;
- the right operand may be one of the following:
(a) a constant value (like 20, Vendor or a list of picklist values),
(b) another field of the same record;
(c) type-specific dynamic value (like Now, Today, Start of current month);
(d) or the current Mapsly user's property: name, email, CRM user record id);
- the list of operators depends on the type of the left operand.