The Numbering widget offers a versatile solution for generating unique IDs with auto-increment functionality




2.0.0 (updated on 2022-08-20)


Labii Inc.



Support Configuration


Support Readonly view


Support Edit view


Support Form view


Support Default value


Support Import


Allow multiple



The Numbering widget offers a versatile solution for generating unique IDs with auto-increment functionality. Tailored for seamless integration into various systems, it allows users to effortlessly create their own IDs with customizable auto-increment settings. Users can opt for reset options based on monthly cycles or specific column criteria, ensuring efficient organization of data. Additionally, the widget provides the flexibility for automatic generation of numbering sequences, while also enabling manual updates when necessary. With its user-friendly interface and adaptable features, the numbering widget streamlines the process of ID generation and management, catering to diverse user requirements with ease.

Use case

  • Generate user specific ID.


The widget is designed to function immediately without requiring any configuration. Nevertheless, you have the option to utilize the configuration settings to customize the ID.

  • Format - The format of ID. - YYYY, 4 digits of year (2020) - YY, 2 digits of year (20) - MM, 2 digits of month (07) - DD, 2 digits of day (31) - INDEX, the serial ID (1) - LETTERINDEX, the serial ID in letters (A), acceptable range: A to Z

  • Digits - The number of digits to display on the INDEX

  • Should include archived records - To add archived records to the INDEX/LETTERINDEX, click here

  • Reset - You can reset the INDEX/LETTERINDEX annually, monthly, or even based on a particular column value by setting one or many of the values below.

    • Reset (month) - Select a month for the INDEX/LETTERINDEX to be reset. If the reset day is not specified, the first day of the month will be used.

    • Reset (day) - Select a day of month for the INDEX/LETTERINDEX to be reset. The INDEX/LETTERINDEX will be reset monthly if the month is not provided.

    • Reset (column) - Select a column for the INDEX/LETTERINDEX to be reset. The index will be reset if the column value changes. In the absence of a column value, the INDEX/LETTERINDEX cannot be generated.


    "format": "YY-ID", # (required), the format of the id
    # YYYY - 2020, 4 digits of year
    # YY - 20, 2 digits of year
    # MM - 07, 2 digits of month
    # DD - 01, 2 digits of day
    # ID, the serial id
    # FOREIGNKEYCOLUMN - refer to the data from a foreignkey
    "digits": 4, # (optional), number of digits of ID to display
    "should_include_archived_records": false, # (optional), whether to add archived records to the INDEX/INDEXLETTER
    "reset_month": 10, # (optional), the month to reset the id
    "reset_day": 1, # (optional), the day to reset the id
    "reset_column": {"sid":"xxx", "name":"xxx"}, # (optional), the column to reset the ID


See the interface of the widget in the following views.

Readonly view

Readonly view display the values of the column.

Click on the Update button to obtain a fresh value. Utilize this function when you have archived the value and need to reset the index.

Edit view

The Edit view is the interface that allows you to modify the value.

Form view

The Form view is the field integrated into the add form for collecting values when creating a new record.

Form view is identical to Edit view


Each widget in Labii stores data in a unique manner; refer below to understand how data from this widget is stored.

Data format


Default value

The Default Value field within the column allows you to specify the default value when a record is created.

Default value shall be the value in string.

Import value

The Import Value is the value you need to include in your Excel table for it to be imported into Labii.

Import value shall be the value in string.

Last updated