I need to create a field called "planning" on the account which should have value or text "click here" and it will point to Google doc if someone clicks that.
Right now it's as URL but it shows as long Google Doc URL in the report for which we have to scroll the report.
답변 7개
Hi Archana,
If you create a text formula field with the formula below
HYPERLINK( DOC_URL__c , "Click Here","_blank")
Insert the name of your URL field in place of "DOC_URL__c and it will display a clickable link named "Click Here" to the document in your URL field, as you need.
Let me know how you get on?
Best,
Matt