Reporting Question: Task URL field into a Project Report? | Community
Skip to main content
H
HeatherLa2
Level 3
May 27, 2020
Solved

Reporting Question: Task URL field into a Project Report?

  • May 27, 2020
  • 2 replies
  • 818 views

We are working on our integration with Adobe Assets; in the meantime, we publish assets through a manual process of assigning a publishing task and then the content publishers input the eDAM link into the Task URL field once it is completed. We do this on the task level URL, because a project might have multiple publishing tasks for various deliverables. I would like to get these URLs onto an existing project report for reference and to make it easy to find those links.

Using text mode based on the suggestions from this great community, I've been able to create a Current Task column and a Tasks Pending Approval column within my Project report, so I know I'm able to pull task related data into a Project Report.

What I'm looking for: if a Task URL field is not blank, put that Task URL result into a column in the Project report.

Hoping someone can help me with this!

    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 Doug_Den_Hoed_AtAppStore

    Hi Heather,

    To show all of the Task URLs in a Project Report, you can and a column with this textmode:

    valueexpression=CONCAT({URL})

    listdelimiter=

    listmethod=nested(tasks).lists

    valueformat=HTML

    displayname=Task Links

    textmode=true

    type=iterate

    @NRYN R - inactive‚ if you’d like to add this to your Text + Collections examples, you’re welcome to do so (which, btw Heather, is where I started this investigation, using the “Documents” example).

    Regards,

    Doug

    2 replies

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
    Community Advisor
    May 28, 2020

    Hi Heather,

    To show all of the Task URLs in a Project Report, you can and a column with this textmode:

    valueexpression=CONCAT({URL})

    listdelimiter=

    listmethod=nested(tasks).lists

    valueformat=HTML

    displayname=Task Links

    textmode=true

    type=iterate

    @NRYN R - inactive‚ if you’d like to add this to your Text + Collections examples, you’re welcome to do so (which, btw Heather, is where I started this investigation, using the “Documents” example).

    Regards,

    Doug

      H
      HeatherLa2Author
      Level 3
      May 28, 2020

      Thank you, Doug! This is exactly what I was looking for. The perfect part is that even with more than one URL, it is populating within the report. Perfect!

      Doug_Den_Hoed_AtAppStore
      Community Advisor
      Doug_Den_Hoed_AtAppStoreCommunity Advisor
      Community Advisor
      May 28, 2020

      Excellent -- happy to help, Heather.

      As an aside, my first few tests were more complicated in that I was trying to also CONCAT the Task Number and Task Name, but I was unable to get that working (partly because I was struggling to do so on my iPhone), but when I realized that URL (vs url...case matters) worked as cleanly as it did, decided to stick with the latter...particularly since the iteration cannot be sorted, anyway.

      Regards,

      Doug

      Terms & ConditionsAccessibility statement

      Loading footer...