Table of Content
Still need help?
Request support
Request Support
HELP
 / 
 / 
Deep Dive
 / 

Auto-generating unique sequential IDs

If you have to use an auto-generated sequential Id for any of your app fields like Employee ID, Vendor ID, Customer ID, Invoice ID etc, you can use the Clappia block named Unique ID

An example use case - You are creating a Clappia App to maintain the data of all your employees and you want to assign a unique and sequential Id to all the employees (maybe with a prefix like your Company Code), you could use this block with parameters like Prefix (say CLP), a Starting Value (say 1001), a Minimum Length of the ID (say 8). Then auto-generated employee Ids will be CLP001001, CLP001002, CLP001003 and so on.

Follow these steps to use the Unique ID Block.

  • Login to your Clappia account.
  • Open the app in which you wish to use the auto-generated sequential Id.
  • Go to the Edit Mode of this app.
  • Add the block named Unique Numbering.
Auto-generating unique sequential IDs

  • You will see a new Input Field labelled Unique Numbering. Edit the settings from the right panel of this field.
  • Label: Enter a label for this field which will be visible to the end-user.
  • Prefix: Optional. You can set an alpha-numeric code here which will be prefixed to all the auto-generated Ids. If you leave it empty, no prefix will be generated.
  • Minimum Length: Optional. The generated Id will be padded with leading Zeroes to ensure that the length of the auto-generated Id is greater than or equal to this minimum length.
  • Starting Sequence Number: Optional. If you want to first Id in the sequence to start from a number other than 1, you can set a starting number here.
Auto-generating unique sequential IDs
  • Go to App Home to see how the app will appear to the end-user.
  • Enter some data for the first employee and Submit.
Auto-generating unique sequential IDs
  • A new entry will be created with a Reference ID. Go to View Submissions.
  • You will see one submission with an auto-generated Employee ID.
Auto-generating unique sequential IDs
FAQs
Try our free plan
It will answer many more questions within just 15 minutes.