Creating index UID

I think this is an easy question but when an entry is created and Glide creates a new record how can you add a sequential UID to each new row either directly in Glide or using Google Sheet formula?
E.g. Record 1 could be 0001, record 2 could be 0002, etc. - automatically added


1 Like

You can do this in the google sheet:

=ARRAYFORMULA(TEXT(row(A2:A)-1, "0000"))


Spot on. Thanks Jeff. I didn’t know you could use the row number like that

1 Like