Skip to main content
Conga Support

Convert a Conga Composer Button to a Formula Field Using the Conga Formula Builder

Unlike a Conga Composer 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 host those instructions. Use the Conga Formula Builder to convert a working Conga Composer button or link into a Salesforce formula field used by Conga Trigger.

If you prefer to build your formula field manually, please see How to Manually Convert a Conga Composer Button into a Conga Trigger Formula Field.

To convert a Conga Composer button to a formula field using the Conga Formula Builder:

  1. Click the Formula Builder tab to launch the Conga Formula Builder. 

  2. Choose the Master Object from the drop-down menu.

    The Master Object is the object where your Conga Composer button or link is located. 

  1. Select your desired Output Mode.

    This adds a corresponding QMode parameter to your formula field. 

    Additional parameters may be required based on the Output Mode selected. You may need to modify your Conga Composer button/link to include those required parameters.

    If your Conga Composer button includes a DS7 parameter (to run Composer in background mode), the Output Mode is pre-selected to match the background mode behavior.

    Important Notes about Google Output Modes:

    The Output Modes “Attach the output to Google Drive” and “Convert the output to a Google Doc” require a Google Refresh Token, which is configured from the Conga ComposerSetup tab.

    The merged output files from Google Drive or Google Doc Output Modes are stored in the Google account of the user who creates the Google Refresh Token.

    Conga Composer buttons or links configured to save a copy of the merged output file to Google Drive will include the parameters &SC0=1 and &SC1=Google.  However, if these parameters are maintained in the Conga formula field and “Attach the output to Google Drive” is the Output Mode, Conga will store two copies of each merged output file in Google Drive (one from the &SC0=1 and &SC1=Google parameters, and one from the “Attach the output to Google Drive” Output Mode).  Therefore, if “Attach the output to Google Drive” is your desired Output Mode, you should remove the &SC0=1 and &SC1=Google parameters from your Conga formula field.

  2. In the Button / Link area, in the Name box, select the Conga Composer solution.

    The button or link automatically converts to a formula field and display in the left pane for Formula / URL.

    Only traditional URLs for Conga Composer buttons or links display in the Button / Link Name drop-down. URLFOR functions, JavaScript buttons, etc. are not supported.

  3. (Optional) Clear the Show Converted Formula box to toggle back to the URL view of the button / link. 

  4. In the Formula Field area, rename your button by typing a name in the Name box.

    We recommend “Conga Trigger [Output Mode] [Name of Composer solution],” for example, “Conga TriggerEmail Proposal.” 

  5. Click Create Field

  6. Click Edit Field-Level Security

    Field-level security for your formula field opens in a new browser tab.

  7. Edit as necessary and save changes.

If you do not change your field-level security, your solution will not work (you will receive the error message "Object Reference not set to an instance of an object."  You must edit field-level security even if the person creating the formula field has a Standard Salesforce Administrator profile.

  1. Return to the Formula Builder browser tab.

In Salesforce instances on Enterprise Edition and higher, this formula field is not added to the Master Object’s page layout; rest assured, Conga Trigger functions correctly without the field on the page layout. However, for testing purposes you may want the field displayed on the page layout, at least temporarily.

Salesforce Professional Edition customers must place the formula field on the Master Object’s page layout.

If you put the formula field on a page layout and would like to keep it there, we find it helpful to position it within a new section on the page layout so the section may be collapsed as desired.