SQL Expression Builder for Auto Numbering Dialog Box

When you use Expressions to set up automatic numbering, you can create an auto number format based on any of the fields in the Projects, Employees, Vendors, Clients, Opportunities, and Marketing Campaigns Info Centers.

Use the Expression Configuration for Auto Numbering dialog box to create SQL expressions for auto numbering.

Location

To display the dialog box, complete the following steps:

1. From the Vision Navigation menu, click Configuration > General > System Settings.
2. Click the Numbering tab.
3. In the Auto Number Source field, select Expression from the drop-down list.
4. In the Auto Number Format field, click .
5. In the Argument Value field, click .

Contents

Field	Description
Columns	Select the column for which you want to create an expression. To select a field, double-click it or select it and click Add Field. The field name displays in the Expression grid. Calculations can be simple or complex. You can create calculations with the Calculator or Use a Condition tools. All character and string type fields are added to the expression with qualifiers (single quotes) around them when you click the Add Column button. All numeric type fields are added with no qualifiers.
Calculator	Use the Calculator tool to create simple expressions with numbers and math calculations. You can click the calculator to select a number or symbol. You can also enter the number or symbol directly in the Expression grid.
Use a Condition	Select this tool to create more complex expressions with conditions. When Use a Condition is activated, three additional fields display in the Expression grid: If this is true Use this calculation Otherwise use this calculation Use these three fields to create the SQL expression.
Expression	This field displays the expression that you created. You can also enter conditions directly into this grid. To insert a column, click Insert. If you choose the Use a Condition option, first select the Expression field for which you want to enter a column, then click Insert. Vision displays a list of columns available for that Info Center. To undo the last change you made, click Undo Last Change. To clear the expression, click Clear Expression.