Would be great to have a “Last Login” Time/Date field in the User table. We have a “User Admin” page and being able to see this (a/o calculate “Days Since Last Login”) would be very helpful.
Bonus points: access to the login logs so we could create usage reports every day (and email them to system owners) showing things like: # of Users today, # of new Users, etc.
This would be a fantastic add, even if accomplished by adding Form Rules on the Login component to set this value each login.
Would love to be able to create dynamic filters for “new data since last user login.”
+1 for this. Would be very helpful to see who is actually using our systems, run nightly reports on who logged in each day, etc.
@tim.young Any updates on ways to solve for this? Would love to be able to use the login logs in a data table.
Was just about to post to ask how this could be achieved. We would love to be able to email customers who haven’t logged into view their booking yet or haven’t logged in for a while, having this data would be super helpful
+1 for this, or at least a way to update a “Last Login” Date field on User table at login? Somebody can probably figure out how to build workflow to update a table at login, right?
Would love get a report of activity every day, and also see a report of how active users are.
Hi, just to show that TB has the option to see the user login/logout activity in the app settings / user settings; the general tab has the “log successful user logins” toggle with seevral options, and the upper tabs login logs and failed logs show the attempts and users log.
However I cannot see any means to export or take this data to any app table
@moe any possibility of getting this? Or way to achieve this?
It looks like there are two ways to do this reliably now.
Option 1: Workflow
User Event Trigger > User Logged In > Create Action > Record Update > Last Login (Create a Time/ Date Field) > Value Source > Static Value > Current Date & Time
Option 2: Pipescript + JS on landing page.
I did not want to burn a workflow for this, so the alternative is to use a pipescript.
In the Tadabase REST API, make a copy of “Update Existing Record” Pipe.
IMPORTANT: Update the parameter settings as follows. Specifically, you want to make sure the Record ID is marked required. If the pipe ever runs without a record ID it will expose several users’ data in the console output. Not sure why the API is designed this way.
Refresh the page, then copy the pipescript. Place the code on the first page users are redirected to after login. Add the code block below (paste above your pipescript). Update these variables in your pipescript: field_val: savedLogin.time, recordId: userIDPlace.
The time will only be updated on the first run since it is tied to the session storage. You can set the max age of the session storage as well incase someone does not close the tab (24 hours by default).
JS
/* Capture last login */
const userID = '{loggedInUser.Record ID}';
const sessionKey = 'loginSessionTime';
const maxAge = 24 * 60 * 60 * 1000;
let savedLogin;
try {
savedLogin = JSON.parse(sessionStorage.getItem(sessionKey));
} catch (error) {
savedLogin = null;
}
if (
!savedLogin ||
!savedLogin.time ||
!savedLogin.createdAt ||
Date.now() - savedLogin.createdAt >= maxAge
) {
const now = new Date();
const pad = value => String(value).padStart(2, '0');
savedLogin = {
time:
`${now.getFullYear()}-${pad(now.getMonth() + 1)}-${pad(now.getDate())} ` +
`${pad(now.getHours())}:${pad(now.getMinutes())}:${pad(now.getSeconds())}`,
createdAt: now.getTime()
};
sessionStorage.setItem(sessionKey, JSON.stringify(savedLogin));
}
/*INSERT YOUR PIPESCRIPT STARTING HERE*/