Lotus Domino Designer 8.5 Help - Examples: @Transform

FORMULA LANGUAGE

Examples: @Transform
The following examples are translation formulas that transform the elements of the numeric multi-value field OriginalList. Assume that OriginalList contains the values 4, -4, and 16.

1. This formula returns a 3-element list whose values are 2, -2, and 4.

@Transform(OriginalList; "x"; @If(x >= 0; @Sqrt(x); -@Sqrt(@Abs(x))))

2. This formula returns the same as above. However, if OriginalList is null, this formula returns null rather than an error.

@If(OriginalList = @Nothing; @Nothing; @Transform(OriginalList; "x"; @If(x >= 0; @Sqrt(x); -@Sqrt(@Abs(x)))))

3. This formula returns a 2-element list whose values are 2 and 4.

@If(OriginalList = @Nothing; @Nothing; @Transform(OriginalList; "x"; @If(x >= 0; @Sqrt(x); @Nothing)))

4. This formula, when used in a hotspot button creates a field called originalCorrected that adds an asterisk to the beginning of each element in the "original" text list if it does not already have one.

FIELD originalCorrected := @Transform(original;"var";

@If(@Begins(var;"*");

var;

"*" + var))

See Also

@Transform

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary