Examples: Creating a formula for an editable field
Default value formula examples
The default value formula provides an initial value for an editable field. You can set the value to a specific number or text string, or you can use a formula. For example:
|
The formula |
Returns |
|---|---|
|
0 |
The number 0 |
|
@Now |
The current time and date |
|
@Name([CN];@Username) |
The common name portion of a user's hierarchical name |
|
Price |
The value of the field named Price |
|
"Connecticut":"New York":"New Jersey" |
A text list containing Connecticut, New York, New Jersey |
|
Product + ", " + Department |
The value of the field named Product, followed by a comma and a space, and the value of the field named Department |
Example: Input translation formula
The following formula translates the text in the Attorney field for display with initial capital letters. If a user enters the text john smith in the Attorney field, it is translated to John Smith when the document is saved.
@ProperCase(Attorney); The following formula gives documents a uniform look by capitalizing the initial letter of the value in the Subject field and removing extra spaces.
@Trim(@ProperCase(Subject));Input validation formula examples
|
Field criteria |
Formula |
|---|---|
|
User must enter a value that is less than 100 in Cost field |
@If(Cost<100;@Success;@Failure("Cost must be less than $100.")); |
|
User must enter a value for the Subject field |
@If(Subject = ""; @Failure("You must enter a subject for your document."); @Success) |