Grab Clappia’s 50% OFF Black Friday Deal before it’s gone! Ends 05 Dec 2025.
View offer →
#bf-banner-text { text-transform: none !important; }
Table of Content
Still need help?
Request support
Request Support
Help
 / 
 / 
Data Processing Blocks
 / 

Unique Numbering Block

Use the Unique Numbering block in the App Design to provide a field for the end users to automatically allot the Sequential Numbering to any entity.

The entity maybe - Invoice, Product, Tag, Serial, ID, Application, Receipt, Token, Bill, Order etc.,.

Unique Numbering Block

Help Video

Editing the Block

Click on the Unique Numbering block. A Right Panel for editing appears on the right side.

Start editing the fields from the Right Panel on the right side.

Unique Numbering Block
Unique Numbering Block

Label

Label is positioned above the Input block and it is the Heading which conveys to the end user that this is a Unique Numbering block.

According to the user requirements, the App Designer can rename the Label, to: Invoice, Product, Tag, Serial, ID, Application, Receipt, Token, Bill, Order etc.,.

Description

Description is positioned below the Input block which further explains the end user about the Unique Number that will be generated after submission.

Description is an optional field.

NOTE - Since the Unique Numbering block is an Auto-Generate feature, it doesn’t require the user to enter any Data into the Input block here.

Prefix

The App Admin can define a fixed or a dynamic prefix with which the Unique Number will start. For Example, if the prefix is defined as CLP, then the unique numbers generated will be CLP001, CLP002 and so on. The prefixes can also be dynamic using other variables of the App. For example, if the prefix is set as INV-{city}-, the values generated will be INV-BLR-001, INV-BLR-002, INV-HYD-001, INV-HYD-002 and so on.

Minimum Length

The App Designer will enter the maximum number of characters a Unique Number can have. This count includes both Prefix and Starting Sequence Number.

The Minimum Length can be set up to a maximum of 30. If a value greater than 30 is entered, the system will show an error and the block cannot be saved.

Starting Sequence Number

The App Designer will enter a number and it is followed as a sequence for the succeeding submissions.

The Starting Sequence Number can now go up to 10,00,000. If you enter a number beyond this limit, an error message will appear and the block cannot be saved.

Display this field if

Enable this option to show/hide the Unique Numbering block in relation with another Input block.

Width of the block

Set the size of the block in terms of width (100%, 75%, 50%, and 25%) according to your app requirements.

Advanced Label

The Advanced Label option allows you to change the label of a field dynamically based on a condition you define. Instead of always showing the same fixed label under the ‘Basic’ tab, the field can display different labels depending on requirements of the form. Use spreadsheet-like functions such as IF, AND, OR, etc. and make use of other field variables to set your conditions. Type @ and select the field.

This is useful when the meaning of a field changes based on context, business logic, or user choices.

For example:
If you have a dropdown called Record Type with options “Complaint” and “Service Request”.
Your numbering field should reflect what the number represents.

So:
– If Complaint, show “Complaint Number”
– If Service Request, show “Request Number”

Formula:

IF({record_type} = "Complaint", "Complaint Number", "Request Number")

This allows the same field to adapt its displayed purpose without needing multiple separate fields.

Advanced Description

The Advanced Description option works exactly like Advanced Label, but it changes the description text instead. This is useful when guidance or instructions for a field need to change depending on earlier answers.

For example, using the same scenario from Advanced Label:
If you have a dropdown called Record Type with options like “Complaint” and “Service Request”, you may want the description of your Unique Numbering field to guide the user differently depending on what they selected.

So:
– If the user selects Complaint, the description could say: “This number identifies the complaint record.”
– If the user selects Service Request, the description could say: “This number identifies the service request record.”

Formula:

IF({record_type} = "Complaint", "This number identifies the complaint record.", "This number identifies the service request record.")

This helps users understand what is required from them without showing unnecessarily long or irrelevant instructions.

Additional Examples (Apply to Both Advanced Label and Advanced Description)

1. Showing nothing until a selection is made

For example, if you have a dropdown field called Visit Category with options “Routine” and “Urgent”, you may want the label or description of a field to remain blank until the user first selects a category.

Once a selection is made:

  • If the user chooses Routine, the field will display “Routine”.
  • If the user chooses Urgent, the field will display “Urgent”.

Formula (can be used in either Advanced Label or Advanced Description):

{visit_category}The label/description stays empty until the dropdown has a selected value.
After the user picks an option, the selected text (Routine or Urgent) becomes the label or description.

2. Changing label/description based on language selection

For example, if your form includes a dropdown field called Select Language with options English, Spanish, and French, you can show the label or description in the selected language.

So:

  • If the user selects English, show English text.
  • If the user selects Spanish, show Spanish text.
  • If the user selects French, show French text.

Formula (can be used in either Advanced Label or Advanced Description):

IF({select_language} = "English", "Enter details", IF({select_language} = "Spanish", "Ingrese detalles", "Entrez les détails"))The formula returns the text for the selected language.
Only one label/description is shown at a time, depending on what the user picks in the Select Language dropdown.

