Skip to main content
Topics#FormulasElliot Wilson's Question
Elliot Wilson asked in #Formulas
Jan 31, 2018, 10:57 AM

Can't get Formula field Text with HYPERLINK to link to a custom field.

Hi,

I'm trying to create a formula field as Text using HYPERLINK to grab the relative Salesforce URL & object & record ID and then append the name of the custom text field I have created, called Anchor1__c. The idea is that I drop these blank custom anchor fields at the top of page sections, then a user could click this link at the top of a record page and quickly jump to the relavant section.

In theory, this "should" work but I've not been able to get the link to do what I want. Is this even possible o ris there a better way?

I should mention that I am very new to writing formulas, and this was based on some other posts I had read. It doesn't work.

HYPERLINK("/ ID" + anchor1__c, "Go to section 1", '_self')

Many thanks,

Elliot.

 
1 answer
  1. Deepak R (Consultant)
    Feb 5, 2018, 9:33 AM
    Hi Elliot,

    I am trying to think what you are trying to achieve here.

    1. On a standard edit page which has multiple sections

    2. You have placed fields on the each sections which you are going to pass in the edit URL

    3. Which would be scrolling to the respective sections

    Let me know if this is what you are trying to get to.

    RD

     
Write an answer...
0/9000