onBefore Transform Script

[Community Alums]

I am trying to import an excel sheet where the group name is a column. This transform script must populate the group's manager name/email/phone in the target records. I see the values in the log but the target record is not updating.. any help is appreciated.

[SanjivMeher · Accepted solution]

If you are populating those fields using script, you should remove them from the field maps.

[Community Alums]

Thank you. That helped.

[siva_]

Hello , 

if you have a group name as a column , you can just use that in the field maps to populate your group field and on the form where the group field is present you can just dot walk the remaining fields on the form layout and can use the derived fields on the form instead of creating new fields . That actually helps in reducing the amount of processing.

You can also keep seperate fields as now and can populate the remaining fields with the script that you are using provided you can use only group in your field map, But i prefer the first option as stated above. 

Thanks,

Siva

Mark this answer as helpful/correct if that really helps.

[Community Alums]

Thank you.