Skip to content

Configure counters

Counters enable the automation of information to be counted. A typical example is the invoice number, which is incremented with every new invoice created.

// Example
Invoice no.: 2024-01-0211

Counters are visible in a new record. A counter field is configured in the corresponding record type.

The following actions are possible for counters:

Counter management

The image shows the counter administration: (1) navigation, (2) button Edit Edit, (3) overview of all counters, (4) button Add Add

The two buttons Edit Edit and Add Add open the counter configurations, which are used to edit the counter.

Attention

Changes in system settings often only take effect when a restart is carried out after closing the system settings (menu item under the button with the user name at the top right, see also introduction).

Counter configurations

The counter configuration will open when you add and edit counters:

Counter configuration

The image shows the counter configuration: (1) button Add counter Add, (2) button Load counter Load, (3) field Counter name, (4) field Counter reading, (5) field Counter definition, (6) possible counter definitions for the automated part of the counter, (7) button Delete counter Delete, (8) button Save counter Save

The following table explains all elements of the counter configuration:
Name Meaning Note
button Add counter the currently open counter is closed, a new empty counter can be edited
button Load counter select another counter
counter name (meaningful) name to identify the counter counter name can no longer be edited after saving
field Counter reading enter the initial value of the counter the initial value must be a integer without decimal places
field Counter definition configuration of the counter the definition must contain at least one control character for the counter. Free text and control characters can be freely combined, e.g. Invoice %Z results in Invoice 173
options for the counter definition shows the control characters for the automated components
button Delete counter the currently open counter will be deleted A counter cannot be deleted if it is used in a record type.
button Save counter the currently open counter will be saved

Add a counter

A new counter can be added in two ways:

Add a counter using the button Add Add

  1. click the button Add

    The counter configuration will open

    Counter configuration

    The image shows the counter configuration: (1) button Add counter Add, (2) button Load counter Load, (3) field Counter name, (4) field Counter reading, (5) field Counter definition, (6) possible counter definitions for the automated part of the counter, (7) button Save counter Save

  2. enter a meaningful name in the field Counter name to identify the counter

    Warning

    The counter name can no longer be changed after the initial saving!

  3. enter the initial value of the counter in the field Counter reading

    The start value will be the first value used by the counter.

    The start value must be a integer without decimal places.

    Important

    If the entered text is red, it is incorrect. Please check the entry.

  4. enter the desired configuration of the counter in the field Counter definition

    Free text and control characters may be freely combined.

    The definition must contain at least one of the control characters for the counter, which are marked as required fields in the following table.

    Table with all control characters
    Control character Obligatory? Description
    %Z yes counter (reset at the end of the year)
    %z yes counter (will not be reset)
    %Z4 yes counter filled with zeros up to the thousands range (will be reset)
    %z4 yes counter filled with zeros up to the thousands range (will not be reset)
    %J no year 4-digit
    %j no year 2-digit
    %M no month 2-digit
    %m no month 1-digit (0 .. c)

    Important

    If the entered text is red, it is incorrect. Please check the entry.

  5. the fully filled out counter configuration:

    Counter configuration

    A preview will be displayed in the frame next to the counter definition.

  6. click the button Save counter Save (if you want to cancel, click the button X at the top right)

    The counter configuration will close and the counter administration in the Counter menu will be displayed again.

Add a counter using the counter configuration

Counter configuration

The image shows the counter configuration: (1) button Add counter Add, (2) button Load counter Load, (3) field Counter name, (4) field Counter reading, (5) field Counter definition, (6) possible counter definitions for the automated part of the counter, (7) button Delete counter Delete, (8) button Save counter Save

  1. click the button Add Add in the currently open configuration

    The fields will be cleared

    Counter configuration

  2. follow the instructions from step 2 under Add using the button Add Add

Edit a counter

You can edit a counter in two different ways:

Edit a counter using the button Edit Edit

  1. click the button Edit Edit

    The counter configuration will open

    Counter configuration

    The image shows the counter configuration: (1) button Add counter Add, (2) button Load counter Load, (3) field Counter name, (4) field Counter reading, (5) field Counter definition, (6) possible counter definitions for the automated part of the counter, (7) button Delete counter Delete, (8) button Save counter Save

  2. if required, edit the field Counter reading and enter a new start value for the counter

    The start value will be the first value used by the counter.

    The start value must be an integer without decimal places.

    Important

    If the entered text is red, it is incorrect. Please check the entry.

  3. if required, edit the field Counter definition and enter the desired configuration of the counter

    Free text and control characters can be freely combined.

    The definition must contain at least one of the control characters for the counter, which are marked as required fields in the following table.

    Table with all control characters
    Control character Obligatory? Description
    %Z yes counter (reset at the end of the year)
    %z yes counter (will not be reset)
    %Z4 yes counter filled with zeros up to the thousands range (will be reset)
    %z4 yes counter filled with zeros up to the thousands range (will not be reset)
    %J no year 4-digit
    %j no year 2-digit
    %M no month 2-digit
    %m no month 1-digit (0 .. c)

    Important

    If the entered text is red, it is incorrect. Please check the entry.

  4. see the fully filled out counter configuration:

    Counter configuration

    A preview will be displayed in the frame next to the counter definition.

  5. click the button Save Save (if you want to cancel, click the button X at the top right)

    The counter configuration will close and the counter administration in the Counter menu will be displayed again.

Edit a counter using counter configuration

Counter configuration

The image shows the counter configuration: (1) button Add counter Add, (2) button Load counter Load, (3) field Counter name, (4) field Counter reading, (5) field Counter definition, (6) possible counter definitions for the automated part of the counter, (7) button Delete counter Delete, (8) button Save counter Save

  1. in the open counter configuration, click the button Load Load counter to select a new counter

    The selected counter will be displayed.

  2. follow the instructions from step 2 under Edit using the button Edit Edit

Delete a counter

Important

A counter cannot be deleted if it is used in a record type!

A counter will be deleted in the counter configurations.

  1. in the counter administration, click the button Edit Edit of the counter you want to delete

    The counter configuration will open

    Counter configuration

    The image shows the counter configuration: (1) button Add counter Add, (2) button Load counter Load, (3) field Counter name, (4) field Counter reading, (5) field Counter definition, (6) possible counter definitions for the automated part of the counter, (7) button Delete counter Delete, (8) button Save counter Save

  2. click the button Delete counter Delete

    The following window opens:

    Delete confirmation

  3. click the button Yes (or on the No button or the X button at the top right if you want to cancel)

    The counter configuration will close and the counter administration in the Counter menu will be displayed again.

Export a counter as CSV file

Selected counters from the list can be exported.

Export counter

The image shows the list with all counters: (1) checkbox to select row, (2) button Export selected data as CSV CSV-Export

  1. select the rows you want to export

  2. click the button Export selected data as CSV CSV export

    The CSV file will be downloaded and saved in the download folder (or the folder that was set for it in the browser).

    The file name will be generated automatically and will be called #Counter definitions.csv.

A list with the following information will be exported:

Column Meaning
name name to identify the counter
definition counter configuration from free text and control characters
counter reader start value of the counter