I have a field with comma separated values in it basically the values are user names. I have to create a custom field which populates their email address. How is that possible?
We have to do with Apex, out of the box solution might not be helpful in this scenario. Convert the field (comma separated values) into a List<String> Iterate the derived list<string> to get the email address from the User record. Update the field with the email address
Convert the field (comma separated values) into a List<String>
Iterate the derived list<string> to get the email address from the User record.
Update the field with the email address
String name = 'name1, name2, name3, name4';
List<String> lstName = name.split(',');