How to save timestamp/last login date for each user in a reportable way?

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

The "last visited" field in the Quickbase Users tab is not accessible to reports within the application. "Last modified by" fields in our various tables are not tracking the data we want to track. 


Essentially, we need a report that spits out the number of users active within a time frame, the number of users not active, and the percentage of overall users that are active/inactive. We need to separate this by user Role, if possible.


Since individual "last modified by" fields could be overwritten by User B, even if User A was active the day before, that field in our database doesn't help. 


Any help would be great. This seems rather simple, and if we could query the Users tab data then I wouldn't need help at all. 

Photo of Sloane Irwin

Sloane Irwin

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
See my awesome answer to this related question:

How Can I Show A User's "Last Access Date" from the billing account page in an application ?
https://quickbase-community.intuit.com/questions/792409