.

HCLSoftware Business Partner
Domino Consulting Services
CRUCIAL Notes Tools
+1 212-599-2048

Domino Consulting Services
CRUCIAL Notes Tools
Domino administration
Notes development

Facebook Twitter YouTube
Chat now       
.
ProductsDownloadsNewsAbout usContact


Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

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