Difference between revisions of "Auto Values"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | __NOTOC__[[Main_Page|Home]] > [[Administration]] > [[Data]] > Auto Values {{#ev:youtube|_9Dduf-Ga10|400|right}} | + | __NOTOC__[[Main_Page|Home]] > [[Administration]] > [[System Administration|System]] > [[Data]] > Auto Values {{#ev:youtube|_9Dduf-Ga10|400|right}} |
==Introduction== | ==Introduction== | ||
The Auto Values feature lets an administrator define how auto-generated values, such as reference IDs, are constructed. Places where more than a sequence number (000001234) is required, an Auto Value can be modified to include dates, time, location, teams, user IDs and more. There are many situations where this type of sequence is much more preferable over a simple numeric sequences. Some examples include: | The Auto Values feature lets an administrator define how auto-generated values, such as reference IDs, are constructed. Places where more than a sequence number (000001234) is required, an Auto Value can be modified to include dates, time, location, teams, user IDs and more. There are many situations where this type of sequence is much more preferable over a simple numeric sequences. Some examples include: |
Revision as of 01:51, 22 November 2016
Home > Administration > System > Data > Auto Values
Introduction
The Auto Values feature lets an administrator define how auto-generated values, such as reference IDs, are constructed. Places where more than a sequence number (000001234) is required, an Auto Value can be modified to include dates, time, location, teams, user IDs and more. There are many situations where this type of sequence is much more preferable over a simple numeric sequences. Some examples include:
- Shipment numbers
- Document or Article Reference Numbers
- Stock Item Codes
- Asset ID's
- Access Code numbers
Auto Value Configuration
- Description
- Add Auto Value Component
- Current Value
- Daily Increment
- Monthly Increment
- Yearly Increment
- Time last generated
Available Auto Value Component Parts
The following lists of component parts are available to construct an auto value.
seq( z, r ) |
| ||||||||||||||||||||||
seqd( z, r ) |
| ||||||||||||||||||||||
seqm( z, r ) |
| ||||||||||||||||||||||
seqy( z, r ) |
| ||||||||||||||||||||||
| |||||||||||||||||||||||
date( [part] ) |
| ||||||||||||||||||||||
udate( [part] ) |
| ||||||||||||||||||||||
uuid( [type] ) |
| ||||||||||||||||||||||
sess( prop_name ) |
| ||||||||||||||||||||||
param(param_name) |
| ||||||||||||||||||||||
rec( column_name ) |
|