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 for which you want to add an input translation formula. |
3. | Select Input Translation on the Objects tab. |
4. | Enter a formula in the Programmer's pane. |
5. | Save the form. |
The following example demonstrates a simple input translation formula that trims leading and trailing spaces off the value in a field:
@Trim(tLastName);
3.137.176.166