Text Mode - Can you bring in document IDs from the project into a task report? | Community
Skip to main content
BrandonNW
BrandonNW
Level 6
August 23, 2022
Solved

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

  • August 23, 2022
  • 1 reply
  • 879 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by GrahamJarrett

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

1 reply

GrahamJarrett
GrahamJarrettAccepted solution
Level 4
August 23, 2022

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

    GrahamJarrett
    GrahamJarrett
    Level 4
    August 23, 2022

     

    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

    GrahamJarrett
    GrahamJarrett
    Level 4
    August 23, 2022

    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! 


    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

     

    Terms & ConditionsAccessibility statement

    Loading footer...