You can use the Map Values field on the Expression Configuration for Auto Numbering dialog box to map values for lookups, drop-downs, check boxes, and the current month and year.
Mapping values creates a relationship between data where Vision substitutes the map value instead of the actual value entered within a field. This enables better customization of the auto number to match your business requirements.
For example, assume you would like to generate the first two characters of your employee’s auto number based on the employee's regional location in the United States: Northeast, Northwest, Southeast, or Southwest.
To do so, you complete the following actions:
- Select EM.State as an Item on the Expression Configuration for Auto Numbering dialog box.
- Set the Length Used in Number field to 2.
- Click the Map Values column to open the Mapped Values dialog box.
- Insert states Vermont, New Hampshire, Massachusetts, and Connecticut in the Value in Vision column.
- Set the Value for Use in Number to NE for all.
- Complete the same steps for the states of Florida, Alabama, North Carolina, and South Carolina, but set the Value for Use in Number as SE.
- Save your changes.
When the auto number is generated, the first two numbers will be based on the employee's regional location.