Document scripting method statements

Conga Collaborate Document Scripting allows you to manipulate the formatting of variable data within a document.

This article is maintained for legacy purposes only. All clients should be utilizing the Modern Variables feature, which provides a modern, point-and-click interface for formatting variables. If this feature is not enabled in your account, please contact Conga Global Support.

Conga Collaborate document scripting method statements allow you to format variables in a document.

For an overview of document scripting, reference the Document scripting overview article.

Being able to format your variables is important for the look, feel, and design of your document. Document scripting allows you to, among other things, remove unnecessary decimal places, display links as images, and format currency variables with the proper currency symbols.

The following table summarizes supported method statements, their descriptions, and examples of how to use them. To see more detailed explanations and examples for each, scroll down to it's corresponding detail section.

Document scripting requires entirely lower case variables, even if the variable would normally have capitalized letters. Ex: { { Opportunity_Name } } would be { { opportunity_name } } when used with document scripting.

as_img

Using as_img tells Conga Collaborate to interpret and display the variable value (which must be a publically accessible image URL) as the image itself instead of the URL text. CSS inline style modifiers can also be added to adjust height, width, etc.

as_iframe

Using as_iframe tells Conga Collaborate to pull the content located at the URL into an iframe within the document. For example, you want to display a form within a Conga Collaborate page, so you pull it into the page using as_iframe. CSS inline style modifiers can also be added to adjust height, width, etc.

to_i

When using to_i, a number variable is displayed as an integer instead of a float. All decimal points are removed and the number always rounds down.

number_to_currency

By default, Conga Collaborate displays CRM currency values as floats. Using number_to_currency allows you to format these values using currency symbols. In addition to simply converting a number to a currency format, number_to_currency has several additional attributes. These are described below:

Using an apostrophe as the delimiter

This is a special case because Ruby (the language that document scripting methods are based on) uses apostrophes as part of its own parsing process such that an apostrophe cannot be used without using an escape character. In Ruby, the escape character is a backslash \ . The syntax looks like this:

All number_to_currency attributes can be combined into one statement if desired

to_formatted_date

This method provides several options for formatting date variables. Using a combination of m, d, y, A, and B, you can display the date in numbers or in words.

Using %-m or %-d will only display one digit as appropriate, while using %m or %d will always display two digits