Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Avatar

Level 7

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 3

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

View solution in original post

4 Replies

Avatar

Correct answer by
Level 3

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

Avatar

Level 3

 

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 7

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 3

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