FORMULA LANGUAGE


Examples: @DocumentUniqueID
1. This column formula displays the UNID of each document in the view.
2. This computed field formula creates a doclink to the current document.
3. This "Computed when composed" field formula in a "Response" document creates a doclink to the parent document. In the properties box for the "Response" form, "Formulas inherit values from selected document" must be checked.
4. You want the Project field of a new "Response" document to match the Project field of the parent "Main Topic" document. In the properties box for the "Response" form, check "Formulas inherit values from selected document." Make Project on the "Response" form a computed field and give it this formula:
5. Field inheritance only happens once when the Response is created. However, you want to access the "Main Topic" after the "Response" is created. Create an agent that runs on a schedule, selects all documents in the database that use the form "Response," and runs the following formula:
6. This is a long solution to the above problem. Create a hidden view called, for example, "By doc ID" with the following selection formula:
See Also