Generating shorter unique ID for every user

[Darren_Murphy]

Take a look at my first option below:

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…

I think that can work for your use case.

[biha]

Oo your case 2, same method with me doing now but using glide . i see

[Darren_Murphy]

With the second case you have the same problem. If you delete a row, then all the numbers change. Also, with the second case the values will not be in the Google Sheet.

I think the first case is better for you

[biha]

Exactly, thank you darren . let me try it first.

[Abdallah_Shafiullah]

How do I generate a unique string code automatically every time I add a new row using the form feature

I have 4 columns: Customer Name, Order Date, and TrackingID

USing the form I should be prompted to enter only the customer name and order date and upon clicking submit , In the Tracking ID cell in the corresponding row should come automatically

HOw can I achieve this?

[Hassan_Nadeem]

Hi @Abdallah_Shafiullah.

Welcome to Glide Community.

If you want a unique Tracking ID then you could use RowID for it. If you want a shorter unique ID then you could use a Text Slice column and set your length accordingly.