# Deals - Automatic Sequential Numbering

**URL:** <https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357>\
**Category:** CRM\
**Created:** [September 2, 2022, 12:36pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357 "2022-09-02T12:36:29Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![JBernath](https://avatars.discourse-cdn.com/v4/letter/j/d2c977/32.png) [@JBernath](https://community.hubspot.com/u/JBernath)\
**Post date:** [September 2, 2022, 12:36pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/1 "2022-09-02T12:36:29Z")

</div>

I need a method for creating an alphanumeric sequential numbering system in Deals. I would like the Deal # to increment each time a Deal is created. The Record ID is not useful.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [September 2, 2022, 12:45pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/2 "2022-09-02T12:45:02Z")

</div>

Hi @JBernath,

Unfortunately, this is currently not possible out of the box. Here is how you could approach workarounds:

Use [Zapier](https://knowledge.hubspot.com/integrations/how-to-use-zapier-and-hubspot) to send deals from HubSpot to a Google Sheet, assign a running number in the Google Sheet, send the deals back to HubSpot and map the running number to a custom property.

Create custom code in Operations Hub Professional. While “vanilla” workflows can’t count, they can with [custom code](https://knowledge.hubspot.com/workflows/use-custom-code-actions-in-workflows). This would require the Operations Hub Professional license and a developer.

Hope this helps!

---

<div class="post-metadata">

**Author:** ![DKnapton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dknapton/32/92627_2.png) [@DKnapton](https://community.hubspot.com/u/DKnapton)\
**Post date:** [January 15, 2023, 6:29pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/3 "2023-01-15T18:29:36Z")

</div>

Hi Karsten,

This is far from an acceptable solution.

I’m quite shocked that HS doesn’t have a property type for sequential numbering.

It seems to me that this is standard fare in most CRM sysytems for Deals, Tickets, Invoicing, etc.

While the workaround you have suggested will work, I’d be hard pressed to understand why such a simple functionality (surely the basic code is publically available) can’t be quickly turned around by the HS Dev team.

---

<div class="post-metadata">

**Author:** ![Unmatched](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/unmatched/32/10061_2.png) [@Unmatched](https://community.hubspot.com/u/Unmatched)\
**Post date:** [December 27, 2023, 10:33am UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/4 "2023-12-27T10:33:10Z")

</div>

Hey! Matt from Unmatched here.

We’ve built an app for this! Sequential does exactly what you’re looking for, it adds a sequential number onto a deal when it’s created (or whatever your workflow criteria is).

[Here’s the link to the App Marketplace Listing.](https://app.hubspot.com/l/ecosystem/marketplace/apps/_detail/sequential-powered-by-unmatched-1967082)

Enjoy! Any questions, please reach out to me on [LinkedIn](https://www.linkedin.com/in/matthewjfreestone/) or [via our website](https://www.unmatched.agency/contact).

Matt

---

<div class="post-metadata">

**Author:** ![stephanhokanson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stephanhokanson/32/13379_2.png) [@stephanhokanson](https://community.hubspot.com/u/stephanhokanson)\
**Post date:** [June 5, 2024, 4:58pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/5 "2024-06-05T16:58:25Z")

</div>

Matt,  
Does **Sequential** work with Quotes?

---

<div class="post-metadata">

**Author:** ![AnnaBaskey](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/annabaskey/32/95517_2.png) [@AnnaBaskey](https://community.hubspot.com/u/AnnaBaskey)\
**Post date:** [December 2, 2025, 10:01am UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/6 "2025-12-02T10:01:33Z")

</div>

Hey there! Can’t say if Sequential works with quotes but maybe you want to check our app Generate Sequential Numbers which can do exactly that and doesn’t follow a subscription logic in which you have to pay more for more - For more info on what the app can do, you can check the [marketplace listing](https://app-eu1.hubspot.com/marketplace/143520418/listing/generate-sequential-number-workflow-action) , look at our[documentation](https://baskey.eu/app-documentation/) or simply ask us via apps@baskey.eu! We are always happy to help, so don’t hesitate to contact us!

---

<div class="post-metadata">

**Author:** ![DanielJeal](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danieljeal/32/93810_2.png) [@DanielJeal](https://community.hubspot.com/u/DanielJeal)\
**Post date:** [July 24, 2023, 1:25pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/7 "2023-07-24T13:25:07Z")

</div>

I recently achieved something similar with sequential numbering of the custom objects upon creation. This is achievable by creating a private app and using the HubSpot API. The search endpoint returns a JSON with a total of records. Adding formatting to the workflow to add 1 and save within the property. Happy to share code examples if it helps.

---

<div class="post-metadata">

**Author:** ![Raffy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/raffy/32/31408_2.png) [@Raffy](https://community.hubspot.com/u/Raffy)\
**Post date:** [December 27, 2023, 2:02am UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/8 "2023-12-27T02:02:44Z")

</div>

Hi Daniel,  
I am not a developer but I would like to give it a try. Kindly point me to resources I need to read up on and share the code 🙂

---

<div class="post-metadata">

**Author:** ![CGraham44](https://avatars.discourse-cdn.com/v4/letter/c/a88e57/32.png) [@CGraham44](https://community.hubspot.com/u/CGraham44)\
**Post date:** [July 22, 2024, 10:53am UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/9 "2024-07-22T10:53:59Z")

</div>

Hi Daniel,

I would be interested in this too if you could share code?

---

<div class="post-metadata">

**Author:** ![smozingo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/smozingo/32/14279_2.png) [@smozingo](https://community.hubspot.com/u/smozingo)\
**Post date:** [January 9, 2025, 8:45pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/10 "2025-01-09T20:45:09Z")

</div>

Hey @DanielJeal , would you be open to sharing the code?

---

<div class="post-metadata">

**Author:** ![RNewman41](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@RNewman41](https://community.hubspot.com/u/RNewman41)\
**Post date:** [March 17, 2026, 8:33pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/11 "2026-03-17T20:33:26Z")

</div>

Good afternoon Daniel,  
If at all possible, I would appreciate the code example if you still have a format. I am currently writing for sequential numbering for project numbers using a specific mapping to pull from for our job codes. A similar app we use does this but having it done in HubSpot could save us money and time. All the best, - Trevor B

---

<div class="post-metadata">

**Author:** ![DanielJeal](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danieljeal/32/93810_2.png) [@DanielJeal](https://community.hubspot.com/u/DanielJeal)\
**Post date:** [March 19, 2026, 5:34pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/12 "2026-03-19T17:34:49Z")

</div>

Here is the code: [https://github.com/DoctorJeal/hubspt\_custom\_code/blob/c66c038b5937fb4ef3cec16447f8cac8e5f7e9bc/python/HubSpot\_Sequential\_Numbering.py](https://github.com/DoctorJeal/hubspt_custom_code/blob/c66c038b5937fb4ef3cec16447f8cac8e5f7e9bc/python/HubSpot_Sequential_Numbering.py)

---

<div class="post-metadata">

**Author:** ![Cycogerm](https://avatars.discourse-cdn.com/v4/letter/c/b19c9b/32.png) [@Cycogerm](https://community.hubspot.com/u/Cycogerm)\
**Post date:** [March 19, 2026, 3:03pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/13 "2026-03-19T15:03:17Z")

</div>

Hi @DanielJeal , Would you be kind enough to share the code? We are trying to find a solution and to avoir paying a third party (secutiry reason) to have this option.

---

<div class="post-metadata">

**Author:** ![DanielJeal](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danieljeal/32/93810_2.png) [@DanielJeal](https://community.hubspot.com/u/DanielJeal)\
**Post date:** [March 19, 2026, 5:32pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/14 "2026-03-19T17:32:38Z")

</div>

Here is the code: [https://github.com/DoctorJeal/hubspt\_custom\_code/blob/c66c038b5937fb4ef3cec16447f8cac8e5f7e9bc/python/HubSpot\_Sequential\_Numbering.py](https://github.com/DoctorJeal/hubspt_custom_code/blob/c66c038b5937fb4ef3cec16447f8cac8e5f7e9bc/python/HubSpot_Sequential_Numbering.py)

---

<div class="post-metadata">

**Author:** ![Unmatched](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/unmatched/32/10061_2.png) [@Unmatched](https://community.hubspot.com/u/Unmatched)\
**Post date:** [August 22, 2023, 2:40pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/15 "2023-08-22T14:40:46Z")

</div>

Hey! Matt from Unmatched here.

We’ve built an app for this! Sequential does exactly what you’re looking for, it adds a sequential number onto a deal when it’s created (or whatever your workflow criteria is).

[Here’s the link to the App Marketplace Listing.](https://app.hubspot.com/l/ecosystem/marketplace/apps/_detail/sequential-powered-by-unmatched-1967082)

Enjoy! Any questions, please reach out to me on [LinkedIn](https://www.linkedin.com/in/matthewjfreestone/) or [via our website](https://www.unmatched.agency/contact).

Matt

---

<div class="post-metadata">

**Author:** ![Raffy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/raffy/32/31408_2.png) [@Raffy](https://community.hubspot.com/u/Raffy)\
**Post date:** [December 27, 2023, 2:04am UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/16 "2023-12-27T02:04:02Z")

</div>

Hi Matt,  
Thanks for sharing. I suggested this to our prospect.

---

<div class="post-metadata">

**Author:** ![FWboxergy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fwboxergy/32/38459_2.png) [@FWboxergy](https://community.hubspot.com/u/FWboxergy)\
**Post date:** [May 27, 2024, 3:06pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/17 "2024-05-27T15:06:58Z")

</div>

Has anyone been able to setup Zapier to do this? I’m really struggling to do it. Thanks.

---

<div class="post-metadata">

**Author:** ![FWboxergy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/fwboxergy/32/38459_2.png) [@FWboxergy](https://community.hubspot.com/u/FWboxergy)\
**Post date:** [May 28, 2024, 3:34pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/18 "2024-05-28T15:34:19Z")

</div>

That’s really a shame that such a basic thing cannot be implemented without having to rely on expensive external serivces or extra packages. It’s really a down point for Hubspot.

---

<div class="post-metadata">

**Author:** ![kejal](https://avatars.discourse-cdn.com/v4/letter/k/7ba0ec/32.png) [@kejal](https://community.hubspot.com/u/kejal)\
**Post date:** [June 22, 2026, 2:40pm UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/19 "2026-06-22T14:40:11Z")

</div>

So I found a way to get this done within Hubspot (despite Claude telling me it can’t be done). I used 2 properties in HS Projects and a simple workflow to get this done.

We wanted to auto-increment the Deal and Ticket number upon creation

If someone needs it, I’ll be happy to share the solution here.

---

<div class="post-metadata">

**Author:** ![MichaelWillis](https://avatars.discourse-cdn.com/v4/letter/m/839c29/32.png) [@MichaelWillis](https://community.hubspot.com/u/MichaelWillis)\
**Post date:** [August 7, 2026, 6:10am UTC](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357/20 "2026-08-07T06:10:55Z")

</div>

@kejal I’d love to hear how that’s been set up

[Next page](https://community.hubspot.com/t/deals-automatic-sequential-numbering/64357.md?page=2)
