Skip to main content
Mikaela-Newell
Level 3
Oct 27, 2026 4:03 AM UTC
Solved

Convert Field Input to Hyperlink (Part 3)

Hi all! I’m back with another hyperlink question.

Any idea why this wouldn’t work in a project report?

displayname=Planner

link.url=program:Planner Link

valueexpression=IF(ISBLANK({program}.{DE:Planner Link}),"","Link"))

valueformat=HTML

The whole column just loads blank.

Thank you in advance!

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
Oct 27, 2026 6:50 AM UTC

Hi, Try this. Your valueexpression had an extra quote/bracket, and link.url should use DE: for the Program custom field:

displayname=Planner

valueexpression=IF(ISBLANK({program}.{DE:Planner Link}),"", "Link")

link.url=DE:program:Planner Link

valueformat=HTML

2 replies

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
Oct 27, 2026 6:50 AM UTC

Hi, Try this. Your valueexpression had an extra quote/bracket, and link.url should use DE: for the Program custom field:

displayname=Planner

valueexpression=IF(ISBLANK({program}.{DE:Planner Link}),"", "Link")

link.url=DE:program:Planner Link

valueformat=HTML

Translate
IvanCyber64
Level 4
Oct 27, 2026 7:42 AM UTC

Hi ​@Mikaela-Newell ,

 

If you want to achieve this you have to add
 

displayname=Planner
link.url=program:DE:Planner Link
valueexpression=IF(ISBLANK({program}.{DE:Planner Link}),"","Link")
valueformat=HTML

Basically the only difference is that you have missed the DE (Data Extension) between the program and the actual custom field. I have also tested this to be sure and it works as expected for me. Please let me know if you experience something else.

Edit:
Comment from ​@_Manish_Singh did not load for me, as I did not refresh the page. Will leave the comment as it also shows the difference between DE:parent:field and parent:DE:field (same functionality different syntaxt)

Best regards,
Ivan Bebek

Practice Lead Work Management

CYBER64
Adobe Gold Solution Partner

Translate