Auto increasing a number property

[MichaelC]

Hello CRM Community 👋

My goal is to create a custom number property that auto increases for each new created record. Lets say we want to generate a list of customer numbers starting with 100.

Lets make this simple and say that each new created contact is a customer in my example. Creating the first record would give the contact number 100. Next one created would have 101 and so on. 

I know you can do a lot of math with the number property but is there an ability to auto increase the value from the latest created property increased by +1. 

Does anyone know a way to accomplish this?

Best regards

Michael

[Thrive]

Hi there, we have built an app for the marketplace that allows you create infinite calculations. In this case, you can easily enrol the object, build the calculation to take your property and add +1 to it and save the result in the property. Feel free to check it out here here: https://ecosystem.hubspot.com/marketplace/apps/marketing/data-management/calculations-3449553

[emelie]

I really need this! Do anyone know if HubSpot have create a solution for it?

[ALanel]

I built a proces to get this working outside of HS with the API - message me for info I can share 🕺

[ContentNinja]

Hi Folks, you can do this in workflows. @MichaelC you can have a trigger that every new contact should use in the workflow. Have a number property called "Contact count or Lead count" then use the "increase or decrease property value" in workflows. Attached are screenshots for reference. Hope this solves the issue for you and similar others.

Tushar Mittal

Digital Marketer | HubSpot Platinum Partner | MarTech Expert

If this helped, please upvote and "Mark it as a Solution" so that it can help the community.

[emelie]

Hi! Thanks for your feedback! I tried this but it don't set a unique numbers, it only add "1" in every new deal I create for example. I would like it to count. So every new deal I create should get a "Order number", the first deal get "1" the second "2" etc. So a unique number for each deal. Now there are only record id which are random numbers.

[JMcNeil1701]

Hey Hubspot, how about allowing access the to object ID in the reporting if we can't do an autonumber?  I don't want to do an export the database each time I need a unique field to tie new imports back to. I want a unique field in my reports.  Not all my items will have an e-mail address

[LStrack5]

Hi Michael, I saw your thread on Hubspot community page and wondered if you found a solution and if you can help me with my issue. I am also wanting to add +1 number to a custom property in Hubspot. In this instance it is for Club Membership and the members need an auto generated membership number..

I have connected with you on Linkedin if you would like to discuss. thanks Lucy

[MichaelC]

@karstenkoehler Thanks for the quick answer.

Initially this is to a client that wants to get started with HubSpot and we dont want to push the operations hub pro initially for such a small business. We where looking for a basic property function to do the job. But I guess there is not - maybe its a topic for the ideas board. 

I have the ability to do the job in an api call aswell (im a developer) so to me its actually easier to do the job myself rather than using Zapier and Google Sheets in this case. But for general usage that might be a way to solve it. 

Keeping this open to hear from others if they have any ideas. 

[karstenkoehler · Accepted solution]

Hi @MichaelC,

This isn't possible out of the box in HubSpot because in workflows, HubSpot isn't comparing records at all. You can increase a value that is already available on a record, but you can't hand out running numbers to records as they enter a workflow.

However this can be achieved with custom code actions in workflows, available in the new Operations Hub Professional. There is a similar thread that already includes some lines of code that you could adapt for your purpose.

Alternatively, you could also achieve this with Zapier, I think, sending contacts into a Google Sheets where they receive a running number and then back to HubSpot.

Best regards!

[eliot_martin]

Basic functionality that should exist in any modern CRM that can only be "solved" by purchasing an additional £7000 per year subscription or connecting not one, but two third-party web applications.

Great work HubSpot!

[mmup]

It's truly amazing how they sell absolute basic functionalities for an astronomical price. ROI must be 5.000x