Documentation
Home
Evaluation
Summary for programmers
Product limitations
Goals of Axisbase
Quick start
Installation
Using the launchpad and opening databases
Connecting to a sample database
Using building blocks
Planning
Define the purpose
Define the requirements
Borrow existing work
Determine the architecture
Design the data model
Design the process model
Deploy and maintain the product
Tutorials
building blocks
Performing a mailmerge
Bulk e-mailing
Programming
Single-threaded progress indicator in c#
Reference
Database menu items
Import XML
Save Copy As
Integrity Check
Change Password
Database Properties window
Opening the database properties window
Record types tab
Display types tab
Roles and Users tabs
Sidebar tab
Database ID/Links tab
Counters tab
Building blocks
Building blocks window
Editing grids and cells
Hyperlinks and nesting
Data Subset window
Data Outsource window
List window
Window window
Report window
Bulk Operation window
Label Printer window
Choosing a data source
Special topics
Expression syntax
Browse records
Storing building blocks within other building blocks
Programming
Using custom code in building blocks
Using Axisbase as an embedded database
Axis1.Util namespace reference
Axis1.Data namespace reference (Fishnets)
Axis1.Data namespace reference (other)
Axis1.Forms namespace reference
| Counters tabThe counters tab of the database properties window is where you define all counters. Counters are used for automatically numbering records. The three columns are:
Hooking up a property to a counterThere are three separate things that have to be set to make the connection between a property of a record and a counter.
If you plan in advance, it is easier to create counters, then display types, then record types. Every time you edit a record in a list, if the auto-number property (the one connected to the counter) is empty, the counter is activated, and the next value is applied. No matter how many users are entering records at a time, the values will be unique. By the way, you can export and import counters because they are records just like any other record. Using counters with string fieldsFor numeric fields, the counter is normally used without an expression, and the number is incremented and copied over each time you create a record. If you use a string field, it could be that you want a numbering system that is more complicated, like CR00032, CR00033, etc. or some other formatting requirement. To do this, use an expression such as this example: "CR" ($value) [00000]) The term $value is replaced by the counter value (type int64). The formatting term [00000] means to format the value with five digits. If the value was 6, the expression would yield CR00006. |