Configure mapped columns to append or add fields from related tables

Configure dynamic tables in a contract template to display additional data from related table fields by appending it to existing columns or adding it as new columns.

About this task

As a contract configurator, you can add scripts for configuring the mapped table columns in a contract template to include additional fields from related tables. You can choose to either append this information to an existing column or add it as a new column.

Before you begin

• Map tables in Microsoft Word document using the Microsoft Word add-in for ServiceNow Contracts. For more information, see Map contract tables using the Microsoft Word add-in for ServiceNow Contracts.
• Upload and parse the document with the content controls. For more information, see Complete mapping and upload Microsoft Word document that includes content controls.
• Role required: sn_cm_core.contract_config

Procedure

1. Navigate to All > Contracts Core > Contract Administration > Contract Templates.
2. From the list, open the contract template for which you want to add table mapping conditions.
3. In the Table Mappings related list, select a mapping.
4. In the Column Mapping related list, select a column.
5. In the Column Mapping form, select the Advanced script check box.
   The Script field appears.

   Figure 1. Advanced script for column mapping

   

6. In the Script field, add the script to include additional fields from related tables.
7. Select Update.
8. In the Table Mapping form, select Update.

Result

The additional fields will be appended to a column or added as a new column in the contract document that is generated using this template.