Publish the details of your records in any App with a delightful, customer-facing PDF document. You can also choose the style and format that best suits you and your company by designing your template in Microsoft Word or Google Docs. Publishing PDFs is a great tool for generating Quotes or Proposals via FreeAgent!
Edition Qualifier: This feature is available in all FreeAgent Editions.
User Permissions: Only Administrator users can use this feature.
In this tutorial we will cover the following topics:
Create your PDF Template
First, we recommend that you either use Microsoft Word or Google Docs to create your desired document with all the styles and elements that you would like to have. It could be a quote, an invoice, even a project proposal. Once you have something like the samples shown in the image below, it is time to prepare the template.
To create the template, you will be replacing the elements in your document for 'tags' (<<>>) that will point to an existing field within FreeAgent CRM. Let's go through the second sample image step by step.
Identify replaceable elements
Start by identifying those elements in your document that can and need to be replaced by the actual values from your record. In the first sample image, we have identified a few values which should be replaced with values within the FreeAgent record.
The top section includes your company's information as part of the header and doesn't change from quote to quote, so you can enter your company's consistent information (name, address, etc.). However, the Quote ID is a field in FreeAgent that changes from quote to quote so the system must replace it on the creation of a new quote. Use the following tag: <<id>> since the FreeAgent Field is called 'ID'. We do the same for all the other replaceable elements and we get:
The <<id>>, <<company>> and <<address>> tags that are seen here are all available as fields within the 'Quotes' App. Please note that the name of the App, as well as the available fields, will change according to your own FreeAgent CRM configuration.
When the field name is composed of two or more words, your tag will need to be capitalized as follows: twoOrMoreWords -> the first word of the field name is lowercase, while the rest of the words are capitalized, and there shouldn't be any spaces between words.
As for dates, they are available in the App as well, they just look slightly different from the other tags, as we are applying a specific format to them.
<<{dateFormat(yourDateFieldName,'MMM dd, yyyy')}>> will print the date in the following format
Apr 06, 2020
There are some special formats that you can apply to your fields according to their type.
Let's review the second half of the template. Now we will add the information for the lines in our App. This section should be set up as a table to identify each of the elements in a row. All the elements inside the table, except the column name, will be replaced by values from the lines in the App. Therefore in the PDF template, the values have to become tags.
We just need one row for the items inside the table. We also need two additional rows to mark the beginning and the end of the lines within the table. The result would look something like this:
The column names are not replaced by tags. Then we have a row with <<rr_yourAppLine>> which tells the system that the information that goes after comes from a line and not the App itself. If your line name includes two or more words, remove the space between the words and capitalize the first letter of all of the words except the first one, which needs to be lower case. <<er_yourAppLine>> marks the end of the line elements in your template.
To display quantities, amounts (currency), and other fields with the number type, please review the special formats section.
Once the template is ready save, export, or convert it to .docx as it is the only accepted format to import your template into FreeAgent CRM.
Special Formats
Date Formats | Result |
<<{dateFormat(yourDateFieldName,‘MMM dd, yyyy’)}>> |
Apr 06, 2020 |
<<{dateFormat(myDate,‘MMM dd, yyyy’)}>> |
May 27, 2020 |
<<{dateFormat(yourDateFieldName,‘EEE, dd MMM yyyy’)}>> |
Thu, 30 Apr 2020 |
<<{dateFormat(myDate,‘yyyy’)}>> |
2020 |
<<{dateFormat(myDate,‘EEEE, dd 'of' MMM’)}>> |
Wednesday 27 of May |
<<{dateFormat(myDate,‘EEEE’,‘dd-MMM-yyyy’,‘US’)}>> <<{dateFormat(myDate,‘EEEE’,‘dd-MMM-yyyy’,‘ITALY’)}>> <<{dateFormat(myDate,‘EEEE’,‘dd-MMM-yyyy’,‘GERMANY’)}>> |
Wednesday mercoledì Mittwoch |
<<{dateFormat(myDate)}>> |
25 May 2020 |
Date Time Formats | Result |
<<{dateTimeFormat(yourDateTimeFieldName,‘MMM dd, yyyy hh:mm’)}>> |
Apr 06, 2020 12:40 |
<<{dateTimeFormat(yourDateTimeFieldName,‘MMM dd, yyyy hh:mm:ss’)}>> |
May 27, 2020 11:37:12 |
You can use the time format in convination with the above date formatting options.
Number Formats | Result |
<<{numFormat(yourField,‘0.0’)}>> | 12.3 |
<<{numFormat(yourField,‘$0.00’)}>> |
$12.34 |
<<{numFormat(yourField,‘###.##’)}>> |
12.34 |
<<{numFormat(yourField, ‘¤#,###.00’, ‘USA’)}>> |
$1,234.50 |
<<{numFormat(yourField, ‘¤#,###.00’, ‘GBR’)}>> | £1,234.50 |
<<{numFormat(yourField, ‘ #.###,00¤’, ‘DE’)}>> | 1.234,50€ |
Pro-Tip for Images
If you are looking to add a logo to your PDF template or any other image, we recommend that you follow the instructions described in the tutorial below to achieve the best results possible.
How to Achieve a Perfect Logo in your PDF Files
Upload Template to App
Open the menu and go to 'Admin Settings' to display the available options, then click App Setup to display even more options. Then select your desired app and click on 'App Configuration'. You can also use the search function to get there faster, just start typing 'App Configuration'.
Here you have the option to upload a file where it says 'Generate PDF Template'. Here you will need to upload your template. The only allowed type for the template is '.docx'
Publish via PDF
To download the PDF that is generated in the App, go to the App, and select one of the records. There you will see a 'paper sheet' icon located in the top right corner of the information box of your record. Once you click on it, the PDF will be processed and the download will start shortly after.
You've just created a gorgeous PDF that includes all of the relevant data you want to share with your customers in a simple, yet beautiful way.
Samples
If you want to see some examples, click on the template you would like to download. You can use these to get an idea of how they work by modifying the values inside the <<>> for the name of your fields. It is important that you remove those that don't apply for your configuration, as it will prevent the PDF file from being exported correctly.
Template for a simple quote
Template for a travel quotation
Troubleshooting
If you have followed this tutorial but nothing happens when you click on the PDF icon to download, then most likely there is something missing in your template. Some of the most common mistakes are:
- The file is missing some characters, it could be an initial < or a closing > or other characters like apostrophes (' or ') or curly brackets ({ or }).
- There is a tag <<field>> that either doesn't exist in your App or in the lines of your App or is not following the naming convention fieldName.
If you have reviewed your template but are still having issues downloading your PDF, email the template to support@freeagentsoftware.com or share it through the Support Chat!