Text Mode - Friendly URL displaying when URL hasn't been calculated yet | Community
Skip to main content
Level 4
June 30, 2021
Solved

Text Mode - Friendly URL displaying when URL hasn't been calculated yet

  • June 30, 2021
  • 1 reply
  • 857 views

I am working to make a "Friendly URL" to a Program level Project Brief. I'm building the URL with a calculated field on the Project Brief custom form in the first place, that way I can get the URL to appear on the report when there IS a a Project Brief, and not appear when there isn't.

The problem is that my snippet below is showing plain Project Brief text when there isn't a Project Brief custom form. So something with my valueexpression is wrong, I just don't know what.

displayname=Links

link.url=DE:program:Project Brief URL

linkedname=program

namekey=view.relatedcolumn

namekeyargkey.0=program

namekeyargkey.1=Project Brief URL

querysort=DE:program:Project Brief URL

shortview=false

textmode=true

valueexpression=IF(ISBLANK({DE:program:Project Brief URL}),"","Click Here")

valuefield=program:Project Brief URL

valueformat=HTML

I'd like the yellow ones to just be blank because there isn't a URL (the column to the right is blank). The actually hyperlinked Project Brief is doing the right thing, because there is a URL.

Any ideas?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

Try replacing value expression with...

valueexpression=IF(ISBLANK({program}.{DE:Project Brief URL}),"","Click Here")

1 reply

imgrund
Adobe Employee
imgrundAdobe EmployeeAccepted solution
Adobe Employee
June 30, 2021

Try replacing value expression with...

valueexpression=IF(ISBLANK({program}.{DE:Project Brief URL}),"","Click Here")

Level 4
June 30, 2021

Ahhh, I knew it'd be something silly. Thanks, I appreciate your help!!