# How to Automate Number Generation (No Repetition)

**URL:** <https://community.glideapps.com/t/how-to-automate-number-generation-no-repetition/72235>\
**Category:** Ask for Help\
**Created:** [April 2, 2024, 12:54am UTC](https://community.glideapps.com/t/how-to-automate-number-generation-no-repetition/72235 "2024-04-02T00:54:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jerald101](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jerald101/32/72828_2.png) [@Jerald101](https://community.glideapps.com/u/Jerald101)\
**Post date:** [April 2, 2024, 12:54am UTC](https://community.glideapps.com/t/how-to-automate-number-generation-no-repetition/72235/1 "2024-04-02T00:54:44Z")

</div>

Hi Glide Community,

Currently, I have a data table that uses Google Sheets called Quotes. What we would like to implement is that every time we create a quote (via form), a quote number is generated corresponding to the previous number of the previous quote.

**Quote Form**

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/7/b7b031b8eeceec8446437170634fef970f80187e.png)

For example, I would create a quote named “test quote1”. Its quote number is then generated once the form is submitted. It produced the quote number **QU1234**. I then made another quote named “test quote2”. Its quote number is then generated as **QU1235** and so on. As long as there isn’t any repeating quote numbers, that would be good.

**Expected Result Every New Quote**

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/142e85c36b6dbc1f8e3311f4543660ccf07bc33d.png)

Any help is appreciated. Thank you.

---

<div class="post-metadata">

**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:** [April 2, 2024, 2:11am UTC](https://community.glideapps.com/t/how-to-automate-number-generation-no-repetition/72235/2 "2024-04-02T02:11:31Z")

</div>

You can check this.

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 9, 2024, 2:11am UTC](https://community.glideapps.com/t/how-to-automate-number-generation-no-repetition/72235/3 "2024-04-09T02:11:41Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.