# Auto Numbering **URL:** \ **Category:** Ask for Help\ **Created:** [December 27, 2020, 9:34pm UTC](https://community.glideapps.com/t/auto-numbering/20355 "2020-12-27T21:34:24Z")\ **Posts on this page:** 19\ **Page:** 3
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 3, 2021, 1:42pm UTC](https://community.glideapps.com/t/auto-numbering/20355/41 "2021-10-03T13:42:04Z")
Darren: I have been able to implement every solution you have ever posted, but am stumped here. Feels like circular logic of some kind. If I manually enter the first row with an Order ID of 1001, the max rollup will be 1001. The New Order ID will be 1002 for the second row. But when the third row is created, max rollup is still reading Order ID of 1001 and makes New Order ID 1002 again. Where I am off track here? Thank you ---
**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:** [October 3, 2021, 1:48pm UTC](https://community.glideapps.com/t/auto-numbering/20355/42 "2021-10-03T13:48:11Z")
Sounds like an issue with your rollup that gets the max ID. Can you show me screenshots of: - The GDE showing the relevant column names - The configuration of the rollup column ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 3, 2021, 1:49pm UTC](https://community.glideapps.com/t/auto-numbering/20355/43 "2021-10-03T13:49:49Z")
![Screen Shot 2021-10-03 at 6.48.55 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f285cbbfa924639c645f3c57cffcab2eb4fa720.jpeg) ![Screen Shot 2021-10-03 at 6.48.38 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b36b55c8ef16dd30bf53700e2fbd1deeea5731b.jpeg) ---
**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:** [October 3, 2021, 1:52pm UTC](https://community.glideapps.com/t/auto-numbering/20355/44 "2021-10-03T13:52:42Z")
That looks okay. So when you add a new row, you should be taking the value of the signalID2 column, and using that as the signalID for your new row. Is that what you are doing? ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 3, 2021, 1:54pm UTC](https://community.glideapps.com/t/auto-numbering/20355/45 "2021-10-03T13:54:08Z")
I am, but the value of signalID does not change, so the Max is always the same. ---
**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:** [October 3, 2021, 1:55pm UTC](https://community.glideapps.com/t/auto-numbering/20355/46 "2021-10-03T13:55:46Z")
It wont change automatically with this method, you have to set it when you add a new row. That’s the purpose of the rollup and math columns - to determine the value to use when the next row is added. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 3, 2021, 2:02pm UTC](https://community.glideapps.com/t/auto-numbering/20355/47 "2021-10-03T14:02:38Z")
OK, I tried to auto increment signalID upon form submit, but it did not work. Trying make this work in Glide pursuant to your suggestion in this thread. I will stay at it. Thanks Daren ---
**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:** [October 3, 2021, 2:11pm UTC](https://community.glideapps.com/t/auto-numbering/20355/48 "2021-10-03T14:11:50Z")
No, that’s not the way to do it. hmm, are you using a native form (show form screen) or a custom form? I mostly only use custom forms, so I’d have to think about how you’d set this when using the native form. I guess what you’d need to do is add a Screen Column (in the form screen) that has signalID as the target, and signalID2 as the source. Then when the form is submitted, signalID should automatically be set as the current value of signalID2 in the newly added row. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 3, 2021, 2:24pm UTC](https://community.glideapps.com/t/auto-numbering/20355/49 "2021-10-03T14:24:37Z")
Native form. Further complicated since I am going to the form from a inlist list of “signal providers,” so screen columns refer to the signal provider table, not the signal table. Flow is the following: user selects signal provider, then adds a signal that is linked to that provider. I can get the signal provider ID into the signal record, but want to auto-increment a signal ID with each record. (One signal provider will have hundreds of records in the signal table.) ---
**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:** [October 3, 2021, 2:29pm UTC](https://community.glideapps.com/t/auto-numbering/20355/50 "2021-10-03T14:29:10Z")
How about if you add a single value column to your Signal Providers table, that takes the first value of signalID2 from your Signals table? You should then be able to use this column as a screen column in your form. One thing to be aware of with this method is that it is subject to race conditions. That is, if you have two or more users adding records at the same time, then there is a possibility you could wind up with duplicate SignalID’s. So just keep that in mind. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 3, 2021, 2:39pm UTC](https://community.glideapps.com/t/auto-numbering/20355/51 "2021-10-03T14:39:01Z")
Will give it a try. Thank you ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [October 5, 2021, 2:52pm UTC](https://community.glideapps.com/t/auto-numbering/20355/52 "2021-10-05T14:52:58Z")
Success. You keep your perfect record Darren. Thank you ---
**Author:** ![Sven](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@Sven](https://community.glideapps.com/u/Sven)\ **Post date:** [November 29, 2021, 3:06pm UTC](https://community.glideapps.com/t/auto-numbering/20355/53 "2021-11-29T15:06:45Z")
Hi I’m trying to generate a 4 digit User ID which serves as referral code. Still struggling despite this long topic… the solution looks very smart but doesn’t work, getting same issues as @gp9293 - do you mind sharing a gif or video with the complete set up ? ---
**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:** [November 29, 2021, 3:10pm UTC](https://community.glideapps.com/t/auto-numbering/20355/54 "2021-11-29T15:10:02Z")
You’re in luck, I made one earlier today. Not exactly the same method, but essentially the same end result… > [@Unique Numbers](https://community.glideapps.com/t/unique-numbers/35039/8): > > Here you go… ---
**Author:** ![Sven](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@Sven](https://community.glideapps.com/u/Sven)\ **Post date:** [November 29, 2021, 3:42pm UTC](https://community.glideapps.com/t/auto-numbering/20355/55 "2021-11-29T15:42:32Z")
Thanks but the incremented ID needs to be generated upon a new user sign in to the app (I don’t want them to submit a form in addition…) so the actions tool won’t help, I tried all possible tweaks in mentioned in this topic. ---
**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:** [November 29, 2021, 4:44pm UTC](https://community.glideapps.com/t/auto-numbering/20355/56 "2021-11-29T16:44:50Z")
oh, that’s a completely different animal. If you can’t use an action, then I assume you have no onboarding process? Is it out of the question to intervene the first time a user signs in and get them to tap a button? If yes, then the only thing I can think of - IF you are using a Google Spreadsheet - would be to set a trigger to watch the `App: Logins` sheet, and do something each time a new user is detected (it would need to check to only act on _new_ logins, and ignore existing users logging in). ---
**Author:** ![Vladivostock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vladivostock/32/37144_2.png) [@Vladivostock](https://community.glideapps.com/u/Vladivostock)\ **Post date:** [January 9, 2022, 10:11am UTC](https://community.glideapps.com/t/auto-numbering/20355/57 "2022-01-09T10:11:59Z")
Hi, Darren, and thanks for a great explanation! Can you explain or better show how you transfer the value of the NEXT ID cell to the actual ID column? As I understand, there should be the initial point/cell where counting starts, then there are three more additional columns to increase the highest number by one and add zeros. And then the value of the next ID has to be copied and not referenced, by creating a new row, to the ID column’s last cell. How to copy and not refer? ---
**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:** [January 9, 2022, 10:17am UTC](https://community.glideapps.com/t/auto-numbering/20355/58 "2022-01-09T10:17:51Z")
> [@Vladivostock](#): > > As I understand, there should be the initial point/cell where counting starts, then there are three more additional columns to increase the highest number by one and add zeros. And then the value of the next ID has to be copied and not referenced, by creating a new row, to the ID column’s last cell. Yes, that’s correct. From my example, the current value of the last column (“Next OrderID”) would be used in an Add Row action to set the OrderID for the new row being added. This was quite a while ago, and there are other ways to do this, but which is best depends on your specific use case. For an alternative option, please check the video in the below post: > [@Unique Numbers](https://community.glideapps.com/t/unique-numbers/35039/8): > > Here you go… ---
**Author:** ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)\ **Post date:** [April 18, 2025, 11:27am UTC](https://community.glideapps.com/t/auto-numbering/20355/60 "2025-04-18T11:27:15Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6dc89bfd0f0e1e2da915d7d819cc1c6b48c249f2.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/8411d212acc5606903013e0f263fc67661cbc7b9.png) the easiest way I got it only takes 2 columns 🙂 [Previous page](https://community.glideapps.com/t/auto-numbering/20355.md?page=2)