Is there a way for me to determine days and times that a particular user has logged on?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Photo of Deziree

Deziree

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
You can go to the List of users  when you are in manage My Account, and see when they last logged into ANY app, and you can go into any app and see when a user last visited that app, by looking at the Users for the app.  But that's about it.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,044 Points 20k badge 2x thumb
Yes this can be done but it involves using script. Luckily in 2017 we are going to benefit from an amazing collection of new JavaScript features and browser innovations that will make this simple and straightforward.

Here is the step by step procedure:

1) Write a Service Worker to inject script into the page:

https://SUBOMAIN.quickbase.com/db/main?a=signin


2) In the script you inject implement the following logic:

a) add a hidden but empty <iframe> to the signin page

b) add a target attribute to the signin <form> specifying the <iframe> 

c) add an event listener to detect when the hidden <iframe> loads

d) if the event listener detects an unsuccessful login provide feedback and ask the user to try again

e) if the user repeatedly bungles the login ban them from your application (it could happen: 

http://tinyurl.com/hcknvam)

f) if the login was successful post the login to a Logging table in one of your applications

g) redirect to main?a=myqb

It may sound complicated but this type of solution will become commonplace in 2017 when Service Workers is supported in all browsers (already supported in Chrome, Firefox and Opera; Edge in development; Safari ?).
If you need assistance implementing this solution fee free to contact me using the information in my profile:

https://quickbase-community.intuit.com/users/513/