How do I create field that sets up a unique identify number

[CophieSollins]

Hello, 

I'm trying to create a ticket property that creates unique Sequential ticket Numbers.

The field ideally needs to be a mixture of letters and numbers for example:

RMA-2021-001

RMA-2021-002

RMA-2021-003

RMA-2021-004

I can't figure out how to do it and make the ticket automatically create it each time.

Does anyone have a solution?

[karstenkoehler · Accepted solution]

Hi @CophieSollins,

There isn't a default feature in HubSpot to achieve this, unfortunately. It would require either a custom code action in a workflow (available in Operations Hub Professional) or a third party solution, e.g. Zapier and Google Sheets.

With the first options, a custom coded workflow action would keep track of the running number and populate a ticket property. Here a developer would have to code such an action.

With the second option, you would sync tickets into a Google Sheet using Zapier, populate the running number / code in the sheet and sync the tickets back into HubSpot, along with the code.

Let me know if you have any follow-up questions!

Best regards!

[CophieSollins · Accepted solution]

I found a great solution. Unmatched offer an app called sequential, it costs £14 a month but works a dream. 

Was easy to set up and havent had to amend it since its been running. 

[AnnaBaskey]

Perfect that Sequential works for you! It is very similar to our own app but a little more expensive. 

[BérangèreL]

Hi @CophieSollins, that’s awesome, thanks for sharing this integration with the HubSpot Community!

Here is the link of "Sequential" on the HubSpot Marketplace.

Thanks and have a great day!
Bérangère

[AnnaBaskey]

Hey @CophieSollins , 

as Karsten already mentioned, there is no native HubSpot function. 

You can of course do this by using custom code but for that would need Data Hub Professional which costs around 711 €/yearly or 790 €/monthly or developers on your end. Because of this we have created an app called ‘Generate Sequential Numbers’. It is an easy, reliable option that allows you to create a workflow automation which can attach different kinds of numbers, for example a ticket number each time a ticket is created! They can contain Pre- or Suffixes and you can set it to a certain fixed length, as well as choose the starting number to just continue if you had already started for example a manual numbering system beforehand and want to now do this within a workflow action ! It is 9,99 per month or 99,99 per year.

For more info on what the app can do, you can check the marketplace listing , look at our documentation or simply ask us via apps@baskey.eu! We are always happy to help, so don’t hesitate to contact us!

[JMcNeil1701]

Hey Hubspot? Why is this not an included feature of the system to enable an autogenerated numerical sequence? It seems like this should be a basic native function.  Your competition has this available without custom coding, or additional features.  It is a system counter, increased by one, for each new object creation.

[JHeijlen]

I agree. 

Furthermore, I have put in place a mechanism to create a rolling number for my tickets but that still not resolves the issue as I see know way to have this number integrated in the customer portal which keeps working with the object Id of the ticket (first clients ticket issued got a id over 4 billion .... bit weird)

[karstenkoehler · Accepted solution]

Hi @CophieSollins,

There isn't a default feature in HubSpot to achieve this, unfortunately. It would require either a custom code action in a workflow (available in Operations Hub Professional) or a third party solution, e.g. Zapier and Google Sheets.

With the first options, a custom coded workflow action would keep track of the running number and populate a ticket property. Here a developer would have to code such an action.

With the second option, you would sync tickets into a Google Sheet using Zapier, populate the running number / code in the sheet and sync the tickets back into HubSpot, along with the code.

Let me know if you have any follow-up questions!

Best regards!

[CophieSollins]

Hi, @karstenkoehler can you recommend a developer who could do this for me?

[LMeert]

Hi @CophieSollins,

@karstenkoehler mentionned me you needed someone to develop that for you.
I can help you out if you'd like, feel free to send me a DM and we'll take it from there !

Have a good day,

Ludwig