Transform Map not updating existing Project Task records

[Community Alums]

Hello All,

I have created transform map to update existing Project Task records. A few things I did:

1. Field Map: Didn't work. Always create new Project Task records never update the existing records. Given below script

 if(action == 'insert'){
         ignore = true;
 } 

Its stop creating the new record but didn't update the existing records.

2. Transform script: Didn't work 

        if(target.wbs == source.u_wbs){
            target.assigned_to = source.u_assigned_to;
            target.u_percent_complete = source.u_actual_work_percent_complete;
            target.u_actual_percent_complete_apc = source.u_actual_work_percent_complete;
            target.work_effort = source.u_actual_effort;
            target.u_critical_activity = source.u_critical_activity;    
        }    

It always creates a new records which I don't want. I know when I give below script in OnBefore or in above script it didn't create the record but it will not update the existing record also.

 if(action == 'insert'){
         ignore = true;
 } 

So help me gurus.

Thanks,

MK

[Aman Kumar S]

Hi @MKapoor 

Do you have coalesce as true on any of the field maps?

If no, it will consider all data as new as create new record, so there must be some identification, be it sys__id or number, to ensure it updates the correct existing record, or if match not found, insert a new record

Feel free to mark correct, if your issue has been resolved, so it ends up in solved queue.

Will be helpful for others looking for the similar query.

[Community Alums]

Yes, Aman. I do have WBS and Project fields as coalesce on field map. Still it is not updating the records.

[Aman Kumar S]

Can you share screenshot of list layout of field maps?

[Community Alums]

Just did it a few mins ago.