PractiFI and Conga are a match made in document generation heaven! Remember what it felt like to have to type all those pesky documents by hand? Well remember no more. Once we’re done with you, you’ll be creating all your documents through Conga for PractiFI. Seriously.
Working with Conga Queries
In the PractiFI universe, Conga uses SOQL Queries to drive the data you can merge into your document templates. If you’re feeling technical, you can find more information on SOQL here.
Take a look at this documentation from Conga to learn more about how they use Conga Queries.
Here we’ll run you through the fancy-pants specifics of how Conga Queries are utilised in Conga for PractiFI.
You can find Conga Queries by following these steps:
- Head to the PractiFI Setup menu and choose ‘Salesforce Setup’
- In the Salesforce UI, click on the App Menu and select the Conga Composer app.
- Go to the Conga Queries tab.
- Choose the ‘All’ view and click ‘Go’.
Now you should see a list of the data sets PractiFI gives you out of the box. Neat, right? From here, you can edit one of the existing queries, or you can create your own from scratch.
To create a new query:
- Click on the ‘New Conga Query’ button.
- Give the query a Name and, optionally, a description. If you’re feeling brave, you can also manually type in your SOQL statement right here. Otherwise, leave it blank and we’ll use the Conga Query Builder to generate this statement. Click Save.
- Click the ‘Conga Query Builder’ button.
- Select the salesforce object that you want to extract data from and click ‘Next’.
- Select the fields you want to include in your data set. From here, you can choose fields from your chosen object, and any child object, then Click ‘Next’.
- Set any filter criteria on your data set. Conga will automatically pass through the ID of the master record to the first filter (this is either the Client ID or the Policy ID and is pre-defined in the PractiFI Conga buttons). So you should set the Field to the appropriate reference field, and leave the right hand input box blank. Click Next.
- Finally, you can preview your query and text it by passing values into the filters. Usually, you will just want to paste a master record ID (Client ID or Policy ID) into the first text box and click ‘Preview’.
- Once you’re happy with your Query, click ‘Save’.
- Copy the ID from the record’s URL – you’re going to need this in the next steps.
Adding Data Sets to Conga in PractiFI
So now you’ve got your new data set all setup. You clever little thing! So let’s get that data set into PractiFI.
To do this, all you need to do is:
- Head back into the PractiFI UI.
- Head back to the PractiFI Setup Menu. This time, select PractiFI Settings.
- Go to Config Settings (the little Cog icon on the left), and select the ‘Integrations’ tab.
- Here you should see two ‘Conga URL Parameters’ fields – one for Client and one for Policy. These fields allow you to customise the way Conga works in PractiFI using standard Conga parameters. Edit the settings, and in one of these fields (you know which one’s the right one!) , type in ‘&QueryId=[QueryAlias]‘ (replace QueryAlias with the name of the data set as you would like it to appear in the Conga Template Builder). Then paste in the ID you copied earlier.
- Save you work, then verify you’ve done everything right (but we know you have) by heading into a Service or Policy and running Conga.
Voila! Now you’ve got all the mad skills you need to customise Conga for PractiFI exactly the way you need it. Take a rest. You’ve earned it!