Insert a field from another table to another table

[Vengeful]

Is it possible to add a column field from another table to another table? I mean different table.

Like this dictionary entry from Change Task [change_task table], I want to add it to Change Request [change_request].

How can I add it to Change Request [change_request] table?

[AshishKM · Accepted solution]

Hi @Vengeful, 

Yes you can add a column from Table1 to Table2.

Just declare the table as Table1 in definition of Table2.

For Example : You can open Incident Table and check there few some columns belongs to Task table.  

-Thanks,

AshishKM

[Sujit Jadhav · Accepted solution]

Hello @Vengeful ,

To insert a field from one table into another table in ServiceNow, you typically need to establish a relationship between the two tables. One common way to achieve this is by creating a reference field that references records in another table. Here's a step-by-step guide:

1.Identify Source and Target Tables:
Determine which field from the source table you want to insert into the target table.

2.Create a Reference Field:
Navigate to "System Definition" > "Tables" in ServiceNow.
Open the target table where you want to insert the field.
Create a new reference field. For example, if you want to insert the 'Location' field from the 'Location' table into the 'Incident' table, you would create a reference field named 'Location' in the 'Incident' table.
Configure the reference field to reference the source table (e.g., 'Location' table).

3.Configure Field Mapping:
Once the reference field is created, you may need to configure field mapping to specify which field from the source table should be displayed in the reference field.
For example, if you want the 'Location' field from the 'Location' table to be displayed in the 'Location' reference field in the 'Incident' table, you would map the 'Location' field in the 'Incident' table to the 'Location' field in the 'Location' table.

4.Test and Verify:
Test the configuration by creating or editing records in the target table.
Verify that the reference field displays the appropriate values from the source table.

By following these steps, you can insert a field from one table into another table in ServiceNow by establishing a reference relationship between the two tables. This allows you to access and display information from the source table within the target table.

Please mark my answer Correct/Helpful, If applicable

Regards,

Sujit

[AshishKM · Accepted solution]

Hi @Vengeful, 

Yes you can add a column from Table1 to Table2.

Just declare the table as Table1 in definition of Table2.

For Example : You can open Incident Table and check there few some columns belongs to Task table.  

-Thanks,

AshishKM

[Vengeful]

Hi @AshishKM 

Sorry, how to declare the table as Table1 in definition of Table2?

[Sujit Jadhav · Accepted solution]

Hello @Vengeful ,

To insert a field from one table into another table in ServiceNow, you typically need to establish a relationship between the two tables. One common way to achieve this is by creating a reference field that references records in another table. Here's a step-by-step guide:

1.Identify Source and Target Tables:
Determine which field from the source table you want to insert into the target table.

2.Create a Reference Field:
Navigate to "System Definition" > "Tables" in ServiceNow.
Open the target table where you want to insert the field.
Create a new reference field. For example, if you want to insert the 'Location' field from the 'Location' table into the 'Incident' table, you would create a reference field named 'Location' in the 'Incident' table.
Configure the reference field to reference the source table (e.g., 'Location' table).

3.Configure Field Mapping:
Once the reference field is created, you may need to configure field mapping to specify which field from the source table should be displayed in the reference field.
For example, if you want the 'Location' field from the 'Location' table to be displayed in the 'Location' reference field in the 'Incident' table, you would map the 'Location' field in the 'Incident' table to the 'Location' field in the 'Location' table.

4.Test and Verify:
Test the configuration by creating or editing records in the target table.
Verify that the reference field displays the appropriate values from the source table.

By following these steps, you can insert a field from one table into another table in ServiceNow by establishing a reference relationship between the two tables. This allows you to access and display information from the source table within the target table.

Please mark my answer Correct/Helpful, If applicable

Regards,

Sujit

[Vengeful]

Hi @Sujit Jadhav 
If you are referring to this: 

There's no specific table for the Column label 'Developer' since it's a dictionary entry to the change_task table.