I would like to link two fields. here follows the example:
"Standard Fields/Owner" to "Custom Fields & Relationships --> API NAME --> Usu_rio__c ( email field)" .
how can i do it ?
Thanks all,
André
6 个回答
Ok, so basically you did not load the data in with the record owner assigned and now that the data is in there, you need to relate it to the owner based on the email address.
You are going to have to export the data, via report or data loader, including the Record ID and Email Address. Then also export a list of User IDs and their Email Addresses. Do a VLOOKUP() in Excel matching email addresses and adding the corresponding User ID to the file with Record IDs. Then use the Data Loader to mass update the Record Owner with those User IDs.
