Formula Message
The Formula Message function allows you to create messages that will open in a checklist based on input. The result of the Formula Message (TRUE or FALSE) controls if the Message appears. In the Lines FastTab, you assign a message to individual lines and can include placeholder variables.
Example
The following video uses the checklist template with the formula function for calculating length and width plus two answer lines to show a message if the result is:
- greater or equal to 10 square meters
- less than 10 square meters
The "C_MESSAGE" variable is assigned to the answer lines and used with the "C_QM" result variable in the Formula Message field to determine which message is used based on the calculation of square meters:
(C_MESSAGE) AND (C_QM >= 10) (C_MESSAGE) AND (C_QM < 10)
For each answer, a message is created indicating that it's less than or more than 10 square meters, along with the total in parentheses from the result variable. The Message Exists field indicates that a message exists for the line.
After length and width values are entered with a result of 9, the Selected checkbox is selected on the Show Formula Message line. The message opens stating that "Less than 10 SQM are calculated (9)". The values are changed to a result of 18, and due to the Automatic Overwrite setting, the message automatically opens stating that "More than 10 SQM are calculated (18)".
See Also
Feedback
Submit feedback for this page .