Skip to main content
Conga Support

Convert a Conga Composer Button to a Conductor 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 Conductor 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 Conductor.

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

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

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

    For Conga Conductor:

  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.

  3. The Master Object is pre-selected if you have entered a Report or Query in Master Object Source on the Conductor record. 

  4. 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. For more information, see Determine How Conga Conductor Will Deliver the Merged Output Files.

    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 Conductor Setup 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 Conductor formula field and “Attach the output to Google Drive” is the Output Mode, Conga Conductor 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 Conductor formula field.

  5. 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.

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

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

     

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

  8. Click Create Field

    A dialog box confirms creation of the field and asking if you’d like to update the Conga Conductor record:

    Salesforce Professional Edition customers will not be able to use the Create Field button to have Conga Conductor create the formula field automatically (due to API limitations). Instead, copy the contents of the Formula / URL pane and manually create the formula field in Salesforce Setup on your Master Object. Lastly, enter the API name of this field into the URL Field Name field on the Conductor record (seen below in step 9).

  9. Click No to edit field-level security of the newly-created formula field.

    Or

    Click Yes to update the field without editing field-level security. Then, skip to step 14.

  10. Click Edit Field-Level Security

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

  11. 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.

  2. Click Update Conductor

  3. Click OK to close the confirmation dialog box.

In Salesforce instances on Enterprise Edition and higher, this formula field is not added to the Master Object’s page layout; rest assured, Conga Conductor 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.