Lotus Notes® and Domino® 6 Application Development Exam Cram™ 2 (Exams 610, 611, and 612)

Create Translation Formulas

If you want to ensure that data in certain fields is formatted properly, you can use an input translation formula. When a document is saved or refreshed, the input translation formulas in the fields on the form are executed. Input translation formulas can do a number of tasks, such as

• Trim leading and trailing spaces off a value (@Trim).

• Make a value all uppercase or lowercase (@UpperCase or @LowerCase).

• Make a value, such as a name, a proper noun (@Propercase).

• Mask values such as zip codes or phone numbers by inserting characters such as hyphens, parentheses, periods, and/or commas.

To add an input translation formula to a field, follow these steps:

1.	Open the form in the Designer client.
2.	Select or create the field ...