+ Start a Discussion
SFDC palaceSFDC palace 

Custom Formula Field - New Merge Field

Hi
 
Any of clever people know how to create a formula field that will look up the Owners Telephone number from the user record.
 
The $User Merge fields, only put the current users phone number not the owner, is there any way to create a formula to do this?
 
The reason for this is we use Exact Target Email tool, and they ahve recently upgraded and now you can only include contact or Lead fields on your email templates.   It would be nice to have the owners phone number on the emails. 
 
Of course I could create and populate a standard custom field, but would prefer it to recalculate when owner changes.
 
Appreciate any suggestions.
 
Regards
 
TCAdminTCAdmin

SFDC Palace,

I know this isn't ideal, especially if you have a high number of employees.  I have attached the formula for formula(text) field that would do what you are looking for.  Besides this I don't know of a way of doing this except through a sControl.

IF(  CONTAINS(OwnerId , "hAqD") , "Phone One",  IF(  CONTAINS(OwnerId , "i0by"), "Phone Two", "Phone Three") )

Chris

Wingsrul91Wingsrul91
I wish there was an easier way of doing this....

:(