# Deal Number Generator **URL:** \ **Category:** HubSpot Ideas\ **Tags:** object\ **Created:** [February 6, 2017, 6:43pm UTC](https://community.hubspot.com/t/deal-number-generator/929 "2017-02-06T18:43:39Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mfinocchiaro](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mfinocchiaro/32/98869_2.png) [@mfinocchiaro](https://community.hubspot.com/u/mfinocchiaro)\ **Post date:** [February 6, 2017, 6:43pm UTC](https://community.hubspot.com/t/deal-number-generator/929/1 "2017-02-06T18:43:39Z")
We need a systematic way to create a “Deal Number” containing letters as well as sequential numbers. These are based on which business unit creates the deal, the year the deal is created, and then a sequential number to create a unique identifier for each deal. For example, one deal number would be XYZ20171234, the next one created in that BU would be XYZ20171235, etc. ---
**Author:** ![JoachimP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/joachimp/32/99730_2.png) [@JoachimP](https://community.hubspot.com/u/JoachimP)\ **Post date:** [June 23, 2017, 12:12pm UTC](https://community.hubspot.com/t/deal-number-generator/929/2 "2017-06-23T12:12:17Z")
Today, I also asked the support for such a feature, since it is not in HubSpot and would be an easy one to implement. The suggestion to use the DEAL identifier from the URL is not really practicable. Actually we will develop such a generator within SharePoint. Even we could handle such a solution it´s really not sexy! ---
**Author:** ![hilaryb](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hilaryb/32/32521_2.png) [@hilaryb](https://community.hubspot.com/u/hilaryb)\ **Post date:** [June 11, 2020, 9:35pm UTC](https://community.hubspot.com/t/deal-number-generator/929/3 "2020-06-11T21:35:22Z")
We are looking for something similar! Using the long system ID is not a long term solution for us. ---
**Author:** ![DanCvet](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dancvet/32/13521_2.png) [@DanCvet](https://community.hubspot.com/u/DanCvet)\ **Post date:** [June 17, 2020, 7:32am UTC](https://community.hubspot.com/t/deal-number-generator/929/4 "2020-06-17T07:32:47Z")
Agreed with above - would require: Prefix Options Incremental Numbers i.e. MW-00134, MW-00135, NS-1083, NS-1084 Please help! ---
**Author:** ![javieryebenes](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/javieryebenes/32/8092_2.png) [@javieryebenes](https://community.hubspot.com/u/javieryebenes)\ **Post date:** [December 1, 2020, 11:10pm UTC](https://community.hubspot.com/t/deal-number-generator/929/5 "2020-12-01T23:10:58Z")
I would love to be able to use this as well as we would like to assign a number to a new deal that enrolls in a workflow following a number sequence. Once deals are reviewed and meet certain criteria, we would love to automate a number modification to another sequence depending on the category or other features. I tried this by making a calculation using the “Deal ID” but unfortunately we have several products and pipelines from different departments in Hubspot and this would work. ---
**Author:** ![JRomero](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jromero/32/78108_2.png) [@JRomero](https://community.hubspot.com/u/JRomero)\ **Post date:** [December 29, 2020, 2:19pm UTC](https://community.hubspot.com/t/deal-number-generator/929/6 "2020-12-29T14:19:58Z")
Same here. We started using the DealID at the beginning but the fact that it’s not consecutive and that it’s not customizable is making this a nightmare. To give more context, the deal numbering goes also into file naming for everything related to a given deal and it’s making the search very difficult… As this is a request that has been going over for years, it should be the time that it’s really solved. ---
**Author:** ![romi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/romi/32/78601_2.png) [@romi](https://community.hubspot.com/u/romi)\ **Post date:** [February 3, 2021, 12:46am UTC](https://community.hubspot.com/t/deal-number-generator/929/7 "2021-02-03T00:46:37Z")
If the number is based on the number of deals for a given company, you could use the ‘Set property value’ action with the number of associated deals from the Company: To implement: 1. Create Deal ‘Company Associated Deals’ custom property 2. Create Deal ‘Project Code’ custom property 3. Create any other properties that will make up the Deal Reference, e.g Company Shortcode 4. Create a Company workflow to copy the ‘Company Associated Deals’ property to the Deal when the ‘Company Associated Deals’ property is known 5. Create a Deal Workflow to set the ‘Project Code’ property where the Project Code is unknown and the ‘Company Associated Deals’ property is known, you could include a company shortcode in this if you want to have a unique reference, e.g. {deal.client\_code}{deal.company\_associated\_deals) would come out as HUB12 when creating the 12th deal against a company that has a company code of HUB ---
**Author:** ![JRomero](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jromero/32/78108_2.png) [@JRomero](https://community.hubspot.com/u/JRomero)\ **Post date:** [February 3, 2021, 6:17pm UTC](https://community.hubspot.com/t/deal-number-generator/929/8 "2021-02-03T18:17:27Z")
Hi Romi, Thanks! My question was for a general consecutive number, regardless of the company. It would be useful that you could set it to start at any given number (I’m thinking of numbers that may reset each month/year)… Any idea if there is a similar tool that is not connected to companies? ---
**Author:** ![dmaxwell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dmaxwell/32/93181_2.png) [@dmaxwell](https://community.hubspot.com/u/dmaxwell)\ **Post date:** [September 8, 2021, 5:56pm UTC](https://community.hubspot.com/t/deal-number-generator/929/9 "2021-09-08T17:56:16Z")
Curious if there are any updates on this one… looking to create SalesOrders directly in HubSpot and then transfer to ERP system afterwards, but needs to be unique, machine generated with a given alpha numeric combination. Any insight, greatly appreciated. Thanks, Dave ---
**Author:** ![romi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/romi/32/78601_2.png) [@romi](https://community.hubspot.com/u/romi)\ **Post date:** [September 8, 2021, 6:52pm UTC](https://community.hubspot.com/t/deal-number-generator/929/10 "2021-09-08T18:52:55Z")
We still have not seen any OOB solutions for this. We have had this requirement now for a few clients where there are specific rules around the structure of the unique number or it is a straight consecutive number as suggested. We have achieved this using custom code in workflows using Ops Hub Pro - and we also have an externally hosted solution if you don’t have Ops Hub and the budget doesn’t stretch to this. We will likely put our externally hosted tool on the marketplace at some point, but if you need a solution sooner we could set something up for you, just give us a shout at hypeanddexter.nz ---
**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:38pm UTC](https://community.hubspot.com/t/deal-number-generator/929/11 "2022-09-02T12:38:41Z")
I am also looking for this option. Did you ever receive a solution? ---
**Author:** ![dmaxwell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dmaxwell/32/93181_2.png) [@dmaxwell](https://community.hubspot.com/u/dmaxwell)\ **Post date:** [September 2, 2022, 12:57pm UTC](https://community.hubspot.com/t/deal-number-generator/929/12 "2022-09-02T12:57:42Z")
Nothing yet. ---
**Author:** ![hilaryb](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hilaryb/32/32521_2.png) [@hilaryb](https://community.hubspot.com/u/hilaryb)\ **Post date:** [September 2, 2022, 1:50pm UTC](https://community.hubspot.com/t/deal-number-generator/929/13 "2022-09-02T13:50:42Z")
Unfortunately, no. Seems we’re destined to suffice with an extra long Deal ID indefinitely 😞 ---
**Author:** ![romi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/romi/32/78601_2.png) [@romi](https://community.hubspot.com/u/romi)\ **Post date:** [September 4, 2022, 3:18am UTC](https://community.hubspot.com/t/deal-number-generator/929/14 "2022-09-04T03:18:00Z")
Not aiming to use this as a marketing forum! But we know that this is a real pain point for many HubSpot users (including many of our clients) - we have built out a Micro App to extend Workflows to do this for a small monthly cost, contact us via [hypeanddexter.com](http://hypeanddexter.com) if you would like to learn more. ---
**Author:** ![margaret2](https://avatars.discourse-cdn.com/v4/letter/m/e79b87/32.png) [@margaret2](https://community.hubspot.com/u/margaret2)\ **Post date:** [September 30, 2022, 1:04pm UTC](https://community.hubspot.com/t/deal-number-generator/929/15 "2022-09-30T13:04:29Z")
Hi @romi , Thanks for your insights on this forum. I’m wondering if you can help me with step 3 from your post above: “3. Create a Company workflow to copy the Company Associated Deals property to the Deal Number property and any other data if unknown when a Deal is created” I created a Company workflow, but the action copies the Company Associated Deals property to the Deal Number property for _all deals_. I can’t figure out how to make it only copy the property to the deal where Deal Number is unknown. (Screenshot below) ![hubspot company workflow copies to all deals.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/e/be63165f22d1c9178139adf5d03a89d61b7bb2c7.png) ---
**Author:** ![romi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/romi/32/78601_2.png) [@romi](https://community.hubspot.com/u/romi)\ **Post date:** [October 2, 2022, 7:05pm UTC](https://community.hubspot.com/t/deal-number-generator/929/16 "2022-10-02T19:05:37Z")
@margaret2 I have updated the instructions to make this a bit clearer, also so you can just use the standard ‘Set property value’ workflow action. When setting values on an associated object record, you cannot exclude/include specific records based on properties (only association labels). Therefore you need to copy the Company value to the Deal, this will update all associated Deals - but then have a Deal based workflow that sets your custom Project Code property, i.e. Enrollment trigger: IF Associated Deals is known AND Project Code is Unknown Action: Set Project Code from Associated Deals + any other reference ---
**Author:** ![coamyot](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/coamyot/32/95715_2.png) [@coamyot](https://community.hubspot.com/u/coamyot)\ **Post date:** [February 22, 2023, 1:19am UTC](https://community.hubspot.com/t/deal-number-generator/929/17 "2023-02-22T01:19:10Z")
Upvote. ---
**Author:** ![HFerreira](https://avatars.discourse-cdn.com/v4/letter/h/4da419/32.png) [@HFerreira](https://community.hubspot.com/u/HFerreira)\ **Post date:** [August 18, 2023, 9:33pm UTC](https://community.hubspot.com/t/deal-number-generator/929/18 "2023-08-18T21:33:03Z")
Any solution for this? Almost thinking about moving from hubspot, this is really must… ---
**Author:** ![JoachimP](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/joachimp/32/99730_2.png) [@JoachimP](https://community.hubspot.com/u/JoachimP)\ **Post date:** [August 19, 2023, 9:05am UTC](https://community.hubspot.com/t/deal-number-generator/929/19 "2023-08-19T09:05:29Z")
I never heard anything about this feature request anymore. It is really a shame! ---
**Author:** ![MLindsay1](https://avatars.discourse-cdn.com/v4/letter/m/ad7895/32.png) [@MLindsay1](https://community.hubspot.com/u/MLindsay1)\ **Post date:** [November 28, 2023, 9:07am UTC](https://community.hubspot.com/t/deal-number-generator/929/20 "2023-11-28T09:07:51Z")
Any idea from HubSpot on this? We’re desperate for this to make this work for us! [Next page](https://community.hubspot.com/t/deal-number-generator/929.md?page=2)