Expand my Community achievements bar.

SOLVED

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

Avatar

Level 3

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.

0694X00000ELiz5QAD.png

Any ideas?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Try replacing value expression with...

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Try replacing value expression with...

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

Avatar

Level 3

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