@CynthiaBoon
I really enjoyed this webinar. I finally got around to creating one of the samples you guys presented. (Calculated Field #2 - Link to a tab on an object from Slides #13 and #14 in the presentation deck). I successfully completed every step except the very last one.
I created the calculated field and successfully added it to the task report. The link works when I leave the link as is, but when I try to set a rule for "IF this field IS NOT BLANK, 'show text' - "Click Here," it removes the hyperlink. If I do not have this text, then the hyperlink works.
I add the text mode line "link.url=DE:custom field name" but for some reason the "show text" rule just overrides this line. Can someone help?
Here is what my text mode looks like (I've bolded the line that I add to try and link):
valuefield=project:Link to Documents Tab
styledef.case.0.comparison.operatortype=string
styledef.case.0.comparison.operator=notblank
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=DE:project:Link to Documents Tab
styledef.case.0.comparison.righttext=
styledef.case.0.comparison.lefttext=DE:project:Link to Documents Tab
styledef.case.0.comparison.truetext=Click Here
valueformat=customDataLabelsAsString
linkedname=project
namekey=view.relatedcolumn
link.url=DE:Link to Documents Tab
textmode=true
namekeyargkey.0=project
namekeyargkey.1=Link to Documents Tab
querysort=DE:project:Link to Documents Tab
case.0.comparison.truetext=Click Here
case.0.comparison.righttext=
case.0.comparison.leftmethod=DE:project:Link to Documents Tab
case.0.comparison.operatortype=string
case.0.comparison.icon=false
case.0.comparison.operator=notblank
case.0.comparison.lefttext=DE:project:Link to Documents Tab