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
building blocksPerforming a mailmerge Bulk e-mailing
ProgrammingSingle-threaded progress indicator in c#
Database menu itemsImport XML Save Copy As Integrity Check Change Password
Database Properties windowOpening the database properties window Record types tab Display types tab Roles and Users tabs Sidebar tab Database ID/Links tab Counters tab
Building blocksBuilding 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 topicsExpression 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
The 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 counter
There 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 fields
For 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) )
The term $value is replaced by the counter value (type int64). The formatting term  means to format the value with five digits. If the value was 6, the expression would yield CR00006.