Increment + GSheets

[jcmaad]

Hi, I have a GSheets with unique number column. When adding a new row through Glide, I would like to increment the unique number by one. Increment Action doesn’t work, is it because its Gsheets?

[Uzo]

Do you want to have row numbers? or counter?

[jcmaad]

yea

[Uzo]

there are 2 methods for that, add 1 to the max when creating a new row, or universal method to create a rank number… just look @Robert_Petitto tutorial video:

Convert Number Score to Rankings in Glide!

Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [Glide: Create a RANKED Leaderboard!]

[jcmaad]

@Uzo

1 to the max when creating a new row,

thank you. ranked method seems to be overkill. I ended up creating a new Rollup column with max value, then added a new column that adds 1 to the Rollup column. Is that what you meant by add1 to the max?

[Uzo]

yes… but this will give you a fixed number… so when you delete or move the row, it will not be a row number anymore

[jcmaad]

Yes, i want to a fixed number. Its a SKU number, so I want it to be static. So, it user adds a new product, I want SKU to increment.

[Uzo]

then, adding 1 to the max number is the right method for you… you can use row ID for SKU, but it doesn’t look nice

[jcmaad]

thanks!

[ThinhDinh]

Please be aware that if two users submit a row too close to each other, you might end up with the same SKU.

[Darren_Murphy]

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…

[jcmaad]

Thanks, I think it will stick wit my method. It adds only two columns to the database.