Convert a Button into a Formula Field

Unlike a CQG button or link which contains a URL with various parameters to define your merge operation, Conga Trigger uses a formula field on your Master Object to trigger the workflow.

Important:

Conga Trigger can only merge data from the Quote object with CQG.
Based on your business use case, you must assign field-level access of the formula filed to the users using profiles or permission sets. For more information, see Salesforce Field-Level Security.
You must add &srcpkg parameter within the Trigger formula field to work Conga Trigger solutions with CQG.

To convert a button into a formula field

Create a custom formula field on your Master Object with Return Type of Text and label it.

Tip:
It is helpful to include the type of delivery method (ex: download, email, etc.), the template, and the master object in the Label such as, “Conga Trigger Download Simple Quotation”

Copy the button URL from your working button and paste it into your formula field’s formula window. Example:

/apex/csfb__Conga_Composer?SolMgr=1
&serverUrl={!API.Partner_Server_URL_370}
&userName={!$User.Username}
&Id={!blng__Quote__c.Id}
&TemplateId=a0I80000000laT3
&FP0=1
&AC0=1
&AC1=Quotation+for+{!Opportunity.Name}

Remove the following unnecessary lines:

/apex/csfb__Conga_Composer?SolMgr=1&serverUrl={!API.Partner_Server_URL_370}&userName={!$User.Username}

You should be left with just the &Id parameter and what follows it. For example:

&Id={!blng__Invoice__c.Id}
&TemplateId=a0I80000000laT3
&FP0=1
&AC0=1
&AC1=Quotation+for+{!Opportunity.Name}

Convert the remaining lines into a valid Salesforce formula. The formula must adhere to the following rules:
1. Literal text strings (a.k.a. static text) must be enclosed in quotes (" … ")
2. Literal spaces within literal text strings must be replaced with plus signs (+)
3. Merge fields from the button must be replaced with the corresponding field available in the formula. For example, {!Opportunity.Id} would be replaced with Id
4. Each element (literal text strings and fields) must be joined with the concatenation operator (+) or (&).
Example:
```
"&id="+ Id +"&TemplateId=a0I80000000laT3" +"&FP0=1" +"&AC0=1" +"&AC1=Quotation+for+" + Name +
```
Append the QMode parameter to indicate how Conga Trigger should deliver the merged output files.
Example:
```
 + "&QMode=Download"
```
Append the &srcpkg=cfg parameter to work Conga Trigger solution with CQG.
Example:
```
+ "&srcpkg=cfg"
```

Button URL	Formula
/apex/csfb__Conga_Composer?SolMgr=1 &serverUrl={!API.Partner_Server_URL_370} &userName={!$User.Username} &Id={!blng__Quote__c.Id} &TemplateId=a0I80000000laT3 &FP0=1 &AC0=1 &AC1=Quotation+for+{!Opportunity.Name}	"&id=" + Id + "&TemplateId=a0I80000000laT3" + "&FP0=1" + "&AC0=1" + "&AC1=Quotation+for+" + Name + "&QMode=Download" "&srcpkg=cfg"

Button URL

Formula

/apex/csfb__Conga_Composer?SolMgr=1
&serverUrl={!API.Partner_Server_URL_370}
&userName={!$User.Username}
&Id={!blng__Quote__c.Id}
&TemplateId=a0I80000000laT3
&FP0=1
&AC0=1
&AC1=Quotation+for+{!Opportunity.Name}

              "&id=" + Id + 
"&TemplateId=a0I80000000laT3" + 
"&FP0=1" + 
"&AC0=1" + 
"&AC1=Quotation+for+" + Name + 
"&QMode=Download"
              "&srcpkg=cfg"

Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

Convert a Button into a Formula Field

To convert a button into a formula field

Footer Section

Explore