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:

The following example demonstrates a simple input translation formula that trims leading and trailing spaces off the value in a field:

@Trim(tLastName);