Skip to main content
Conga Support

Conditional TableHide Comparing Two Field Values in Word

You can determine whether to hide a table by evaluating the values from two separate fields. 

Conga Composer® can collect the value of the first field and compare it to the value of the second field, based on the operator used. For example, you could specify that a table of back-ordered product is hidden when the value of the first field (amount shipped) is equal to the value of the second field (amount ordered).

When specifying a detail dataset, the conditional TableHide evaluates the first row of data in the specified dataset.

This feature is not supported when using nested SOQL queries.

TableHide (comparing two values)

Syntax

Values

DatasetName is the name of the dataset from the Template Builder window.

FieldName1 is the name of the field you want to evaluate, as it appears in the Template Builder.

Operator specifies if the evaluation should be “equal to,” “not equal to,” ”greater than,” or “less than.” The supported operators are:

= Equals
<> or != Not equal to
> Greater than
< Less than

FIELDVALUE(FieldName2)is the value of the field to be compared to the first field.

Notes

Both Master and detail datasets are supported.

Both fields (FieldName1 and FieldName2) must come from the same dataset; either both from Master or both from the same detail dataset.

Value must be a number or date field.

Date fields should be formatted as numbers in the month/day/year format, such as 12/21/2015.

Format a date field using this date appearance parameter format: \@ MM/dd/yyyy.

Usage

This example hides the table if the Opportunity Amount field is less than the Amount Due field:

{{TableHide:Opptys:OPPORTUNITY_AMOUNT:<:FIELDVALUE(AMOUNT_DUE)}}

This example hides the table if the values for Account Status and Account Type are not the same.

{{TableHide:Master:ACCOUNT_STATUS:<>:FIELDVALUE(ACCOUNT_TYPE)}}