Custom field that displays the value of another Field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 12:06 PM - edited ‎10-02-2023 12:15 PM
Is it possible to create a new field on a table that automatically displays the value of an existing field from another table?
For example. I want to create a field on the Demand table that will automatically display the value of a field (u_level_team) from the Stakeholder Register table (dmn_stakeholder_register).
Thanks,
AJ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2023 03:57 AM
Hello @TStark,
Please refer to this link:
https://www.servicenow.com/community/developer-forum/set-a-field-value-of-a-field-same-as-another-fi...
If it is helpful, please mark it as helpful.
Thanks & Regards,
Abbas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2023 07:43 AM
Hi @Abbas_5 . That example is using records/data on the same table, Incident. I'm trying to reference data from different tables Demand and Stakeholder Register.
Thanks,
Anthony
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2023 08:25 AM
Hi @TStark ,
That can be done if there a relationship between two tables, means any link to build the logic.
1. If the link is from REF field, we can dot-walk & get values.
2. If the links is a plain string field, we have to code & get from GlideAjaz from Script include or through display BR
please mark as Accepted solution & helpful if it suffice your requirement
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2023 08:55 AM
Hi @Sohithanjan G. I think that may be a part of the problem. I don't think the Demand and Stakeholder Register tables are linked.
Thanks,
AJ