# Can I automatically fill a field in a new record with the next available number in a series? **URL:** \ **Category:** Database\ **Created:** [February 10, 2022, 2:23am UTC](https://forum.adalo.com/t/can-i-automatically-fill-a-field-in-a-new-record-with-the-next-available-number-in-a-series/23224 "2022-02-10T02:23:42Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![MikesClub](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mikesclub/32/12754_2.png) [@MikesClub](https://forum.adalo.com/u/MikesClub)\ **Post date:** [February 10, 2022, 2:23am UTC](https://forum.adalo.com/t/can-i-automatically-fill-a-field-in-a-new-record-with-the-next-available-number-in-a-series/23224/1 "2022-02-10T02:23:42Z")
I’m trying to automatically assign a user ID number to each new user who creates an account in my app. The numbers will be a simple series: 1, 2, 3, etc. If users 1, 2, and 3 already exist, the next user should be assigned the number 4. Is there a way to do this automatically when a new user record is created? Either directly in the database or possibly in the Create Account form the user fills out? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 10, 2022, 4:17am UTC](https://forum.adalo.com/t/can-i-automatically-fill-a-field-in-a-new-record-with-the-next-available-number-in-a-series/23224/2 "2022-02-10T04:17:59Z")
Hi Michael, You can add the created number property in your Signup form automatically section and fill with all users count from magic text ( after date/time section in magic text options ) +1. If it is a custom form on your Signup action you can fill the number property with all users count from magic text ( after date/time section in magic text options) +1. Thank you ---
**Author:** ![MikesClub](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mikesclub/32/12754_2.png) [@MikesClub](https://forum.adalo.com/u/MikesClub)\ **Post date:** [February 10, 2022, 2:27pm UTC](https://forum.adalo.com/t/can-i-automatically-fill-a-field-in-a-new-record-with-the-next-available-number-in-a-series/23224/3 "2022-02-10T14:27:21Z")
If I use the Users Count to create this number, will the number change if I delete a previous user? Because I plan to use the number as a member ID, which would cause chaos if it changed. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [February 10, 2022, 2:41pm UTC](https://forum.adalo.com/t/can-i-automatically-fill-a-field-in-a-new-record-with-the-next-available-number-in-a-series/23224/4 "2022-02-10T14:41:39Z")
Oh then I think you need to use the Record ID. > **[Make unique record IDs publicly available | Feature Requests | Adalo](https://adalo.canny.io/feature-requests/p/make-unique-record-ids-publicly-available)** > > Record IDs for Adalo DB collections are used a lot while working with APIs. However we can't get them in Adalo builder itself. Still not available but Pragmaflow created a component. > [@A Button that gives the Record Id](https://forum.adalo.com/t/a-button-that-gives-the-record-id/22915): > > My team was making SMS verification and was complaining about needing to filter the entire collection table to find the record to update. Also, a sports enthusiast posted the same thing on the forum today. So, I whipped up a quick component that will let you get the record id of an item when the button is clicked on. Installed it from [adalo.pragmaflowservers.com/install-component](http://adalo.pragmaflowservers.com/install-component) and use it for your custom actions today and save a whole bunch of work. [https://youtu.be/OuyZX15aPXg](https://youtu.be/OuyZX15aPXg)