FREE ELECTRONIC LIBRARY - Thesis, dissertations, books

Pages:   || 2 |

«Conga Composer Microsoft Excel Templates Conga Composer 7 - Winter ‘13 Release Welcome Conga Composer lets you generate documents and spreadsheets ...»

-- [ Page 1 ] --

Conga, Inc.


Conga Composer

Microsoft Excel Templates

Conga Composer 7 - Winter ‘13 Release


Conga Composer lets you generate documents and spreadsheets by gathering data from

Salesforce and merging to a template. The resulting file(s) can be printed or emailed and you

can log the actions you’ve taken in Salesforce.

Conga Composer solutions let you create individual documents by clicking a button from a

record in Salesforce.

Contacting Conga Conga is a leading provider of software solutions to enrich your Salesforce experience, specializing in document creation tools that integrate data from Salesforce. Founded in 2006, Conga has since built a substantial market presence with thousands of customers worldwide.

Technical Support At Conga, we are committed to providing you with timely answers to your technical support questions. We provide support to system administrators for our products via email or

telephone. Generally, we’re available weekdays, during the following hours:

North America Support Hours: 8 a.m. – 8 p.m. Eastern Time Tech Support Email: support@congamerge.com Telephone: +1 303-465-1616 or (866) 502-3334 Europe, Middle East, Africa (EMEA) Support Hours: 9 a.m. – 5 p.m. British Time Tech Support Email: support@congamerge.com Telephone: +44 20 3608 0165 Asia / Pacific (APAC) Support Hours: 9 a.m. – 5 p.m. Eastern Time Tech Support Email: support@congamerge.com Telephone: +61 28 417 2399 © 2014 Conga. All Rights Reserved. Conga, Conga Suite and Conga Composer are all trademarks or registered trademarks of Conga, as are other names and marks. All other trademarks or registered trademarks are the properties of their respective owners.


For information on other products from Conga, please contact our New Business team:

Sales Information Email: sales@congamerge.com Telephone: +1 303-465-1616 Resources


For detailed examples, including sample templates, report designs and sample output, please download the Conga Composer Examples file.

Articles and Videos:

Conga provides an online knowledgebase and YouTube channel that are available 24X7 to help you answer questions.


Want to get started right away? Our Quick Start Guides will help you quickly generate your first Conga Composer solutions.

To learn more, go to our Conga QuickStart Library.

Page 2 Table of Contents General Disclaimer

Designing Microsoft Excel Merge Templates

What Merge Fields are Available?

Create Merge Fields

 Creating Excel Merge Fields

 Merging Detail Data

Refine Merge Fields with Parameters

Special Merge Fields

 Today’s Date (Text)

 Today’s Date (Date/Time Value)

 Dynamic Formulas

Microsoft Excel FAQs

 How can I use a merge field within a formula?

 How do I set the Printable Area of the Spreadsheet

 How can I determine which sheets to include in an output PDF?

 What’s the best way to format text paragraphs?

 How can I group data in Excel?

Know Your Limits

–  –  –

General Disclaimer Conga Composer solutions depend on and leverage technology from a multitude of software and hardware vendors including but not limited to salesforce.com, Microsoft, Google, and the providers of various Internet browsers (“Third Party Technology”). Output from Conga Composer solutions can be impacted by these and numerous other factors beyond the control

of Conga, including:

 Template design errors in Microsoft Word, Excel, PowerPoint templates, PDF Forms or Conga HTML email templates  The nature and scope of data and/or images being retrieved for merging into templates  Individual user’s browser, network, ISP and hardware settings  The availability and performance of the salesforce.com service and other software-as-aservice solutions such as e-signature, e-commerce and other AppExchange products, and periodic updates, enhancements or other changes to such services made by their respective vendors  Salesforce.com security settings including User Profiles and Permissions, folder and object access and field-level security  Internet performance, regional and even global outages For these reasons, Conga cannot guarantee that your particular implementation of Third Party and Conga technologies – even if configured based on Conga documentation and/or guidance offered by Conga Support personnel - will perform consistent with your expectations or requirements, or provide the output you require. Accordingly, Conga disclaims any and all liability resulting from, or related to, performance issues associated with Conga products to the extent arising from your implementation, configuration, or the behavior of Third Party Technology.

