How to add auto increment number in Google sheet?

[victoria]

Ooh great call Brett. UUID is indeed available in Retool!

You invoke it like:

{{ uuid.v2() }} or {{ uuid.v4() }}

There are also a couple workarounds listed in these posts in case they're helpful for you:

Auto Increment on row ID (Google Sheet)

Hey @lamartine.lopes thank you for your reply ! i still trying to find solution, is there any way that i can fetch the value of the row ? Hello @jocen , thank you for your solution, i tried using your solution, but it only works if the next column is a number, it doesn't work if the next column is plain text, any idea how to make it work? On your GSheet, set column A as primary ID for that specific table. Set A2 as 1 or whatever number you want to start at A3 would be =if(B3,A2+1,) then drag …

Trying to create an ID column and autoincrement each additional row created with Google Sheets

Hi folks, This must be staring me in the face since I can't find any videos or forum posts about this. Autoincrementing seems to be covered by applications using a database, but I'm coming up short for Google Sheets solutions. All I need is to be able to either start with a blank submission row where a column labeled "id" is 0 and every new submission grabs the most recent column and adds 1, or just count the rows and add 1. Thank you!

Let me know if you have any questions about them!