Important Notes (applies to both Advanced Label and Advanced Description)

1. Variables do not change
When a field is created, its variable name is derived from the label you set in the Basic tab. That variable name is what you must use in formulas, workflows, and other logic. The visible label or description shown by Advanced Label / Advanced Description does not change the variable name.

2. Submissions tab: table view vs right panel
In the Submissions area, the table view always displays the labels from the Basic tab. When you open an individual submission, the right panel shows the labels and descriptions as they appear in the form (i.e., the Advanced Label and Advanced Description applied for that submission). This keeps the submission list consistent while letting reviewers see the context-aware labels and descriptions when viewing a record.

3. Bulk Edit shows Basic tab labels and descriptions
When you need to Bulk Edit submissions, the spreadsheet you download shows the labels and descriptions from the Basic tab only. Advanced Label and Advanced Description are not applied in Bulk Edit, so keep that in mind when preparing bulk updates.

4. Some fields cannot be used inside Advanced Label/Description formulas
Certain block types do not expose a variable that can be referenced in Advanced Label or Advanced Description. If a block does not expose a variable, you cannot use it inside the formula.

Geo Address

GPS Location

PaymentGateway

Audio

Live Tracking

Signature

Code Scanner

NFC Reader

Get Data from RestApi

Get Data from Other Apps

Get Data from Google Sheets

Get Data from Database

AI Block

Text, HTML & Embedding

Attached Files

Image Viewer

Video Viewer

PFD Viewer

Code block

Progress Bar

Action Button

--------------------------------------------------------------------------------------------------------------

Unique Numbering Block
Example of Unique Numbering Block

Consider, the end user wants to generate the first Employee ID as - emp0001

Prefix - emp

Minimum Length - 7

Starting Sequence Number - 0001

Unique Numbering Block

Unique Numbering Block

Employee ID generated will be emp0001

Further Submissions are followed with emp0002, emp0003, emp0004... and so on.

Important Notes for the App Designer

1. If the end user does not want any Prefix’ then it can be left blank.

Example:

Prefix - 

Minimum length - 5

Starting sequence number - 002

Unique Numbering Block

Sequential Unique Number generated will be - 00002,00003,00004 and so on.

Unique Numbering Block


2. If the Minimum Length field is left blank then the Unique Number generated will add leading zeros automatically as needed.

Example

Prefix - xyz

Minimum length - 

Starting sequence number - 2

Unique Numbering Block

Sequential Unique Numbers generated will be - xyz2, xyz3, xyz4 and so on.

Unique Numbering Block

3. If the Starting Sequence Number field is left blank then the Unique Number generated will be starting from 1 by default.

Example

Prefix - xyz

Minimum length - 5

Starting sequence number -  

Unique Numbering Block

Sequential Unique Numbers generated will be - xyz01, xyz02, xyz03 and so on.

Unique Numbering Block

4. If all the fields (Prefix, Maximum Length, Starting Sequence Number) are left blank then the Unique Number generated will be starting from 1 by default.
Example

Prefix - 

Minimum length - 

Starting sequence number -  

Unique Numbering Block

Sequential Unique Numbers generated will be - 1,2,3 and so on.

Unique Numbering Block

5. Does not work in copyable sections
This block does not support use inside Copyable Sections; multiple unique numbers won’t generate for each copied section. Only one unique number will be kept for one submission irrespective of the number of sections copied that the block resides.

6. Always auto-generated and immutable
The sequence is automatically generated at submission and cannot be manually edited, cannot be modified via workflows, and cannot be changed via Bulk Edit.

7. Applies across all submission types
Unique numbers are generated consistently for form submissions, workflow-based submissions, and Excel / Bulk Uploads.

FAQs
Can I generate sequential numbers for each submission?
Yes, you can generate sequential numbers for submissions using the 'Unique Numbering' block. This feature assigns a unique and auto-incrementing ID to each submission. You can also customise the prefixes and other attributes of these IDs.
Can a predefined suffix be added?
Yes, you can add a suffix by making use of the 'Calculations & Logic' block to connect it with the 'Unique Numbering' block.
Can unique numbers be skipped in Unique Numbering Block?

No, unique numbers cannot be manually skipped in Unique Numbering Block. The block automatically generates sequential numbers in order (001, 002, 003, etc.) and doesn't provide an option to skip specific numbers in the sequence. The numbering follows a strict sequential pattern to maintain consistency and prevent gaps in the numbering system.

When is the unique number generated?
A number is auto-generated for every submission, whether created manually, through a workflow, or via Excel upload.
Will the Unique Numbering field auto-generate when I upload submissions via Excel?
Yes, if you upload data via bulk upload, the unique numbering field will auto populate sequentially for every submission uploaded.
Is there a way to hide the Unique Numbering block from the user?

The Unique Numbering is a block you add in Design App. You can hide any field or block using a Display this field if condition (type @ to pick variables and write the condition).

For example: verin.dsouza@clappia.com = \"yourid@example.com\" - only this user will see the block, while it remains hidden for everyone else.

Try our free plan
It will answer many more questions within just 15 minutes.