FORMULA LANGUAGE


Examples: @SetDocField
1. This formula, if placed on a button in a response form, changes the Subject of the parent document to "More people are commuting by bicycle." $Ref is a special field on a response document that contains the unique ID of the parent document.
2. This button formula changes the value of the name field in the current document to Joseph Riley:
3. In a database, you want to update the parent Project document whenever its child Status document changes. Each Project document has one Status document. Specifically, you want to update the latestStatus field on the Project document so that it reflects the contents of the lastAction field on the child Status document.
4. This button formula uses @DbLookup to retrieve the unique ID of a particular document. It then changes the value of the "employee title" field in that document to "sales associate."
See Also