Lotus Domino Designer 8.5 Help

FORMULA LANGUAGE

Examples: @For
1. This agent displays the elements of the Categories field one at a time.

@For(n := 1; n <= @Elements(Categories); n := n + 1; @Prompt([OK]; "Category " + @Text(n); Categories[n]))

2. This computed field formula concatenates the list elements in the fname and lname fields:

@For(n :=1; n<=@Elements(fname); n:= n + 1; full := @If(n=1;fname[n] + " " + lname[n];full : (fname[n] + " " + lname[n]))); full

If fname contains: "Catherine":"Patricia":"Maureen" and lname contains: "Rolling":"Kearns":"Legacy", the result is: "Catherine Rolling;Patricia Kearns;Maureen Legacy." If fname and lname each contain a different number of elements, be sure to include the field that has fewer elements in the @Elements function or an "Array index out of bounds" error results.

3. This computed field formula displays the longest name in a text list of poets names stored in the poets field. If the poets field contains "T.S. Eliot":"Dorothy Parker":"Edna St. Vincent Millay":"e.e. cummings": this field displays Edna St. Vincent Millay.

temp := "";

@For(n := 1; n <= @Elements(poets); n := n + 1;

@If(@Length(poets[n])>@Length(temp);

temp := poets[n];temp));

temp

See Also

@For

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary