CREATE AUTO NUMERIC

HOW TO CREATE AUTO NUMERIC FIELD TO NOT REPEAT REGISTRATION

Hello. Do you mean create something like an automatic ID for every new registration?

You can use unique identifiers like rowid

yes…

You can either use unique identifiers in a form, or a have column in your sheet that uses ARRAYFORMULA to populate that.

Let’s say you have it in column A, the formula you put into cell A1 would be.

={"Unique ID";ARRAYFORMULA(IF(B2:B<>"",ROW(B2:B)-1,""))}

https://docs.glideapps.com/all/reference/data-editor/computed-columns/row-ids

https://docs.glideapps.com/all/reference/privacy-and-per-user-data/special-values/unique-identifier

https://docs.glideapps.com/all/guides/deep-dives/privacy-and-per-user-data/keys-and-unique-ids

2 Likes

Got a clipboard full, huh? Have we got a REAL FAQ or Stickies? A curated bookmark list or something? Seems every couple weeks the same questions cycle thru.

4 Likes

@Robert_Petitto started a discussion with @JackVaughan and I about trying to dedicate the FAQ & Solutions forum category to just these kinds of things with only certain people being able to create posts. We’ll see how that goes. That was the intention with the spreadsheet magic category as well but has turned into a whatever category. For me I can usually recall past discussion and can find it with a quick search…or a lot of this stuff can be found in the Glide library. I’ve been answering the same handful of questions over and over for over a year. :wink:

4 Likes