Hi I need to get an order id which should be unique not like an unique identifier generating one.is it possible?

You can try using Row ID, or create a starting value ex: 100001 and then use increment or a math function on it.

As @Amal said, you can try Row ID, or in a form, the column called Unique Key

May I ask why don’t you just populate the unique identifier value to the new order, assuming you’re using a form? Or you want your IDs to follow a specific format?

I’m already populating the unique identifier but the app is a clothing store app so I need to be in some order.thats y I need this.

every time you add a new item, increment the ITEM ID by 1… simple

So something like “ID-0001”, “ID-0002” etc.?

How do I increment automatically?

Unique row id automatically

Ask for Help

Darren_Murphy October 3, 2021, 1:34pm 9

There are a number of ways that this can be done, and which is best will depend on your specific use case. Refer to the following topic for some possible approaches:

Topic		Replies	Views
New code Ask for Help	1	235	April 17, 2020
Auto generate a OrderID Ask for Help	3	2134	October 27, 2020
How to generate unique no while adding new records Ask for Help	5	1518	April 23, 2022
Auto Increment Ask for Help	5	2676	September 15, 2022
Hello: I want to create a numerical sequence for an order number Ask for Help	1	657	December 25, 2023

Unique row id automatically

Related topics