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).
@Ben G - Your answer in this post recommends a separate Smartsheet field for assignee email. Do you have any other insight or thoughts on my question? Thank you!
Best Answer
-
Option 4: Keep the current column as the contact, and then create a new column that brings in the name from Salesforce. Then you would create a formula to update the contact in the current column based on what the salesforce-connected column populates. That way, you do not have to update your alerts, and hopefully you only need to update one connector.
Answers
-
Option 4: Keep the current column as the contact, and then create a new column that brings in the name from Salesforce. Then you would create a formula to update the contact in the current column based on what the salesforce-connected column populates. That way, you do not have to update your alerts, and hopefully you only need to update one connector.
-
Thank you! Great idea @Streamline Technology 😀
-
@Amanda G Lima I would love to connect with you by phone to discuss the process you ended up using. I have a similar challenge but I am not following which option that seems to have worked for you. Please reach out to me at trose@unifocus.com and we can align on how to connect. Thanks for your help!
-
@Streamline Technology I would love to connect with you by phone to discuss the process you recommended to Amanda. I have a similar challenge but I am not following which option that seems to have worked for her. Please reach out to me at trose@unifocus.com and we can align on how to connect. Thanks for your help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives