Weekly User Activity Report

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

I am needing to build a report that provides a weekly activity report showing what users have done between several tables in the same app, from tasks to updating opportunities. What is the best way to show these results?

Photo of Greg

Greg

  • 0 Points

Posted 5 years ago

  • 0
  • 1
I'm assuming that you want to have a single "page or "report" with updates from several tables.

How about this for an idea - its like a personal dashboard by user.

Make a table of your users and make the Key field the User Table.

Make relationships to each detail table based on the User Key field and the [last modified] field on each respective table.

Put the report link field from each relationship on the user record and then make a nice report on each child table to use on the form. The report should filter for the date range, but NOT the user - the Report link field will do that User filter automatically.