Skip to main content
Level 4
June 20, 2020
Solved

Does anyone have the text code to add a column in a report for the date a predecessor task was completed?

One of our users would like a column added to his task report that displays the date the predecessor task was completed.

The standard list of column options does not include this. Do any of you have a text mode way of accomplishing this?

I come from a design background and not coding so this is my weakness. But I really enjoy trying to solve these issues and build our best version of WF possible.

I appreciate any help you can provide.

Thank you

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
TracyPa2Accepted solution
Level 4
June 20, 2020

I did some digging through articles on here. I couldn't find exactly what i was looking for but i was able to find a code that I altered slightly and it works.

I'm going to leave this post up in case this helps anyone else. Here is the code I used:

displayname=Predecessors Completion Dates

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression={predecessor}.{actualCompletionDate}

valueformat=HTML

7 replies

TracyPa2AuthorAccepted solution
Level 4
June 20, 2020

I did some digging through articles on here. I couldn't find exactly what i was looking for but i was able to find a code that I altered slightly and it works.

I'm going to leave this post up in case this helps anyone else. Here is the code I used:

displayname=Predecessors Completion Dates

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression={predecessor}.{actualCompletionDate}

valueformat=HTML

Translate
Doug_Den_Hoed_AtAppStore
Community Advisor
Community Advisor
June 20, 2020

Well done Tracy!

Since you enjoy noodling these out, I invite you to review this related post, which builds on the concept you just applied.

Regards,

Doug

Translate
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.
TracyPa2Author
Level 4
June 21, 2020

Hmmm, I've been trying this on several different reports and even created a brand new project report but the fields are always empty. Haven't been able to solve the riddle yet...

Translate
kynabaker16
Adobe Employee
Adobe Employee
June 20, 2020

I second Doug! Well done, Tracy. You sound like you're getting more and more familiar with this type of work every day, even though it isn't your background.

Translate
Level 10
June 21, 2020

Good stuff everyone. This solution has been documented in the WFPro Text Mode Examples report.

Translate
Level 2
June 22, 2020

Thank you for sharing, Tracy! I will try it out as we've been looking for a way to display this data for a while!

Translate