# Create auto numeric **URL:** \ **Category:** Ask for Help\ **Created:** [June 1, 2020, 7:52pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144 "2020-06-01T19:52:50Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Luciano\_Engel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano_engel/32/8360_2.png) [@Luciano\_Engel](https://community.glideapps.com/u/Luciano_Engel)\ **Post date:** [June 1, 2020, 7:52pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/1 "2020-06-01T19:52:50Z")
> [@Auto-complete search?](https://community.glideapps.com/t/auto-complete-search/7319/1): > > Hello everybody, > > I have been looking around but have not seen anything in the forum like it. > > I have an app where I enter data that computes a result based on what is entered. > (Aka food with proteins etc.) > > Is there a way to build an autocomplete when I enter my data that shows an array of choices based on what I type? > > Thanks HOW TO CREATE AUTO NUMERIC FIELD TO NOT REPEAT REGISTRATION ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 1, 2020, 11:58pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/2 "2020-06-01T23:58:55Z")
Hello. Do you mean create something like an automatic ID for every new registration? ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [June 2, 2020, 10:00am UTC](https://community.glideapps.com/t/create-auto-numeric/10144/3 "2020-06-02T10:00:19Z")
You can use unique identifiers like rowid ---
**Author:** ![Luciano\_Engel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luciano_engel/32/8360_2.png) [@Luciano\_Engel](https://community.glideapps.com/u/Luciano_Engel)\ **Post date:** [June 2, 2020, 10:53pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/4 "2020-06-02T22:53:22Z")
> [@ThinhDinh](#): > > Hello. Do you mean create something like an automatic ID for every new registration? yes… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 2, 2020, 10:56pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/5 "2020-06-02T22:56:53Z")
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,""))} ``` ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 2, 2020, 11:10pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/6 "2020-06-02T23:10:46Z")
[https://docs.glideapps.com/all/reference/data-editor/computed-columns/row-ids](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/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](https://docs.glideapps.com/all/guides/deep-dives/privacy-and-per-user-data/keys-and-unique-ids) ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [June 2, 2020, 11:50pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/7 "2020-06-02T23:50:57Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 3, 2020, 2:05am UTC](https://community.glideapps.com/t/create-auto-numeric/10144/8 "2020-06-03T02:05:12Z")
@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. 😉 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 4, 2024, 1:02pm UTC](https://community.glideapps.com/t/create-auto-numeric/10144/9 "2024-03-04T13:02:38Z")