BR to get price field from one table, and display it in another tables price field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2024 05:09 AM
Hello, i have a price field in lets call it table1. in table2 we want to take the price from table1 and display it on orders the customers do. The customer orders a product from table1 the price of that product displays in the order on table2 on its price field.
So how can i take price table1 and display it in price table2?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2024 05:23 AM
you can simply set value using current object from 1 price field to another
what script did you try and what didn't work?
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-06-2024 05:47 AM - edited 12-06-2024 05:50 AM
What is the field type - is it a string or a choice field?
If a string, then set a script to copy from field 1 on table 1 to field 2 on table 2.
If a choice field, then navigate to the table2 (the table to get the values from table 1), go to the price field's system dictionary, click advanced view field, and select Choice table and Choice field.
Steps:
Locate the field to have the same values, right mouse click on it > Configure Dictionary:
Then scroll to the bottom and click "Advanced view":
It will reload the form and you will see the options to select a table and field:
In this case, the field Infinite team on the sys_user table will have the same choices like the Employee type on sys_user table. It is a dummy example, but you can select any other choice field in any table... and future changing (adding/removing) of the values will be reflected in both fields, thus not needed to maintain to the future.
Is this what you wanted to accomplish or did I get it wrong?
/* If my response wasn’t a total disaster ↙️ ⭐ drop a Kudos or Accept as Solution ✅ ↘️ Cheers! */