ColumnHide in Word
Similar to the TableHide special merge field, you can use ColumnHide to hide individual columns when the value of the filed does not match the specified criteria. Include one of the below examples in the header column you wish to conditionally remove. ColumnHide can be used in conjunction with data from Master Datasets and with multiple datasets from Reports/Queries.
This feature must be used in conjunction with the platformcomposer=1 parameter in your Composer button solution. See PlatformComposer for more details.
ColumnHide via Value on a Master Field
| Syntax | {{ColumnHide:MasterField:Value}} |
| Values | MasterField is the name of the merge field you want to evaluate (e.g. Contact_IsPrivate), as it appears in the Template Builder. Value is the value of the field that will force Composer to hide the column. |
| Notes | Master fields are generated from the Master data set of the Template Builder. |
| Name{{ColumnHide:Contact_IsPrivate:true}} | Product |
|---|---|
| {{FirstName}} | {{Product_Name}} |
ColumnHide via TableData Field Values
| Syntax | {{ColumnHide:DATASET:FIELDNAME:VALUE}} |
| Values | DataSet is the name of the Report/Query data as seen in the Template Builder. FieldName is the name of the merge field you want to evaluate (e.g. Oppty_IsPrivate), as it appears in the Template Builder. Value is the value of the field that will force Composer to hide the column. |
| Notes | When using the merge region tags, TableStart/TableEnd, along with ColumnHide, you can hide multiple columns on same table, as long as at least 2 columns remain in the table to maintain the enclosed merge region syntax. |
Name{{ColumnHide:Opptys: Opportunity_IsPrivate:true}} | Close Date{{ColumnHide:Contacts}} | Amount |
|---|---|---|
| {{TableStart:Opptys}}{{Opportunity_Name}} | {{Opportunity_CloseDate \@ MM/dd/yyyy}} | {{Opportunity_Amount \# Currency}}{{TableEnd:Opptys}} |
| TOTAL: | {{=SUM(Above)}} |
ColumnHide via Operational Values
| Syntax | {{ColumnHide:MASTERFIELDNAME:OPERATOR:VALUE}}, {{ColumnHide:DATASET:FIELDNAME:OPERATOR:VALUE}} |
| Values | DataSet is the name of the Report/Query data as seen in the Template Builder. FieldName is the name of the merge field you want to evaluate, as it appears in the Template Builder. Operator is the appropriate operator symbol for your equation (<, >, <>, =, !=). Value is the value of the field that will force Composer to hide the column. |
| Notes | When using the merge region tags, TableStart/TableEnd, along with ColumnHide, you can hide multiple columns on same table, as long as at least 2 columns remain in the table to maintain the enclosed merge region syntax. |
| Case Subject | Status {{ColumnHide:Cases:Case_Status:!=:New}} | Opened Date |
|---|---|---|
| {{TableStart:Cases}}{{Case_Subject}} | {{Case_Status}} | {{Case_CreatedDate \@ MM/dd/yyyy}}{{TableEnd:Cases}} |