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 preceding "Wayside Street," the string "Wayside Drive," and the characters following "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)