cloudanswers

CloudAnswers

for-developers

For Developers

Have you come across a scenario where you were required to dynamically pull the customer logo from Salesforce Documents or Attachments while creating a proposal, invoice, etc for a customer? This article explains how to do that.

I’m going to demonstrate how we can embed an image uploaded as an Attachment or Salesforce Document into a Conga document. As per the [official Conga docs](https://documentation.conga.com/cpsfwin20cg/creating-composer-templates/word-templates/advanced-word-templates/merge-images-with-salesforce-id-in-word), this approach works with images uploaded as Salesforce Documents or Attachments to a record.

For this article, let’s suppose we want to create a proposal for a customer from a Salesforce Quote. And, we want to dynamically pull the customer logo from the related Account record and embed it into the generated Conga document.

Now, let’s go through each step one by one.

## Create A Conga Query

The first step is to create a Conga Query to fetch the Attachment record. Here is the Conga Query which I have set up for this example:

select Id from Attachment where Description = ‘Logo’ and ParentId IN (select AccountId from Quote where Id =
‘{pv0}’) order by CreatedDate desc limit 1

The above query will fetch the most recent Attachment record related to the Account related to the Quote record. And, it has another condition to filter the records by Description field to make sure it pulls the customer logo. The record, Quote in our case, from which we invoke Conga Composer, will replace **‘{pv0}’** with the Id of that record. You can change the **where clause** as per your need to fetch the correct record. We just need the Id of the Attachment record, so just query that field.

_Note:_ If you copy and paste the above query, make sure your Attachment record’s Description is set to **Logo.**

## Create Proposal Button on Quote Object

In this step, we are going to create a button on the Quote object and add it to the page layout. I have set up the following button for this example and added it to the appropriate page layout.

_Create Proposal (Lightning Version)_

### URL for Salesforce Lightning button

/apex/APXTConga4\_\_Conga_Composer?serverUrl={!API.Partner_Server_URL_290}&id=
{!Quote.Id}&QueryId=[Attachment]a1b63000005d8MHAAY&WordStripIfs=1&SC0=1&SC1=SalesforceFile&OFN={!Quote.Name}

The above button works for the Lightning Experience. For Salesforce Classic you would need to set up a different button which looks like as shown below and makes sure this button shows up for users in Salesforce Classic.

_Create Proposal (Classic Version)_

### URL for Salesforce Classic button

/apex/APXTConga4\_\_Conga_Composer?serverUrl={!API.Partner_Server_URL_290}&id=
{!Quote.Id}&QueryId=[Attachment]a1b63000005d8MHAAY&WordStripIfs=1&SC0=1&SC1=SalesforceFile&OFN={!Quote.Name}

#### Let’s Test What We Have So Far

Before we proceed further, let’s make sure we can retrieve the attachment record in the Conga Composer with the Conga Query which we have setup. For that follow the following steps:

1. Create or go to an existing Account record
2. Upload a customer logo as an attachment to Account (_Tip: You may need to switch to Salesforce Classic to upload the file as an Attachment)_
3. On the Quote detail page, click on the Create Proposal button. This will open Conga Composer
4. On Conga Composer, click Template Builder under Tools & Settings

If everything is set up correctly, we should see the query result for the **Attachment** query as shown below

_Template Builder_

If you were able to see the Attachment record in Template Builder as shown above, let’s go ahead with next steps. Otherwise, revisit the previous steps and make sure everything is setup correctly.

## Add IMAGE Tag To Conga Template

In this step, we are going to add the Conga IMAGE tag to a Conga Template and see end result in the generated document. Here is a [sample template](https://drive.google.com/file/d/1Kbq9UPc9DUreReFm4upLU0STeU97rBZe/view?usp=sharing) that we have created for this article.

**Note:** You can try with the above template or copy and paste the tags from our template into your template.

Now, let’s test the above template in Conga Composer.

- On Conga Composer, choose the Local Template tab and select the Conga Template as shown below.

_Select template_

- After selecting the file, click on the Preview button.

_Preview Template_

Here is how the generated doc looks for me.

_Generated doc with embedded customer logo from Account._

---

## Conclusion

We can use the Conga IMAGE tag to embed images uploaded as attachments to a Salesforce record. We can extend this example to different real-world use cases and the possibilities are endless.

If you need help with Salesforce or have something a little more complex that might require advanced developer knowledge? We can help. Contact us at [help@cloudanswers.com](mailto:help@cloudanswers.com) or chat with us.

---

Read also

[Effective data storage in Salesforce for every business size](https://cloudanswers.com/effective-data-storage-in-salesforce-for-every-business-size/)

[Custom domains and free SSL on Force.com Sites](https://cloudanswers.com/custom-domains-and-free-ssl-on-force-com-sites/)

Learn how you can embed an image uploaded as a Salesforce Attachment in a Conga Document. Use the Conga IMAGE tag you can embed images.

embed-image-in-conga-document

Embed Image In Conga Document Using Salesforce ID

for-everyone

For Everyone


Whether checking your business’s progress or presenting results to the executive board or business partners, precise reporting is critical to your Salesforce success.

![](/uploads/salesforce-logo-png.png)

The profit of your entire Salesforce investment depends a lot on the business insights that you get. These insights get your team to generate more quality leads, close more deals, and serve customers with seamless customer service. It means that the power of creating and maintaining meaningful and accurate reports and dashboards can't be exaggerated.

Proper reports have always been a regular source of confusion among sales and marketing reps for as long as the customer relationship management software has been in practice. Many teams who use the software to track their sales opportunities and activities have ranted about the numerous difficulties in producing reports from their Salesforce sales and marketing data.

In short, the challenges of Salesforce reporting within Salesforce are as follow:

- It requires manual work, that can be repetitive and time-consuming
- You can’t join external data with SFDC (SalesForce Dot Com) data in a single SFDC report
- For the average user finding the right Salesforce data is difficult
- Salesforce allows to send 200 reports a month (Enterprise Edition), 50 a month (Professional Edition)
- Each person can subscribe to up to 5 reports and 5 dashboards
- Report subscriptions are still sent when there is no data.
- Only users can subscribe to reports, making it difficult to share with external stakeholders.
- Limited visualization options
- Problematic cross-object reporting
- Users without the new theme are unable to create, edit, or run joined reports.
- Difficulties in accessing historical data - a range of data must be planned upfront (before actually they are needed) and they are hard to change once they’ve been set
- Filtering is restricted in some dashboards that contain multiple components based on the different report type

More about Salesforce limitations [here.](https://help.salesforce.com/articleView?id=faq_reports_common_limits.htm&type=5)These limitations in reporting within Salesforce have created an opportunity for external reporting and dashboarding tools to step in.  As a result, most Salesforce customers choose to extend their reporting capabilities beyond what Salesforce can deliver.

Let us quickly introduce you to a few of the most popular reporting apps that you can find on the [AppExchange](http://www.appexchange.com)

![](/uploads/tablaue-logo.png)

**Tableau** is a good choice as a third-party analytics tool when your reporting requirements exceed the capabilities that are native to Salesforce.

It offers multiple business benefits:

- Easy to use
- Full information availability. Tableau has built-in integration with Salesforce, allowing Tableau reports and dashboards to be embedded within the Salesforce. It can pull in data from the requested sources. It is not limited to only the data that is stored in Salesforce. Connect to almost any database.
- Many types of charts can be created including Sankey, Doughnut, Maps, etc
- Data blending and data extraction. Salesforce reporting is not able to combine data across Salesforce modules. For instance, it cannot display marketing engagements and pipeline growth on the same chart. Tableau does this type of data blending natively.
- Dashboards can be viewed on multiple devices: tablets, mobiles and laptops
- No data limits.

**Price:** starting from $70/month

[Tableau on AppExchange](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000009wsiDEAQ)

![](/uploads/klipfolio-logo-black-red.png)

**Klipfolio** is a real-time data analytics tool for basic to intermediate data visualization / dashboards. It enables users to connect any data source, create data visualization, and share it. It is best used for live display of data from various sources in a consistent interface, but can also be used to a lesser extent for exploratory, self-service business intelligence.

Key benefits:

- White label solution
- Easy to add data from different remote sources like Dropbox to easily incorporate offline data such as targets in Excel files or call center data exported in CSV files
- Possibility to set dynamic variables
- Simple and user-friendly data visualization
- A lot of features and already built-in integrations with numerous data sources
- The hover effect showing the details of a particular data point is extremely helpful and enables the user to take a closer look at specifics if they choose.
- Multiple data source formats, you can make data sources in JSON, Summarized View, and Detailed View.
- Shared/permalink dashboards are perfect for allowing private access without requiring login
- Dashboards can be shared in a variety of formats: PDF, JPG, CSV
- Unlimited users
- Dashboards created in Klipfolio are automatically resized based on the device used

**Price**: starting from $29

[Klipfolio on AppExchange](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3000000B3e6EEAR)

![](/uploads/report-sender-articel.jpg)

**Report Sender** **-** an application that allows you to schedule and sent reports to any email address, in an Excel-friendly format. There are no restrictions on objects or fields, and all Salesforce sharing rules and field-level security for users are obeyed.

How the Report Sender can help you in daily reporting duties:

- You can easily schedule and customize reports
- You can send reports to all email addresses including non-Salesforce users
- Reports can be sent as CSV or Excel file
- Unlimited number of reports
- Easy email body customization
- Multiple schedule options
- You can send just one-time email
- Premium users can skip sending blank reports

Report Sender helps you in your daily business. It can for example, automatically send leads to co-marketing partners from Salesforce campaigns and lead reports. Or send the sales pipeline to the executive team. It keeps all interested parties up to date with business performance indicators, not just those with access to Salesforce.com

Full disclosure: We built this app

**Price:** free and premium

[Report Sender on AppExchange](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EJdlFUAT)

![](/uploads/conga-composer.png)

**Conga** is built for sales and marketing professionals who need to generate and send a presentation, proposal, report or contract. Conga allows users to combine data and merge data from external databases. Users can collaborate by setting up document templates and workflows and can access and sign documents remotely. The platform provides the tools to easily negotiate with key stakeholders and sign contracts on the go.  Conga also allows multiple people to work on a contract together, and redline the document.

Conga composer benefits:

- Salesforce template integration.
- Complex pages pulling multiple objects
- Template based for reusability
- Multistep processes that saves time
- Flexible design
- Works well with other software like [Adobe Sign](https://www.trustradius.com/products/adobe-sign/reviews), DocuSign and Financial Force.
- Flexible on how documents are configured
- Deals with complex merges of data into a document.
- Professional support
- Consistency in data
- Merging Salesforce data into easy to use format
- Supports many different output formats; PDF, DOCX, PPTX, XLSX, etc
- PDFs are completely customizable to meet branding
- Automatically store details in the contact's activity history so that you can see who has received what documents.

Price: starting at $20

[Conga Composer on AppExchange](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N300000016b7FEAQ)

![](/uploads/Report-builder.png)

**Report Builder by Cloud4J** is an app that enables users to download and schedule existing Salesforce reports and dashboards in a variety of formats. It includes charts, conditional formatting, and can query more than 2,000 records, including formula fields. There is no installation necessary, and it works with existing Salesforce reports.

Let's have a look at important features:

- Robust solution for sending reports and dashboards
- Multiple schedules can be set on a single report or dashboard
- Schedules can be set for one or more users, for Salesforce users and non-Salesforce users, at any scheduled time
- Sends generated documents (like Conga)
- Sends reports, dashboards, and/or documents in a single email
- PDF and HTML options for scheduling reports

**Price:** $0-150/month. Free version cannot send reports.

[Report Builder page](https://www.cloud4j.com/report-builder.html)

![](/uploads/smartsheet-logo.png)

**The Smartsheet** platform offers tools for

Every successful business already uses spreadsheets, Smartsheet turns those familiar rows and columns of cells into an app. A result is a special tool that can handle workflow automation, content collaboration, forms management, project management, activity logging, scheduling, real-time data tracking. This cloud-based app certainly makes spreadsheets smarter, and for certain kinds of work, it might be preferable to a more traditional project management platform

Smartsheets key features:

- Easy to use
- Multiple drop-down menus that allow to quickly and simply create a checklist of tasks for a project, assign team members to each task, and set deadlines.
- Unlimited possibilities for adding custom fields to the task
- Automatic reminders
- Gantt charts
- Customizable templates
- Milestone tracking
- Idea management
- Portfolio management
- Time & expense tracking
- User-friendly interface

**Price:** starting at $14

[Smartsheet on AppExchange](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000003JSACEA4)

![](/uploads/insightsquared-vector-logo.png)

**InsightSquared** helps revenue operations professionals make better decisions by equipping them with actionable, real-time intelligence on sales and marketing KPIs. InsightSquared Tiles is an analytics platform that provides sales with the insights they need to drive performance and close deals. According to the vendor, the comprehensive set of reports provide sales leaders with ready access to all the analysis they need to assess their progress, diagnose performance gaps, and formulate action and coaching plans.

Top features:

- Easy to set up, user-friendly interface
- Powerful, intuitive pre-built dashboards to analyze sales team performance
- Graphical view of the reports
- Customizable dashboard
- Data source connectors
- Drag and drop
- Graphical flexibility and customization, and the ability to pivot
- The Slate report tool allows building SQL reports based on SFDC data
- Automated reports

**Price:** starting at $1 USD

[InsightSquared on AppExchange](https://appexchange.salesforce.com/appxListingDetail?listingId=a0N30000005uuY8EAI)

Improving your Salesforce reporting can help you make more informed decisions about your sales and marketing strategies, your internal operations, and your customer service. The metrics can help you identify weaknesses. But, proper reports can help you find what’s working and resonating with your customers. So improve your reporting results with one of the plenty of plug-ins.

Still stuck? Send us a chat message and we'd be happy to talk about your reporting needs.


Since always proper reports have been a regular source of confusion among sales and marketing reps for as long as the customer relationship management software has been in praxis. Many teams who use the software to track their sales opportunities and activities have ranted about the numerous difficulties in producing reports from their Salesforce sales and marketing data. Let us introduce you the most popular Salesforce reporting apps.

7-popular-reporting-apps-for-salesforce

7 Popular Reporting Apps for Salesforce

Salesforce apps, powerful components, development and consulting. Our experienced team helps you to create and modify workflow processes in salesforce.

Conga

Embed Image In Conga Document Using Salesforce ID

7 Popular Reporting Apps for Salesforce

Partners

Company

Get in touch