Child Tasks List + Custom Field

[Mikaela-Newell]

Hi all!

I have a task report which pulls parent tasks with a certain name. The second column is the parent task name + a custom field called "Internal Design Comments" and it is working properly; the third column should be a list of child tasks alongside any "Internal Design Comments" at that task level, but it isn't working.

The second column is done in text mode like so:

column.1.displayname=Parent
column.1.sharecol=true
column.1.textmode=true
column.1.valuefield=name
column.1.valueformat=HTML
column.2.textmode=true
column.2.tile.name=component.customdata.richtextlistview
column.2.type=tile
column.2.valuefield=Internal Design Comments
column.2.valueformat=customDataRichTextAsString

For that third column, I can't get Internal Design Comments to pull in next to the tasks I'm listing... this is what I have:

displayname=Child Tasks
listdelimiter=<p>
listmethod=nested(children).lists
type=iterate
valueexpression=CONCAT("• ",{name},IF({DE:Internal Design Comments}="",""," — ",{DE:Internal Design Comments}))
valuefield=name
valueformat=HTML

Does this not work because the Internal Design Comments is a "tile" / rich text? Anyone have a creative workaround?

TYIA!

[Kurt_Jones]

Mikaela,

You can't have valuefield and valueexpression in your textmode, its one or the other, that's the initial issue.  Remove the valuefield=name.  I think you want this for your expression, 

valueexpression=CONCAT("* ", {name}, IF({DE:Internal Design Comments}="",""," - {DE:Internal Design Comments}")) 

I couldn't get the dot just used *.  The statement above says `concat the task name if comments are blank, leave blank, otherwise add comments to concat of the task name`.  I think this should work for you

Let me know if this helps

[kautuk_sahni]

@Mikaela-Newell just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!