How do I make the value within the column an active URL to click on?

Hi Joe! I have code from one of my columns but it's pretty messy, but works! In this example, my custom field is called DE: Alfresco Edit URL. The line that has what I wanted to replace the text with is: case.0.comparison.truetext=Doc Central Link Basically, to get the code for the replacement text, I went to Advanced Options -> Add Column Rule. For my filter I used Project > Alfresco Edit URL -> Is not Blank. In the Show the field like this options, I checked the Show Text box and put what I wanted in there. I then saved, then went into text mode and added the other code included below. case.0.comparison.icon=false case.0.comparison.leftmethod=DE:Alfresco Edit URL case.0.comparison.lefttext=DE:Alfresco Edit URL case.0.comparison.operator=notblank case.0.comparison.operatortype=string case.0.comparison.righttext= case.0.comparison.truetext=Link description=Doc Central link.isnewwindow=true link.url=customDataLabelsAsString(Alfresco Edit URL) linkedname=direct listsort=customDataLabelsAsString(Alfresco Edit URL) name=Doc Central querysort=URL shortview=false stretch=70 styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=DE:Alfresco Edit URL styledef.case.0.comparison.lefttext=DE:Alfresco Edit URL styledef.case.0.comparison.operator=notblank styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext= styledef.case.0.comparison.truetext=Doc Central Link textmode=true valuefield=Alfresco Edit URL valueformat=customDataLabelsAsString

Hi Adina, Thank you so much for sharing your code, my report now looks beautiful! I was able to modify your code and test my report. The column value went from a 100+ character count to an eleven character hyperlink! The report no longer runs off the template and is easy to view. Thanks again! Best regards, - Joe

Hi Adina, I'm testing the method you've provided and it does work on a custom field on a project form but I'm testing the same method against a regular note field eg threadID and it won't make it a clickable link. I'm just wondering why the method couldn't work on a regular field. Similar to Matt May's post, I have a long link that I want to shorten and because it cannot be a custom field (it's actually a url construct using the notes threadID), I'm trying to understand how the other link codes work. What values are allowed in customDataLabelsAsString( Alfresco Edit URL ), is it always a field, can this be an expression or the value itself eg www.google.com?

I have not tried linking anything besides the URL field or calculated field that contains a single link. Maybe someone else can chime in?

Hi Adina, Did you manage to get this done in a task report. I can have the link clickable but when I try to replace by a custom text it does not work anymore. This is my code for that work to make a url (pulled from project custom form) clickable in a tasks report: displayname=Folder link.isnewwindow=true link.url=customDataLabelsAsString(Edu file folder path) linkedname=direct textmode=true valuefield=DE:project:Edu file folder path valueformat=HTML Yannick WebMD Global

I'm having this same problem on a Task Report (which is where I need it) -- Project Report seems fine. I can get the full link to work (pulling from calculated custom field on the project level), but I don't want it to show the very long link. Instead, I want it to hyperlink the replacement text. So basically, in my case, it would say "View Form" be hyperlinked to the form utilizing the link from the calculated custom field. Does anyone have ideas? Am I just missing something? In Reply to Yannick Seifert:

Hi Adina, Did you manage to get this done in a task report. I can have the link clickable but when I try to replace by a custom text it does not work anymore. This is my code for that work to make a url (pulled from project custom form) clickable in a tasks report: displayname=Folder link.isnewwindow=true link.url=customDataLabelsAsString(Edu file folder path) linkedname=direct textmode=true valuefield=DE:project:Edu file folder path valueformat=HTML

Finally got it! So the history on this for me... I was trying to get a concatenate hyperlink to shorten URL of the PROJECT’s custom form but on a Task report. The reason for doing this is all our important information for each project exists at the project level, but a number of clicks it takes our users to get there is a huge overall organization complaint. They have a task report on the dashboard they use and have expressed quite vocally that having a quick link to the PROJECT’s custom form would be ideal rather than the several click process it now takes to get there. So what I first implemented was adding a calculated field on the custom form on all the projects which provides a link to the custom form. The field is called “Project Custom Form” and the calculation is as follows: CONCAT("https://streamco.my.workfront.com","/","project/view?ID=",ID,"&activeTab=form-customdata") And this works with this code on a PROJECT level report with this code: case.0.comparison.icon=false case.0.comparison.leftmethod=DE:Project Custom Form case.0.comparison.lefttext=DE:Project Custom Form case.0.comparison.operator=cicontains case.0.comparison.operatortype=string case.0.comparison.righttext=https: case.0.comparison.truetext=View displayname=Custom Form link.isnewwindow=true link.url=customDataLabelsAsString(Project Custom Form) linkedname=direct namekey=Project Custom Form querysort=DE:Project Custom Form styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=DE:Project Custom Form styledef.case.0.comparison.lefttext=DE:Project Custom Form styledef.case.0.comparison.operator=cicontains styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext=https: styledef.case.0.comparison.truetext=View textmode=true valuefield=Project Custom Form valueformat=customDataLabelsAsString width=150 It will give me a column labeled “Custom Form” with “ View ” links for each project that open the custom form in a new window. That’s all great and working fine - but it’s one level too high. We need it on tasks -- remember. However, I thought this would be helpful for anyone who wanted it on the project level as well. Onto actually solving the problem at hand... On a Task report, I was able to use this code to get the full link, completely hyperlinked to open in a new window, for the PROJECT’s custom form for each Task --- and that works, but it’s the full link which is very long: displayname=Project Custom Form link.isnewwindow=true link.url=customDataLabelsAsString(Project Custom Form) linkedname=direct textmode=true valuefield=DE:project:Project Custom Form valueformat=HTML And now, finally after trail-and-error and a ton of research, I was just able get it to work on Task Level by using this code: case.0.comparison.icon=false case.0.comparison.leftmethod=DE:project:Project Custom Form case.0.comparison.lefttext=DE:project:Project Custom Form case.0.comparison.operator=cicontains case.0.comparison.operatortype=string case.0.comparison.righttext=https: case.0.comparison.truetext=View Project Custom Form displayname=Project Custom Form link.isnewwindow=true link.url=customDataLabelsAsString(project.Project Custom Form) linkedname=direct namekey=Project Custom Form querysort=Project Custom Form styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=DE:project:Project Custom Form styledef.case.0.comparison.lefttext=DE:project:Project Custom Form styledef.case.0.comparison.operator=cicontains styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext=https: styledef.case.0.comparison.truetext=View Form textmode=true valuefield=project.Project Custom Form valueformat=customDataLabelsAsString width=150 Now I have a column called "Project Custom Form" on the task report and for each task it has a link that says "View Project Custom Form" (I will probably shorten this) that links directly to the PROJECT's custom form in a new window/tab in a single click.

Attaboy Matt! Congratulations and thanks for sharing. Take the rest of the day off: you deserve it. Regards, Doug

Matt, I put this code in a column of a project report - but my column has no data in it. I created the calculated field on one of my custom forms first, then ran the report. The column is blank. Thanks for your help.

Benetta, happy to help. Would you mind posting your code for both the calculated field you added and the code you have for column? Thanks! In Reply to Benetta Perry:

Matt, I put this code in a column of a project report - but my column has no data in it. I created the calculated field on one of my custom forms first, then ran the report. The column is blank. Thanks for your help.