508 Compliance Conga Composer is an installable package from the Salesforce AppExchange, which integrates with an individual customer's existing implementation of Salesforce. When properly configured, Conga Composer will run within an existing Salesforce instance without the need to view, manipulate or configure the application outside of the Salesforce user interface.

The use of Conga solutions is entirely represented by standard Salesforce user interface components when properly configured. Therefore, customers seeking the 508 Compliance VPAT documentation are referred to Salesforce.

Page 4 Designing Microsoft Excel Merge Templates Conga Composer can merge data into an Excel template. (Excel templates only work with Conga Composer, not Conga Mail Merge.) What exactly is an Excel template? It’s an Excel file (.xls or.xlsx) that contains one or more merge fields. In this chapter we’ll examine how to create and edit Excel fields.

Conga Composer supports Excel templates saved in the Excel 2003 (“.xls”), or Excel 2007/2010 (“.xlsx”) format. However, we recommend the Excel 2003 format (“.xls”) to ensure file format compatibility across a broad audience.

The first step in creating a template is to determine which fields are available, which we’ll explore in the next section.

–  –  –

What Merge Fields are Available?

An essential tool in the development of Conga Composer solutions is the Template Builder.

The Template Builder is located at the lower-left corner of the Conga Composer page.

Tip! You’ll use the Template Builder frequently in the upcoming sections.

The Template Builder exposes the data retrieved by Conga Composer from the Master Object, and from any Salesforce Reports or Conga Queries referenced in the Conga Composer URL. (The use of Salesforce Reports and Conga Queries is described later in this chapter.) Select the desired dataset to view the available merge field names. The field names listed in the left column indicate the field names you must use in your templates. Filter the list of fields by entering search criteria in the Live Search box. You may search the field names or the sample data (drawn from the first row of data available).

Click the field name to copy it to the clipboard, then switch to your template (in Word, Excel, PowerPoint or a PDF Form) and paste the field name into the appropriate location (see the template-specific guides for information on how to create a merge field).

See the next page for several tips on how to best use the Template Builder.

Page 6 Tip! If an Opportunity is your Master Object, Conga Composer will automatically make the Opportunity Line Items available for merging in the OppLineItems dataset.

Tip! If a Quote is your Master Object, Conga Composer will automatically make the Quote Line Items available for merging in the QuoteLineItems dataset.

–  –  –

Create Merge Fields With the Template Builder window close at hand, you’re ready to begin creating merge fields.

What exactly is an Excel merge field? It’s an Excel formula that begins with &= followed by the View Data workbook sheet name, a period and then the field name. The format looks like: &=DatasetName.FieldName  Creating Excel Merge Fields

1. In Excel, create or open a workbook to use as your template

–  –  –

3. Switch to the Excel template and move to the location where you’d like the merge field

4. Create the field by

following this convention:


–  –  –

Page 8


Say we want to merge several fields from a Contact record, including the LastName field, into Excel. Assuming the Contact is the Master Object, the LastName field would appear on the Master sheet. The formula for this field would be &=Master.LastName.

The Contact also has a field called CONTACT_MAILINGCITY. The Excel merge field formula would be &=Master.CONTACT_MAILINGCITY.

Say we also have a field name on the ReportData dataset entitled LastActivityDate. The corresponding Excel merge field would be &=ReportData.LastActivityDate.

Finally, let’s say we also want to include the current user’s first name, which is visible on the User dataset on the Template Builder window as USER_FIRSTNAME. The corresponding Excel merge field would be &=User.USER_FIRSTNAME.

In each instance, notice that the sheet names (Master, ReportData and User) are case-sensitive.

Warning! Merge field formulas must stand-alone in a cell and cannot be used as part of a more complex formula. To use a merge field in a formula, put the merge field in a non-printing region (or a different sheet) and then refer to that cell in the formula.

–  –  –

 Merging Detail Data Conga Composer has the unique ability to use data from a Salesforce Report as detail data.

Since you can retrieve multiple rows of data for each master object (e.g., invoice line items for each invoice), your Excel template needs to dynamically expand to accommodate an unlimited number of detail rows.

