Tips, Tricks & Best Practices

CWVader
Member

Convert numbers into words in Quotes

SOLVE

Hi, we want to use Quotes for sending out our contracts. One of the terms we use holds the price per item in number and in words. The price in number is not that difficult to add. But how can I add the total amount in words, since this is not always a fixed amount. Or is there an option I can manually add text for every quote in a dedicated place?

2 Accepted solutions
TomM2
Solution
Thought Leader | Platinum Partner
Thought Leader | Platinum Partner

Convert numbers into words in Quotes

SOLVE

Hey @CWVader for the "total monthly price" if you want this to be automatically added in a personalization token, we would need to have a property for it. In this case, if you're on a pro or enterprise subscription you can use Calculated properties with these you could set the calculated property to add or subtract the "unit price" and "discount given" if these are both properties. 
Alternatively, you could create another property for "total price" and store that value in a property manually (IE calculate it yourself and store it in a custom property). As long as there's a property and a value on that object the personalization token will auto populate with the value. 
You could also use a custom property for "total value in words" which could be manually filled in by a user and used as a personalization token, at the moment there's no way to automatically convert number properties to words in personalization tokens or properties.

Regarding custom text on a per-invoice basis, you can add in comments and item comments to the middle of the quote on each invoice, which appear like this screenshot, but all prices must be added to custom line-items, you can add line-items again per invoice but it will create a new line item. 

TomM2_0-1683212772786.png

 



Hope this helps! 

Tom Mahon
Technical Consultant | Solutions Engineer | Community Champion
Baskey Digitial

Book a meeting

Did my post help answer your query? Help the community (and me) by marking it as a solution.


View solution in original post

jolle
Solution
Recognized Expert | Partner
Recognized Expert | Partner

Convert numbers into words in Quotes

SOLVE

@CWVader thanks for sharing! And thank you for the tag, @kvlschaefer!

 

Adding to what @TomM2 said, you unfortunately cannot automatically convert numbers to words in HubSpot. However, I feel like you could use snippets here (more info in this HubSpot Knowledge Base article).

 

For any text fields within your quote (like where you would add comments or additional details for the buyer specific to that quote), you have the option to add text from a snippet. That snippet can include your terms and placeholder text like you have in your screenshot where the user would need to spell out the total amount.

 

If you're going to use personalization tokens within your snippet, I recommend using deal personalization tokens since those should stay consistent regardless of who's viewing the quote (whereas contact/company personalization tokens will vary based on the contact that HubSpot knows is viewing the quote).

 

Hope this helps!!

Jacob Olle

Marketing Operations Manager

HubSpot Certified Trainer

Create Your Own Free Signature

View solution in original post

8 Replies 8
kvlschaefer
Community Manager
Community Manager

Convert numbers into words in Quotes

SOLVE

Hi @CWVader,

 

Thanks for reaching out! 

 

It's my understanding that you would like to know if it's possible to write out the total amount on a quote correct instead of entering the amount in numerical form, is that correct?

Would you be able to please share a screenshot of the item you are referencing on a quote? 

 

Thank you! 

 

Best,
Kristen


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !
CWVader
Member

Convert numbers into words in Quotes

SOLVE
Hi,

Yes. See screenshot attached.

We have a variable price per unit that we prefer to convert in words in the
contract.

I also have a second question: I need to add the registristration number of
a company in the contracts. I do not see the property for that. Which is
not a big deal because we can create that but when we create it looks it
doesn't pop up in the quote options to add/personalize.
kvlschaefer
Community Manager
Community Manager

Convert numbers into words in Quotes

SOLVE

Hi @CWVader,

 

Thanks for the details!

It looks like your screenshot didn't attach to the post. Would you mind sharing it again? Thank you! 

 

Best,

Kristen


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !
CWVader
Member

Convert numbers into words in Quotes

SOLVE

I have no put in the "Unit price" but I need it also for the monthly total price (unit price minus discount).

Screenshot 2023-05-02 at 12.57.48.png

TomM2
Solution
Thought Leader | Platinum Partner
Thought Leader | Platinum Partner

Convert numbers into words in Quotes

SOLVE

Hey @CWVader for the "total monthly price" if you want this to be automatically added in a personalization token, we would need to have a property for it. In this case, if you're on a pro or enterprise subscription you can use Calculated properties with these you could set the calculated property to add or subtract the "unit price" and "discount given" if these are both properties. 
Alternatively, you could create another property for "total price" and store that value in a property manually (IE calculate it yourself and store it in a custom property). As long as there's a property and a value on that object the personalization token will auto populate with the value. 
You could also use a custom property for "total value in words" which could be manually filled in by a user and used as a personalization token, at the moment there's no way to automatically convert number properties to words in personalization tokens or properties.

Regarding custom text on a per-invoice basis, you can add in comments and item comments to the middle of the quote on each invoice, which appear like this screenshot, but all prices must be added to custom line-items, you can add line-items again per invoice but it will create a new line item. 

TomM2_0-1683212772786.png

 



Hope this helps! 

Tom Mahon
Technical Consultant | Solutions Engineer | Community Champion
Baskey Digitial

Book a meeting

Did my post help answer your query? Help the community (and me) by marking it as a solution.


CWVader
Member

Convert numbers into words in Quotes

SOLVE
Hi, thank you for the tip. When I try to add a new property I either can
not add it as a calculation or when I can (by selecting a different type or
group) I do not see the property "unit price" and "discount given".
Anything I do wrong here?
0 Upvotes
kvlschaefer
Community Manager
Community Manager

Convert numbers into words in Quotes

SOLVE

Hi @CWVader,

 

Thank you for the helpful screenshot! 

 

It looks like you want to use personalization tokens for quotes and add text if possible, correct? 

 

I wanted to add our subject matter experts to see if they have any ideas.

Hi @jolle@TomM2 - Do you have any suggestions for @CWVader's use case? 

Thank you! 

 

Best,

Kristen


Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !
jolle
Solution
Recognized Expert | Partner
Recognized Expert | Partner

Convert numbers into words in Quotes

SOLVE

@CWVader thanks for sharing! And thank you for the tag, @kvlschaefer!

 

Adding to what @TomM2 said, you unfortunately cannot automatically convert numbers to words in HubSpot. However, I feel like you could use snippets here (more info in this HubSpot Knowledge Base article).

 

For any text fields within your quote (like where you would add comments or additional details for the buyer specific to that quote), you have the option to add text from a snippet. That snippet can include your terms and placeholder text like you have in your screenshot where the user would need to spell out the total amount.

 

If you're going to use personalization tokens within your snippet, I recommend using deal personalization tokens since those should stay consistent regardless of who's viewing the quote (whereas contact/company personalization tokens will vary based on the contact that HubSpot knows is viewing the quote).

 

Hope this helps!!

Jacob Olle

Marketing Operations Manager

HubSpot Certified Trainer

Create Your Own Free Signature