# Sequencial Numbers

**URL:** <https://forum.bubble.io/t/sequencial-numbers/235118>\
**Category:** Need help\
**Created:** [December 1, 2022, 5:33am UTC](https://forum.bubble.io/t/sequencial-numbers/235118 "2022-12-01T05:33:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![recomnation](https://avatars.discourse-cdn.com/v4/letter/r/e47774/32.png) [@recomnation](https://forum.bubble.io/u/recomnation)\
**Post date:** [December 1, 2022, 5:33am UTC](https://forum.bubble.io/t/sequencial-numbers/235118/1 "2022-12-01T05:33:54Z")

</div>

Hi, I’m trying to do a sequencial numbering system for every time a user signs up they are given a specific number. Each additional user is a +1 of the previous number.

I thought I figured it out by doing the “do a search” count +1 but then I was running into some issues where it was no longer increasing by one. Any suggestions?  
 ![question](https://us1.discourse-cdn.com/bubble/original/3X/4/e/4ecc905f4bdca76a0af0fedc79681cf6e2854831.png)

---

<div class="post-metadata">

**Author:** ![tylerboodman](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/tylerboodman/32/242142_2.png) [@tylerboodman](https://forum.bubble.io/u/tylerboodman)\
**Post date:** [December 1, 2022, 5:38am UTC](https://forum.bubble.io/t/sequencial-numbers/235118/2 "2022-12-01T05:38:33Z")

</div>

The most basic way is:  
Upon creation of the user set the user’s [number field] to `Do a search for User` sorted by `[number field]` descending` no`, then close out of the search and do `:last item's [number field] + 1`

Also default privacy rules can get in the way of the search actually finding the next number

But @keith is about to come up with something way more reliable in a second

---

<div class="post-metadata">

**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\
**Post date:** [December 1, 2022, 5:49am UTC](https://forum.bubble.io/t/sequencial-numbers/235118/3 "2022-12-01T05:49:08Z")

</div>

Oh FFS not this again. YOU 👋 DON’T 👋 NEED 👋 THIS 👋

If you want to KNOW the order that Users signed up just sort them by Created Date. Hooray know you know. BUT WHY DOES IT FREAKING MATTER!? 👋👋👋👋👋👋👋

(Answer: It doesn’t.)

If you REALLY want to create asymptomatically increasing serial numbers you can do it in Bubble but it’s WAY above your pay grade if you’re asking how to do it here.

Start here:

> [@How to achieve Unique, Sequential Numbers Reliably?](http://forum.bubble.io/t/how-to-achieve-unique-sequential-numbers-reliably/81589/57):
>
> boom A WORD OF WARNING THAT SOME OF THE SOLUTIONS PEOPLE OFFERED ABOVE ARE NOT RELIABLE AND YOU MAY, IN FACT, GET DUPLICATES OR WORSE UNLESS YOU USE THE FOLLOWING METHOD AS - I HAVE TESTED THEM ALL JUST LIKE KEITH DID boom Not knowing this caused me a lot of issues and setbacks so I hope it saves others. The solution that works perfectly and reliably in bubble natively is the solution buried at the end of Keith’s great video - and all the reasons are explained by him. in summary the soluti…

THEN read the ENTIRE thread and don’t come back her until you can prove that you have.

---

<div class="post-metadata">

**Author:** ![keith](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/keith/32/56020_2.png) [@keith](https://forum.bubble.io/u/keith)\
**Post date:** [December 1, 2022, 5:50am UTC](https://forum.bubble.io/t/sequencial-numbers/235118/4 "2022-12-01T05:50:00Z")

</div>

Well, @tylerboodman, I’m not offering a better solution, but ripping a new ahole. Same thing I guess. 😉

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [February 9, 2023, 5:33am UTC](https://forum.bubble.io/t/sequencial-numbers/235118/5 "2023-02-09T05:33:57Z")

</div>

Closed on February 9, 2023, 5:33am UTC

This topic was automatically closed after 70 days. New replies are no longer allowed.
