How to format Deal Property numbers?

[gotmike]

When we create Deal Properties, how can I cause a number to be treated as currency or percentage?

[Hitunen]

+1 would like to know how to create an unformatted number property using API.

[joshatpyramid]

It's 2020 and currency is now supported. There's still some relevance to this question, though.

In Hubspot properties, I see the options to format a number as "Formatted Number", "Unformatted Number", and "Currency" - which is cool, but I can't seem to tell the difference between Formatted and Unformatted numbers - documentation around that distinction doesn't exist or I can't find it.

In short, going back to the original question on this thread - can I format a number property as a percentage, or are we out of luck still?

[gotmike]

Sorry I didn’t really answer your question…

I’d like to see… $50,000 instead of 50000

[3PETE]

@cre thanks for the explanation. At this moment in time you cannot make a field be a currency to see ‘$50,000’ instead of ‘50000’. This would be a nice feature to have and if you feel inclined you can add it to our ideas board if it isn’t already.

ideas.hubspot.com

[gotmike]

So when I review the docs here: https://developers.hubspot.com/docs/methods/deals/create_deal_property

I see the following data types:

• string
• number
• bool
• datetime
• enumeration

If my revenue can be currency, that’s fine, but what if I want to track pursuit costs as well?

I can’t add a deal property with a currency data type, can I?

{
        "name": "pursuit_costs",
        "label": "Pursuit Costs",
        "description": "Money spent chasing the deal",
        "groupName": "dealinformation",
        "type": "number",  //-- would be nice to have "currency" here
        "fieldType": "number",
        "formField": true,
        "displayOrder": 0
}

[brunocastro]

I believe that having an additional field, like "numberFormat" or just "format" (so that the same field can be used for other data-types, would be the best solution so that anyone can use the format they want. I.e. "£#,###.00".

[gotmike]

@pmanca – any help here?

[3PETE]

@cre what would be the end result once you had the number as a currency or percentage? The revenue amount should be a currency field for you.

[gotmike]

any ideas here? seems like this may not be possible?