Can we hide or remove the Display Text when input a Link in Anaplan?

CommunityMember131816
New Contributor

Can we hide or remove the Display Text when input a Link in Anaplan?

I have a line item "Document Link" and its format is Text (Link), then when I publish it in dashboard user can input URL in it. But when you click to input link you have option to input "Display Text" at the same time. But if it is not blank, it will impact the value of other line items which refer to "Document Link". How can I remove or hide the "Display Text" ?

I have another line item "Document Link Starting" and below is the formula. I want to trim part of the "Document Link" but if the "Display Text" is not blank it will lead wrong value of  "Document Link Starting".

CommunityMember131816_1-1658918719691.png

 

IF LEFT(Document Link, 5) = NAME('#L8 - PR Document Links Starting'.https) THEN MID(Document Link, 9, 40) ELSE MID(Document Link, 8, 40)

The value user input in dashboard, and as result the value of "Document Link Starting" is "ttp://NA". If remove the "test" the correct value is "NA" which is I need.

So I wonder if Anaplan can support user to hide the Display Text.

Thanks for any help in advance!

 

1 ACCEPTED SOLUTION

Accepted Solutions
ankit_cheeni
Super Contributor

Perfect! Can you close this conversation by marking my comment as the solution, thanks!

View solution in original post

4 REPLIES 4
ankit_cheeni
Super Contributor

Hi @CommunityMember131816 

 

You cannot get the Display Text to go away. The best you can do is ask people not to enter anything. 

Or you can try to preprocess the text. Say this is where we start:

ankit_cheeni_0-1658930156761.png

If you look at it as just text, it is formatted as [Display Text]Link. So if we FIND "]", we should be able to trim out the Display text and then use that line further. 

We can do this:

ankit_cheeni_0-1658930598148.png

 

Here is the blueprint:

ankit_cheeni_1-1658930636846.png

 

ryan_kohn
Certified Master Anaplanner

Check out the MAKELINK() function. You can use this function to collect the URL and/or display text in separate line items and then use a formula to generate the final link.

CommunityMember131816
New Contributor

@ankit_cheeni 

I tried your solution and it works well. Thank you!

ankit_cheeni
Super Contributor

Perfect! Can you close this conversation by marking my comment as the solution, thanks!