How to format Deal Property numbers?

gotmike
Top Contributor

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

8 Replies 8
gotmike
Top Contributor

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

0 Upvotes
gotmike
Top Contributor

@pmanca – any help here?

0 Upvotes
3PETE
HubSpot Employee

@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.

0 Upvotes
gotmike
Top Contributor

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
}
0 Upvotes
gotmike
Top Contributor

Sorry I didn’t really answer your question…

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

0 Upvotes
3PETE
HubSpot Employee

@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

0 Upvotes
joshatpyramid
Participant

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?

Hitunen
Participant

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

0 Upvotes