+ Start a Discussion
chopairchopair 

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" )

werewolfwerewolf
You can't just use a merge field inline in a formula field like that -- you have to concatenate together a string.  See my post (third post down) in this thread for an example:

http://community.salesforce.com/sforce/board/message?board.id=general_development&message.id=22071#M22071
werewolfwerewolf
So to be clear, you probably want something like:

HYPERLINK("http://twitter.com/"&Twitter_User_Name__c, "Twitter Account" )

The & is the concatenation operator.
chopairchopair
THis worked great, thank you so much.  I have to ask, is there a way using the same formula to have my new custom field display blank unless there is an entry in the Twitter_User_Name__c field?
RickyGRickyG
chopair -

You might want to look at the IF function - methinks this will give you what you want.

Hope this helps.
tbouchertboucher
I have the same need for another application: appending a custom field to a base URL and make it a hyperlink.

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
werewolfwerewolf
You do need 2 fields, but you can set up your layout such that the base field shows only on edit pages by putting it in a section on the layout that is shown only in Edit Mode (this will still pose an issue for inline editing though, fyi).  The formula field will never show itself in edit mode, so you don't have to worry about that.
chopairchopair
Can you share teh IF code you used to hide the field if the input text field is blank?
werewolfwerewolf
IF( Field__c="","",HYPERLINK(<your stuff here>))
chopairchopair
Thanks so much
tbouchertboucher
Thanks for your answer werewolf!

Tim
hil tonhil ton
Nice to see this post here. Hotspot Shield is described as 'software application developed by AnchorFree, Inc. that allows the user to connect to the Internet via VPN. Most of the VPN services or software like hotspotshield have free plans or offers a free trial. Some of the best hotspot shield alternatives that you can use are given here.   https://tg170.com/hotspot-shield-alternatives/
Millar DakkimMillar Dakkim
In such a case, our professionals guide you in the proper direction as per your business nature. If you are looking for a reliable edtech software development firm, I recommend you Edtech Software team https://piogroup.net/edtech-software . With hundreds of resources and thousands of projects delivered, developers use Industry best practices and the latest tools and techniques to deliver projects on time.
Neil CummingsNeil Cummings
Academic Master  is a US based writing company that provides thousands of free essays to the students all over the World. If you want your essay written by a highly professional writers, then you are in a right place. We have hundreds of highly skilled writers working 24/7 to provide quality essay writing services  to the students all over the World.
 
Robert CrookRobert Crook
A merge field is a field you can put in an email template, mail merge template, custom link, or formula to incorporate values from a record. Syntax and Formatting
Mosh HamedaniMosh Hamedani
Information Transformation Services is endowing the clients with a stunning and impressive visual experience crafted by 3D Modeling Services. (https://it-s.com/our-services/2d-3d-modeling/3d-modeling-service/) We are completely forted to offers our customers with a range of appealing 3D designs that are carefully crafted to meet with all type of requirements.
 
Neil CummingsNeil Cummings

Our web scraping Service provides high-quality structured data to improve business outcomes and enable intelligent decision making,Our Web scraping service allows you to scrape data from any websites and transfer web pages into an easy-to-use format such as Excel, CSV, JSON and many others.
 
Emma James 9Emma James 9
You can apply for a $300 payday loan (https://easyqualifymoney.com/how-can-i-get-a-300-dollar-payday-loan-instantly.php) through AmericashPaydayLoans.com. The company offers a network of direct lenders you can use to get a $300 loan when you need cash quickly. 
wdqDE EDWwdqDE EDW
Let's use it safely with Toto Position, a safe playground! TotoPosition is the only one that can reliably select numerous scam sites. We recommend that members use only safe sites by clearly classifying all safety sites, major playgrounds, eat-and-run sites, and safe playgrounds about Toto, and share know-how and information about Toto to maximize profits. We operate with focus on https://totoposition.com/