Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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")