APIs & Integrations

gotmike
Top Contributor

How to format Deal Property numbers?

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

10 Replies 10
nanda_rizki_d_p
Member

How to format Deal Property numbers?

you must waiting api v4 because hubspot have new property like this :

    "numberDisplayHint""formatted",
    "optionSortStrategy"null,
    "hasUniqueValue"false,
    "showCurrencySymbol"true,
    "groupName""companyinformation",
    "name""nameproperty",
    "currencyPropertyName"null,
    "searchableInGlobalSearch"false,
    "referencedObjectType"null,
    "externalOptionsReferenceType"null,
    "externalOptions"false,
    "label""label",
    "fieldType""number",
    "formField"true,
    "type""number",
    "description""",
    "options": []
0 Upvotes
Hitunen
Participant

How to format Deal Property numbers?

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

joshatpyramid
Participant

How to format Deal Property numbers?

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
Top Contributor

How to format Deal Property numbers?

Sorry I didn’t really answer your question…

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

0 Upvotes
3PETE
HubSpot Employee
HubSpot Employee

How to format Deal Property numbers?

@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
gotmike
Top Contributor

How to format Deal Property numbers?

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
Participant

How to format Deal Property numbers?

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

0 Upvotes
gotmike
Top Contributor

How to format Deal Property numbers?

@pmanca – any help here?

0 Upvotes
3PETE
HubSpot Employee
HubSpot Employee

How to format Deal Property numbers?

@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

How to format Deal Property numbers?

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

0 Upvotes