Creating index UID

Ask for Help
1

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

Thanks

1 Like
2

You can do this in the google sheet:

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

2 Likes
3

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

1 Like