You need to sign in to do that
Don't have an account?
chopair
Custom Hyperlink field and merge field values
I have created a field on the contact record titled Twitter User Name. I am now trying to create a hyperlink formula field that will take the user name entered and add it to the Twitter URL and I can't get it to work. It works great as a custom link but I want to be able to place the URL in the page layout and not in the custom link section. Any suggestions?
I have tried both of these options
HYPERLINK("http://twitter.com/Contact.Twitter_User_Name__c", "Twitter Account" )
HYPERLINK("http://twitter.com/Twitter_User_Name__c", "Twitter Account" )
I have tried both of these options
HYPERLINK("http://twitter.com/Contact.Twitter_User_Name__c", "Twitter Account" )
HYPERLINK("http://twitter.com/Twitter_User_Name__c", "Twitter Account" )
http://community.salesforce.com/sforce/board/message?board.id=general_development&message.id=22071#M22071
HYPERLINK("http://twitter.com/"&Twitter_User_Name__c, "Twitter Account" )
The & is the concatenation operator.
You might want to look at the IF function - methinks this will give you what you want.
Hope this helps.
I added a text custom field to Cases and a formula field that concatenates that text field with the beginning of a URL. (I also added the IF just to make it nicer)
My question is: do we have to have two fields to do that? Would it be possible to have a text field that asks for just the Twitter name in editing mode and display the field as the URL to the Twitter page in reading mode?
I'm asking because I don't like having two lines for basically the same information in reading mode and I couldn't really find a way to do that.
Thanks,
Tim
Tim