Is there a way to pull a list of email recipients based on their appearance in a report? | Community
Skip to main content
M
MichaelPe1
Level 5
May 25, 2021
Question

Is there a way to pull a list of email recipients based on their appearance in a report?

  • May 25, 2021
  • 2 replies
  • 455 views

I have a compliance dashboard with several reports based on different criteria that need to be fixed in projects. Each report has a column for the project owner. I want to send an email to users only if their name appears in the reports. Is there any way to accomplish this? Right now it looks like I need to manually review the reports and add each user to the email list one by one. Any ideas on a better way to approach this?

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

    2 replies

    SamanthaIsin
    SamanthaIsin
    Level 7
    May 25, 2021

    I would also like to know if this is possible!

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    May 25, 2021

    Hi Tracy and Samantha,

    Although Workfront can email reports, As Designed, it is typically more efficient to present the information within Workfront, and "encourage" the user to log in and look.

    Given that, one approach is to filter the reports(s) where Project Owner ID = $$USER.ID, so that when any such Project Manager logs in and looks at the report(s) (or the Dashboard, if you've done so throughout), the only data returned will be those items that pertain to "them".

    Along that line of thought (while we're in the neighborhood), I invite you to consider our UberFilter solution, which can spare you loads of report cloning and maintenance effort by letting your users choose a dashboard level filter that will update the filters of all related reports at once vs separate prompting.

    Regards,

    Doug

    Terms & ConditionsAccessibility statement

    Loading footer...