Fortunately, Conga Composer will automatically expand your template by adding rows (or columns if merging horizontally), for detail data.

Consider this data from a Template Builder window.

Here, we have several Contacts related to an Account in the ReportData


In our Excel template, say we lay out the merge fields like


When Conga Composer merges with this template, it will automatically insert rows to accommodate the number of rows on the ReportData sheet. The first Contact’s data will be inserted into cell B3, then a new row will be inserted into the sheet and the second Contact’s data will be inserted in B4, and so on.

The final output would look

like this:

–  –  –

Page 10 Refine Merge Fields with Parameters You can tune Conga Composer’s behavior when merging to Excel with field parameters. Each of the following parameters may be appended to the end of a merge field within parentheses, separating each with a comma.

–  –  –

Page 12

Example 1:

Say we want to merge Opportunity Line Items on an Excel template. To merge them

vertically (the typical method), your template would look like this:

Assuming we have three items from the OppLineItems sheet, the output would look like this:

–  –  –

To write data left-to-write, include the Horizontal parameter. In this example, the Product Names from an opportunity are written left-to-right.


The output after adding the Horizontal parameter would look like:

–  –  –

Extending the previous example, say we want Opportunity Line Items (and Sales Price) to appear from left-to-right across a page. We’ve also included headers each product column (Product 1, Product 2 and Product 3). To prevent Conga Composer from inserting new

columns, we’ve added the Noadd parameter:


The output from this horizontal merge would look like:

–  –  –

The Skip:n parameter can be helpful when you want to insert alternating data on every other row (from fields containing multiple values).

In this example, we’d like to have an Opportunity Line Item Product appear, then the Sales Price below the product, followed by another product and price, and so on.

Usually, the Noadd parameter accompanies the Skip:n parameter.

The output from this template would look like:

Page 14 Special Merge Fields Conga Composer offers several additional merge fields for even more flexibility in your merge templates.

 Today’s Date (Text) By creating a merge field with the name &=Date.Today, Conga Composer will insert the current date as a text string. Although this field is easy to use, you won’t be able to apply a date-format to this value because it’s text.

 Today’s Date (Date/Time Value) By creating a merge field with the name &=Date.TodayDT, Conga Composer will insert the current date as a date/time value. The benefit of this field is that you can format the resulting date with any of Excel’s date-formatting options.

 Dynamic Formulas Dynamic Formulas allow you to insert Excel's formulas into cells even when the formula must reference rows that will be inserted later during the merge process. They can repeat for each inserted row or use only the cell where the field is placed.

Dynamic Formulas begin with &== and are followed by an Excel formula.

Repeating Dynamic Formulas begin with &=&= and are followed by an Excel formula.

You may use any of Excel’s functions in a Dynamic Formula.

–  –  –

Pages:   || 2 |

Similar works:

«Thermoformable Composite Panels From automotive to aerospace, thermoformed composites are growing exponentially, offering short cycle times, tailored properties, recyclability and lower cost. Thermoformable composite panels are thermoplastic materials—e.g. polypropylene (PP), nylon 6, polyetherimide (PEI), polyphenylenesulphide (PPS)—reinforced with some type of fiber, and then supplied to customers as solid sheets, which are then thermoformed into shaped structures. Although many of these...»

«Marshall University Complimentary Tickets Compliance Office for Athletics Athletic Department Staff Home Athletics Events Regular season: Selected employees of the Athletic Department are permitted complimentary tickets for home athletic events. This list is determined and subject to review by the Director of Athletics. For football, men’s basketball, and women’s basketball these tickets are issued in season ticket form. Tickets must be picked up and signed for by the recipient at the...»

«Devising a Government Complaint System Guide to Good Practice Table of Contents Introduction  Acknowledgements  Why Have a Complaint System?  Why People Complain  Aims of an Effective Complaint System  Principles of a Good Complaint System  Elements of a Complaint System  Planning and Start-up Considerations  Publicizing the Complaint System  Complaints as Opportunities to Improve  References  Introduction For many years the Alaska Office of the Ombudsman has...»

