- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-13-2025 03:32 AM
I am uploading the data via transform map, how can i add the value on the close notes according to the excel ,as close filed is not available in the mapping assist.
Any help or suggestion will be helpful.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2025 01:49 AM
If my response helped please mark it correct and close the thread so that it benefits future readers.
The discussion can continue on your question as well.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-13-2025 03:46 AM
Hi @Shivani_singh ,
You can write transform map script like below.
// Check if the field is present in the source data
if (source.u_close_notes) {
// Set the Close Notes field on the target table
target.close_notes = source.u_close_notes;
}
-------------------------------------------------------------------------
If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.
Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay
-------------------------------------------------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2025 01:39 AM
Is there any way that i can upload the comments in work notes from excel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2025 07:10 AM
The community now supports multiple accepted solutions, so you can accept more than one answer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-13-2025 03:47 AM
are you saying close notes?
if it's not present in mapping assist, did you try creating a field map using new button?
you can also use onBefore transform script for this
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
// Add your code here
target.fieldName = source.fieldName; // use correct source and target field names
})(source, map, log, target);
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader