To populate the Close Notes field during a Transform Map import, you can use a Transform Script since it may not be directly available in the Mapping Assist. Open your Transform Map, navigate to the Transform Scripts section, and add an onBefore script. In this script, map the Close Notes field manually by using the field name from your Excel file. For example, you can write a script like
if (source.u_close_notes) {
target.close_notes = source.u_close_notes;
}
, where u_close_notes is the column name in your Excel file, and close_notes is the field in the target table. Save the script, test the Transform Map, and verify that the Close Notes field is populated correctly during the import.
