How to Download and Schedule the APP Overdue Activity Master Report

Dashboard

  1. 1. Click on Activity

    Click on Activity
  2. 2. Click on Activity Detail (Looks)

    Click on Activity Detail (Looks)
  3. 3. Click on Toggle Filters

    Click on Toggle Filters
  4. 4. Select the filter "Activity Note CreatedDate" and select "is any time."

    Select the filter "Activity Note CreatedDate" and select "is any time."
  5. 5. Click on the filter "Activity Task Due Date" and select "is before."

    Click on the filter "Activity Task Due Date" and select "is before."
  6. 6. Change (relative) to (absolute).

    Change (relative) to (absolute).
  7. 7. Under the date, select YESTERDAY'S date (the day before the report is being run).

    Under the date, select YESTERDAY'S date (the day before the report is being run).
  8. 8. Select the filter "Activity Task Task Status" and select "Open."

    Select the filter "Activity Task Task Status" and select "Open."
  9. 9. Click on Run

    Click on Run
  10. 10. Click on Explore actions (gear icon)

    Click on Explore actions (gear icon)
  11. 11. Click on Download (⇧ + CTRL + L)

    Click on Download (⇧ + CTRL + L)
  12. 12. Name the report "APP Overdue Activity Master Report"

    Name the report "APP Overdue Activity Master Report"
  13. 13. Select All results

    Select All results
  14. 14. Click on Download

    Click on Download

To Schedule

After you've downloaded the initial report, you can schedule it to continue sending updated information every week.

  1. 15. Click on Explore actions (gear icon)

    Click on Explore actions (gear icon)
  2. 16. Click on Schedule (ALT + CTRL + S)

    Click on Schedule (ALT + CTRL + S)
  3. 17. Name the Schedule "APP Overdue Activity Master"

    Name the Schedule "APP Overdue Activity Master"
  4. 18. Select Email

    Select Email
  5. 19. Add the email recipients, use commas for multiple addresses

    Add the email recipients, use commas for multiple addresses
  6. 20. Select XLSX

    Select XLSX
  7. 21. Under Trigger, select Repeating interval

    Under Trigger, select Repeating interval
  8. 22. Select Weekly

    Select Weekly
  9. 23. Select Monday at 6:00 AM

    Select Monday at 6:00 AM
  10. 24. Toggle Filters

    Toggle Filters
  11. 25. By Activity Task Due, select (relative)

    By Activity Task Due, select (relative)
  12. 26. Then indicate 1 and "days ago."

    Then indicate 1 and "days ago."
  13. 27. Toggle Advanced options

    Toggle Advanced options
  14. 28. Under Limit, select All Results

    Under Limit, select All Results
  15. 29. Select Save All

    Select Save All