Is there a way to pull the Last Seen field on the users table?

mike.magitech · July 29, 2022, 6:45pm

Hello, I’m new to softr and am currently building an app as a launch page for consultants to keep their skills and projects up to date.

I’d like to know when the last time a user has logged into the app so that we could remind users to login periodically to update their statuses. It seems the easiest way would be to use the Last Seen information on the Users page. Is there a way to pull that date/time filed into the attached Airtable or otherwise access this information that doesn’t involve manually navigating to the page and referencing the information visually?

If that is not an option, are there any recommendations on how to accomplish this?

Thanks!

Suzie · August 2, 2022, 10:37am

Dear @mike.magitech,

Unfortunately, there is no such native feature, however, this can be done with formula field in Airtable.

I will try to do a few checkups myself as well and will post here

Thanks!

rebeccajane · January 9, 2023, 9:03pm

Hi there, is there any update on the formula for last seen date?

artur · January 9, 2023, 9:43pm

Unfortunately not yet…

dcoletta · January 9, 2023, 9:48pm

I have done this with a webhook call to Make that updates a field in the record of the Users table corresponding to the currently logged in user.

rebeccajane · January 13, 2023, 12:43am

Amazing, thank you. I’ll use that for now. Hoping to see that kind of data pull through eventually!

aar0n · January 18, 2023, 5:31am

how is this done?

BarcodeMaker · January 18, 2023, 7:50am

There is no way to pull the last seen field on the users issue table. Can we create migration to add a new field?

artur · January 18, 2023, 8:53am

Folks for us to prioritise this we would need to understand the use case a bit. Can you please share what’s the reason you want to add this back to Airtable ? What would you do with it afterwards if it’s added ?

rebeccajane · January 25, 2023, 3:10pm

Hey @artur for my use cases, some users may login to the system but not complete any actions that would note in Airtable.

EG scenario - they login and open a document. I can’t see that they opened a document in Airtable. I can only see if they modify the record and/or perform an action to update or add a record.

If I could use the ‘last seen/last login’, I would have an automation setup and trigger set for ‘if did not login within the last x days’ , send ‘x follow-up’ email.

I’m wondering it is possible to add the ‘last seen’ data into the ‘optional’ fields in the User Connection