Numbering

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

Specs

Label	Value
Version	2.0.0 (updated on 2022-08-20)
Developer	Labii Inc.
Type	Column
Support Configuration	Yes
Support Readonly view	Yes
Support Edit view	Yes
Support Form view	Yes
Support Default value	Yes
Support Import	Yes
Allow multiple	Yes

Overview

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.

Configuration

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.

Example

{
    "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
}

Views

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

Data

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

Data format

String

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.