Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Auto Number Options
A "Counter Value" allow to enter sequence starting number.

A "Format" consists of the substitution variables described below, plus any other characters you wish to include as a prefix or suffix.

{0} - Sequence number (required parameter). One or more zeros enclosed in curly braces represent the sequence number itself. The number of zeros in the curly braces dictates the minimum number of digits that will be displayed. If the actual number has fewer digits than this, it will be padded with leading zeros. Maximum is 10 digits.

{YY} or {YYYY} - Year (optional parameter). 2 or 4 "Y" characters enclosed in curly braces represent the year of the record creation date. You can display 2 digits (e.g., "04") or all 4 digits (e.g., "2004") of the year.

{MM} - Month (optional parameter). 2 "M" characters enclosed in curly braces represent the numeric month (e.g., "01" for January, "02" for February) of the record creation date.

{DD}- Day (optional parameter). 2 "D" characters enclosed in curly braces represent the numeric day of the month (e.g., "01" to "31" are valid days in January) of the record creation date.


Examples

No formatting. No leading zeros.
--------------------------------
Format: {0}
Sequence Number
1 250 5000
Formatted Number
1 250 5000

With leading zeros padded to 3 digits.
--------------------------------------
Format: {000}
Sequence Number
1 250 5000
Formatted Number
001 250 5000

With leading zeros padded to 6 digits.
--------------------------------------
Format: {000000}
Sequence Number
1 250 5000
Formatted Number
000001 000250 005000

4-digit year and month used as prefix to number.
-----------------------------------------------
Format: {YYYY}{MM}-{0}
Sequence Number
1 250 5000
Formatted Number
200504-1 200504-250 200504-5000

Prefix with "PO# " (including space.)
-------------------------------------
Format: PO# {00000000}
Sequence Number
1 250 5000
Formatted Number
PO# 00000001 PO# 00000250 PO# 00005000
ID
2
Category
TeamDesk
Date Created
11/3/2005 4:03:50 PM
Date Updated
8/7/2006 10:25:13 AM
Related articles
Was this information helpful?
 
Back to Search Results