How to generate unique no while adding new records

[Mozib_Khan]

How to generate unique no while adding new records.

[Dilon_Perera]

Hi @Mozib_Khan,

Welcome to the community

Here how :

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

Thank you

[nathanaelb]

Hi @Mozib_Khan

To generate a unique number when adding a record, have you tried using the “Row ID” column?

When a new record is added, a new random string of text and numbers should be added in your row ID column.

[Mozib_Khan]

I need a unique string like ‘Prefix000001’. Yes using row Id I am able to generate unique no only.

[nathanaelb]

Ah! My apologies for misunderstanding your initial question.

I think @Robert_Petitto has created a video to address your issue exactly:

Custom & unique user codes

[Mozib_Khan]

Yes, I am watching it.
Thanks @nathanaelb