Work notes are not populated on the Form while transforming data

Ashwini Jadhao · ‎12-09-2019

Hi,

I am importing data from london to madrid by transform map.All the data is imported properly except Work notes.

Issue is on the tables list view I can able to see work notes data but when I open the record then the work notes field is empty.

Harsh Vardhan · ‎12-09-2019

try it by onBefore transform script.

eg:

var gr= new GlideRecord('your target table');

gr.addQuery('number',source.<field name>); // here you will add filter so you can identify the record

gr.query();

if(gr.next()){

gr.work_notes= source.<work note field >;

gr.update();

}

Harsh Vardhan · ‎12-09-2019

kindly refer the doc link for further details.

Ashwini Jadhao · ‎12-09-2019

thank you but in LONDON PROD instance all entries on work notes are visible on the Activity field.

Harsh Vardhan · ‎12-09-2019

journal field entry will be visible on activity formatter .

just confirming in your scenario it is not visible even on activity formatter ?

Ashwini Jadhao · ‎12-09-2019

no it is not visible on activity formatter

Harsh Vardhan · ‎12-09-2019

seems like in transform map you have to update the record then it will be visible.

how are you setting the value in work notes field ? by using script or direct field mapping ?