«COMPOSERS AND MENTAL ILLNESS David C F Wright, PhD This is article is designed to consider how mental illness may affect a composer's work, Does their life style affect their music? I have taken as a starting point the composer Scriabin with particular reference to his controversial Piano Concerto. This article, in itself will be considered controversial and deals with matters already expressed elsewhere, but introducing the subject of composers with mental illness. This concerto is...»

«Re: Communication submitted under Article 55 of the African Charter on Human and Peoples’ Rights Complainant: Open Society Justice Initiative State Party: Côte d’Ivoire I. INTRODUCTION The Open Society Justice Initiative hereby submits this communication under Article 55 of the African Charter on Human and People’s Rights against Côte d’Ivoire, a state party to the Charter, and its agents on behalf of Ivorians who have suffered unlawful discrimination by agents of the state of Côte...»

«Compose together in your band, simple rock with guitar-based chord progression. page 1 Compose together in your band, simple rock with guitar-based chord progression. The concept I am describing here on is based on the first grip I learned on the guitar as a 13 year old, an E-flat major. In the concept the chords E, G, A, B, C, D, are used, all played with root on the low E-string. In addition, E-minor blues scale are used, and the sounds that occur when you mix this with the six chords. For...»

«1 ‘A Dark Age Devoted to Barbaric Affluence’ Oakeshott’s Verdict on the Modern World. A paper by Ivo Mosley for the Michael Oakeshott Association Conference, Colorado Springs, 2006. Introduction. ‘The beginning of a dark age devoted to barbaric affluence’: Oakeshott’s assertion of where civilization was heading in 1972 struck some as unduly pessimistic. Now, thirty-four years later, his diagnosis seems (to many) less like a gloomy prediction, more like a well-put observation. I was...»

«Commissioning Music: A Basic Guide COMMISSIONING MUSIC To commission music is to pay a composer to write a particular composition for a specific purpose or event. Anyone can commission music, and any type of music can be commissioned. Choose a composer whose music moves you and who can write for the occasion and the instrumentation you have in mind. Contact candidate composers or their publisher to request samples of their music. Base the commission fee on the composer’s reputation, length of...»

«COLLECTION DEVELOPMENT PLAN PITT COMMUNITY COLLEGE LIBRARY (latest review: October 2013) 1. INTRODUCTION 1.1. Purpose and Aim The purpose of the Collection Development Plan (“the Plan”) is to provide  criteria and guidelines for the selection of library materials and the ongoing assessment and maintenance of the collection.  procedures for interaction between the collection and its users. The aim of the Plan is to provide a working tool to  expedite the collecting of material or...»

«Summary of Pesticide Use Report Data Indexed by Commodity California Department of Pesticide Regulation P.O. Box 4015 Sacramento, CA 95812-4015 California Environmental Protection Agency Department of Pesticide Regulation Arnold Schwarzenegger, Governor Alan Lloyd, Secretary California Environmental Protection Agency Mary-Ann Warmerdam, Director Department of Pesticide Regulation January 2006 Any portion of this report may be reproduced for any but profit-making purposes. For information on...»

«CHURCH AND TABLE -A PARTICIPATORY ECCLESIOLOGY FOR THE CONTEMPORARY CHURCH by Nicholas Andrew Coates A thesis submitted to the Faculty of Emmanuel College and the Theology Department of the Toronto School of Theology. In fulfilment of the requirements for the degree of Master of Arts in Theology awarded by St Michael’s College and the University of Toronto. © Copyright Nicholas Andrew Coates 2012 Church and Table A Participatory Ecclesiology for the Contemporary Church Nicholas Andrew...»

«Copyright 2001 The New York Times Company The New York Times January 14, 2001, Sunday, Late Edition Final SECTION: Section 6; Page 34; Column 3; Magazine Desk LENGTH: 3878 words HEADLINE: The Bush Years; Confessions of a Lonely Atheist By Natalie Angier In the beginning or rather, at the end of a very lo-o-ng beginning George W. Bush made an earnest acceptance speech and urged our nation to rise above a house divided. He knows, he said, that America wants reconciliation and unity, and that we...»

<<  HOME   |    CONTACTS
2016 www.dis.xlibx.info - Thesis, dissertations, books

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.