Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jan 23, 2021 04:28 AM
Hello.
I need to create a base to daily record the time and date that the Airtable app is open or closed and associate that with the user.
I need to record at what time the user opened up Airtable and closed it.
It would need some kind of trigger that automatic creates a record, populating “created time” and “created by”. And then using some kind of “NOW()” formula to keep updating until Airtable is disconnected - then it would save the last hour “recorded”.
Any ideas?
Thank you in advance
Jan 23, 2021 05:42 AM
Yep - did this for two clients using two different approaches.
Analytics from Google Workspaces
Analytics from a Custom App
Using the first approach requires the team is on Google Workspaces. The second approach even allows us to compute certain productivity metrics by user.