The HubSpot (BETA) integration will be receiving continuing development. Please send us your feedback on the integration and what you would like to see added in the future at firstname.lastname@example.org.
It's time to make this quote beautiful!
You can easily change the formatting of currency in the Desktop Designer (as well as dates, numbers, and more!)
- Place your carrot on the Out Tag in the "Unit Price" column and click "Format Data" under the Windward ribbon:
- In the "Format Data" window that opens, select "Currency" and select an appropriate currency formatting:
- Click "Apply" and close the dialog.
- Output your template to see that currency formatting will now be applied to the Unit Price at output:
- Repeat these steps with the Out Tag in the "Total" column to also format it as a currency:
Most quotes aren't complete with a total amount for the quote:
- Type the word "Total" in the bottom middle of the Line Items table:
- Drag-and-drop the Deal "amount" property into the cell next to Total:
- Change the formatting on the total quote amount to currency:
- Output to test your changes:
To dynamically output the date a quote was generated:
- Type the text "Quote Date" in the bottom left-most cell of the first table:
- Insert an Out Tag in the same cell:
- Windward supports a number of functions, including a "Today" function that always outputs todays date. Put your carrot on the Out Tag and click on the "Equation" button in the Windward ribbon
- Find the "TODAY" function, select it, and click OK.
- Click OK again in the Function Arguments window: this function doesn't require any arguments.
- Click Preview to see the date being returned. Notice that the formatting probably isn't what you want in your output document:
- Just like you formatted currency earlier you can also format a Date. Open the Format Date window, go to the Date section, and select a Date formatting that you prefer for your output:
- Generate output to test your changes.
You can get very creative in how you format your tables in Microsoft Word. This will tutorial will provide only a brief overview of table formatting in Word that will help you achieve your desired format.
- Start by bolding all of your title text in your tables:
- To make your tables a little more spacious add some buffering around your text. Highlight all the cells in the table:
- Go to the Table Layout ribbon and click on "Cell Margins"
- Increase the top and bottom margins to 0.05" and click OK. You'll see your table become more spacious in the template:
- Repeat for your second table.
- Highlight all the cells in the "Total" column of the second table
- In the Table Layout ribbon you can change the content alignment to upper-right.
- Repeat this with the "Unit Price" column:
- Place your cursor in a title cell:
- Under the Table Design ribbon click on Shading and select a color to shade the title cell:
- Repeat this for all your title cells
- Click and drag the vertical borders of your table columns to re-size your table to appropriate column ratios:
- Repeat for all your table columns until you are pleased with the template appearance.
- You can remove all of your table borders by selecting all the cells of a table:
- And then in the Table Design ribbon clicking on Borders and No Border:
- Do this for both tables:
- You can also add partial borders with the same method. Select the title row of the second table and apply a bottom border:
- Apply borders and shading throughout the template to fit your design:
- Double click at the top of your template to open the header in Word:
- To have a nicely formatted header, insert a 2X1 table:
- Insert your company logo in the leftmost cell (you can drag it from a file on your computer):
- Add your companies contact information in the right most cell and change it's alignment to be right aligned:
- Remove the borders for the table:
- To finish off the template, increase the size of your quote title to an appropriate title size:
- Generate output to see your finished quote:
Now that's a good looking quote! All you need to do now is upload it to Windward Hub under the HubSpot integration and run output from the Windward Hub integration in HubSpot from any Deal to get a custom quote for that Deal!