Report Mangement - Track Report usage
In short, I need to know which reports are run, when, from which table and by whom. I thought a Pipeline event would work but a report run doesn't seem to be a recognizable Event. Is there a way to k...
Forum Discussion
That is perfect. I need a way to export that data set so that I can send as a report to my supervisor. Any help on that? Should I use Pipelines to pull that data into a lessor table?
------------------------------
Alan Sulzer
------------------------------
If you want the more robust way, you can use the Quickbase API to run the reports for a specific table and import those into a lesser Table by parsing the JSON through Pipelines. If you just want to use the reports page that I originally sent - you could always go the simplest route and just ctrl+a on the entire page, copy it into Excel and then clean up the bits of the webpage that you don't want. Not the most elegant, but as a one off it achieves the end result.
------------------------------
Chayce Duncan
------------------------------
@Chayce Duncan, Thank you. Ctrl+A worked well. I did notice in the Manage Reports page I have reports that have a "0" used count but have a last used date. How can that be?
------------------------------
Alan Sulzer
------------------------------My best guess is that someone made the report but then never actually displayed it. A common example would be that you 'Save As' to make a new report - and Quickbase then leaves you in the report settings/configuration page. If you never actually then display the report, I find that it will show like it was used, but never actually run.
------------------------------
Chayce Duncan
------------------------------Something to consider, but i haven't really verified this:
I once heard that if the report is in a dashboard/homepage and the user never goes to the full report but only access the report through the dashboard/homepage, then it won't count as 'usage'
Do you happen to know whether this is true, Chayce?
------------------------------
Tim D
------------------------------
