The CreatorCon Call for Content is officially open! Get started here.

Setting work notes via Transform Map not working

CBlan2021
Tera Contributor

I have a transform map that transforms from a loaded CSV onto a table which has the Work Notes (journal input) and Activities sections. It works normally for regular fields, but it doesn't work with the work notes. It's supposed to take a string from the CSV and place it in as a work note. When I try to do so with a regular transform mapping, CSV column "work notes" to the table's Work Notes (u_work_notes), the notes show up when I look at work notes in the list view, but not when I actually open the form and look at the Activities. I also have tried setting via onAfter script with a few different ways like

target.comments.setJournalEntry('Testing');

and

target.setValue('u_work_notes','Testing');

but neither of these have worked. I've also made sure audit was enabled on this field as well as on the collection record for the table, and I've tried using target.update() as well as target.setWorkflow(true); as well but no luck there either. What am I missing here? Why would the work note set by the mapping show up in the list view but not in the record's activites?

1 ACCEPTED SOLUTION

I got it You have to enable Business Rules on your transform map

Please mark answer correct/helpful based on impact

View solution in original post

7 REPLIES 7

Saurav11
Kilo Patron
Kilo Patron

Hello

Are yuou sure you are mallimg yo the corredct Oob worknotes?

The fiel is called work_notes it looks like yu are using some custom field u_work_notes

Map it with work_notes

Please mark answer correct/helpful based on impact

Hello, yes, u_work_notes is correct, please see below:

find_real_file.png

Can you send me a screenshot of the field on list view ? Form view ? And the field map for wornote on transform map

Yes, this is what is shown on list view from all the tests I've run while troubleshooting:

find_real_file.png

This is the form view, including a message I posted manually from the work notes:

find_real_file.png

 

 

This is the mapping:

find_real_file.png

And this is the field from the loading table where it should be taking from:

find_real_file.png