Expand my Community achievements bar.

code to show the predecessor number, name, and due date in a report field

Avatar

Level 2

Has anyone written code to show the predecessor number, name, and due date in a report field? (Not just the pop-up from hovering over the predecessor number.)

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Community Advisor

 

 

displayname=Predecessor(s)
listdelimiter=<br>
listmethod=nested(task.predecessors).lists
textmode=true
type=iterate
valueexpression=CONCAT("(Task#: ",{predecessor}.{taskNumber},") - ",{predecessor}.{name}," - ",{predecessor}.{assignedTo}.{name}," - ",{predecessor}.{plannedCompletionDate})
valueformat=HTML

 

I usually accompany this with a "Successor" column and a handoff date column.

 

TIP: if this solves your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas

 

Avatar

Community Advisor

Hi @RandyRoberts, this code just what I was looking for! Can you use it on a tasks report? It's not returning any data for me