Salesforce Connector - Using "Assigned To" field for automated alert
I have an "Assigned To" column mapping both ways from SS to SF for a services team project estimation process. In Smartsheet, the "Assigned To" field has the employee name and email and automated alerts are sent when someone is assigned.
However, when the data pushes from Salesforce to Smartsheet, the "Assigned To" name loses the email value since Salesforce only pushes over the text. Is there a different Salesforce field type that would accommodate this?
If not, I see the following options:
- Add a new column for Assigned To Email (and re-setup alerts based on that).
- Update the mapping so that Assigned To pushes from Smartsheet to Salesforce only (though the client doesn't want this option based on their process needs).
- After the new record is created from Salesforce, update the Assigned To field in Smartsheet to the user name with email version (my only worry is that the updated field in Smartsheet may be overwritten later from the Salesforce data format in the future).