Number Property Not Accepting Decimals or Commas

Data Hub đź’¬ RevOps Discussions
1

Hi there, I’m trying to sync over revenue data from Stripe into Hubspot using Make (Integromat), and as I try to format the incoming number from Stripe (which has no commas or decimals) to have a decimal, the Hubspot number property doesn’t accept it.

For example, Stripe send over 10000 and I need 100.00. However, when I try to sync over the formatted number, the property claims that is doesn’t accept decimals or commas. I tried with the property set as “Formatted Number” and it still didn’t work. Ideally, this would work regardless of whether it is a Formated or Currency type.

What am I missing here?

2

Hey @MArdila7 currently the HubSpot number properties only accept numbers. The formatting is done by the HubSpot system itself. If you select the number property to be formatted it will format it internally.

It does not currently accept additional characters outside of numbers for custom formatting. The only way to achieve this would be to use a single line text field, but this may potentially open your CRM up to data inconcistencies and diminish the integrations/automation you can setup going forward.

There’s actually a helpful guide on how number properties work and how HubSpot formats them within the knowledgebase here.

3

@TomM2 How does Hubspot format it internally, then? Is there no way to format properly within ops hub? How does it know what the actual number is when a string comes in? How do I communicate to Hubspot where the decimal should be so it doesn’t inflate the number?

This is pretty useless if I can’t bring in proper formatting or update it within the system or have to use a single-text line.

4

Hey @MArdila7 this is outlined in the article I linked in my original comment.

  • Number: stores a string of numerals or numbers written in decimal or scientific notation. You can select the formatting of a number property when creating or editing the property:
    • Formatted: formats the number with commas, for example 1,000,000. Formatted numbers should not exceed 15-16 digits in length.
    • Unformatted: removes number formatting, for example 1000000.
    • Currency: formats the number as a currency according to your account default currency settings.
5

Hmm. I guess I’ll have to try the scientific notation then because the other way didn’t work for decimals, which is what I actually need not the commas. What a pain. Thanks!