Is there a way to make tasks automatically open in a NEW TAB from a TASK Report?

[Matt_McC]

Hopefully, this is an easy one.

We have a task report that users regularly use to get the information they need. This report relies on PROMPTS so that it can be used by all. Unfortunately, if the user clicks into the task instead of opening the task in a new tab they need to reapply the multiple prompts which makes for a poor user experience. Is there a way to modify the text mode of the Task column so that the task is opened in a new tab by default?

[Rafal_Bainie · Accepted solution]

Hi Matt, 

we do this in our instance. It requires 2 steps I believe:

1. custom calculated field on task level with formula: 

CONCAT("https://[yourdomain].my.workfront.com/task/",{ID},"/updates")

2. Field in a report with following text mode:

displayname=[Column name]
link.url=customDataLabelsAsString([Custom field name])
namevalue=[Custom field name]
textmode=true
valueexpression=IF(ISBLANK({DE:[Custom field name]}),"","Updates")
valueformat=HTML

This will give you a hyperlinked Updates

Hope this helps

[Matt_McC]

Thanks Rafal. This is a great solution. I am hoping to find a something that does not require a custom task field but this is my #1 backup. Thank you!