---
sourceDocument: Australia Strategic Portfolio Management
sourceDocumentLink: https://www.servicenow.com/docs/r/it-business-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Strategic Portfolio Management

ft:clusterId :

    - itbm

bundleId :

    - itbm

workflow :

    - Technology


---

# Manage Related Tables and Scripted Elements forms

# Manage Related Tables and Scripted Elements forms {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Manage the Related Tables and Scripted Elements components that are required to create a Microsoft PowerPoint template.

## Before you begin

Role required: sn_ppt_export.ppt_admin

## Procedure

1. Navigate to AllPowerPoint ManagementPowerPoint Report Types.
2. Select a parent table record, for example, Project report pm_project.

   | Option | Description |
   | To manage Related Tables | You can add a custom remote table or a child from the parent table. 1. In the Related Tables related list, select New. On the Related tables form, fill the fields. For a description of the field values, see [Related Tables form](https://www.servicenow.com/docs/cA_9jyvYniGTbZskWfc_Yg "Use the Related Tables form to define the child tables for the configured parent table. This Related Tables helps in fetching data to export the project status report as Microsoft PowerPoint."). 2. To add a custom remote table: 1. [Create a remote table](https://www.servicenow.com/docs/access?context=create-remote-table&version=australia&pubname=australia-servicenow-platform&ft:locale=en-US). 2. Select the required remote table from list. 3. Select the Enable custom script option. 4. In the Custom script box, write the code to establish a connection between the remote table and main table. {#manage-components-export-ppt__ol_in2_nlb_dxb} 3. To select a child table from the main table: 1. Select a child table from list. 2. Set the Parent relation column to the field that links the child table to the parent table. {#manage-components-export-ppt__ol_hh5_zlb_dxb} 4. Select Submit. {#manage-components-export-ppt__ol_zst_mlb_dxb} The selected table and its relation to the parent table is displayed in the Related tables section. |
   | To manage Scripted Elements | 1. In the Scripted Elements component, select New. 2. On Scripted Elements form, fill the fields. For a description of the field values, see [Scripted Elements form](https://www.servicenow.com/docs/9Odi6jjIsTSDhlb3D81Nmg "Use the Scripted Elements form to define the data script to fetch data for a complex report type such as line chart or bar chart."). 3. Select Submit. {#manage-components-export-ppt__ol_h1f_hlm_t5b} |
   |-|-|

   {#manage-components-export-ppt__choicetable_wws_lkm_t5b}
3. To configure a Script component, specify the script logic to generate dynamic content in the template.  
   Script components allow you to include calculated or dynamically generated content in your PowerPoint template. Use scripts when the built-in Field, Table, or Text component types do not meet your requirements.

   Example: To display a formatted project health status:

       (function() {
                         var gr = new GlideRecord('pm_project');
                         gr.get(current.getValue('sys_id'));
                         var health = gr.getValue('health');
                         if (health == 'green') return 'On Track';
                         else if (health == 'yellow') return 'At Risk';
                         else return 'Off Track';
                         })()

   Note:  
   Verify the available scripting API and context variables with your ServiceNow administrator. Script components execute server-side and have access to the current record context.
4. Select Update.

*[\>]: and then


