Text Function Guidelines
Provided below are some guidelines for using text functions correctly.
• Constant strings used in text calculations must be enclosed with quotes. For example: “abc” + “def”
• Function calls must be preceded with a $ sign. For example: $concatenate(“a”, “b”, “c”)
• A constant must be preceded with an @ sign and be enclosed in parentheses. For example: $ifthenelse(UserText1 == “a”, “Value = A”, @(BLANK))
• If the result is stored in a field tied to a list, then the resulting string is added to the list if it is not already present. When a new list item is added in this fashion, the resulting string is used for both the list item code and the list item display text.
• If the result field is a memo field that is a hyperlink, then the text value is stored as the URL and the display text is left blank. For example, the display text shows the URL. If the source field is used as a hyperlink, then the text used in the calculation is the display text, as it is shown in a table cell. For more information, see Setting Up a Memo Field as a Hyperlink.
• Calculation results can be stored in fields tied to a user or group list or to the User field or Group field. When the calculation result matches a list choice, it is saved to the field. If the result does not match a list choice, the field is cleared and a #MISSING# designation is shown.
 |
For results to be saved to the User field or Group field, you must be logged in as a member of the Administrators group. For Microsoft Active Directory (AD) users and group, the result must be for a user or group that has been inserted in the Administrator application.
|