Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!
SOLVED

Text Mode - Can you bring in document IDs from the project into a task report?

Avatar

Level 8

I do not think it is possible b/c you would have to jump too many levels, but I wanted to check with the community before I rule it out. We want to have a link in a task report column back to a project level document. If you use the documents collection, it points to the task level document. If you use the projects collection, you are still a level removed from the project documents. Any fancy ideas on how to make this work? This text works, but only for docs at the task level. 

displayname=Supporting Documents
listdelimiter=<hr>
listmethod=nested(documents).lists
textmode=true
type=iterate
valuefield=ID
valueformat=HTML

 

Can I somehow expand this to read the project level documents?

1 Accepted Solution

Avatar

Correct answer by
Level 6

nested(projects).nested(documents).lists will work for you

View solution in original post

4 Replies

Avatar

Correct answer by
Level 6

nested(projects).nested(documents).lists will work for you

Avatar

Level 6

 

Actually project is singular so...

 

listdelimiter=<hr>
listmethod=nested(project).nested(documents).lists
name=Project Docs
stretch=0
type=iterate
valueexpression=CONCAT({name}, " - " ,{lastUpdateDate})
valueformat=HTML

Avatar

Level 8

Thank you my friend! I was so close. I was writing it as; 

listmethod=nested(project).lists.nested(documents).lists

 

I am glad I asked! 

Avatar

Level 6

and you can do the valueexpression then just to add as much info about the document as you like as per my follow up example