FORMULA LANGUAGE

Examples: Writing formulas that perform actions
This agent example substitutes "Wayside Drive" for "Wayside Street" in the Address field of documents based on the Main Form. The effective action is the FIELD Address assignment. If Address contains "Wayside Street," the new Address consists of the characters to the left of "Wayside Street," the string "Wayside Drive," and the characters to the right of "Wayside Street." Otherwise, Address is reset to its current value.

SELECT Form = "Main Form";
ws := "Wayside Street";
wd := "Wayside Drive";
FIELD Address := @If(@Contains(Address; ws); @Left(Address; ws) + wd +
@Right(Address; ws); Address)

See Also