Record history of user logins to a table in the database

[entrotech]

Overview

The new redesign of the Volunteer Dashboard calls for displaying to a user their most recent previous login. We need to add a table to record the login history and modify the login process to insert a record to that table each time the user logs in.

The needs:

• Volunteers sometimes ask to get written/emailed proof of the hours they've volunteered from the volunteering organization, so this tool would allow the volunteer manager to easily look up logins to know what the sessions and estimate hours worked. (since much of the work is done on the phone, might not have actual records of when the volunteer stopped working)
  • Stretch: Does the have some record of volunteer interactions with the system that could give an idea of volunteering end-time?
• Volunteer coordinators would like to have a list of currently-signed in volunteers so that they can assign tasks to those present. Currently, this is seems to be done by hand: by looking at names of participants on a zoom call, matching those up to volunteer logins, and going from there?

Action Items

• Confirm that we need this (or parts of this) with volunteer coordinators
• Sketch out MVP UI design
• Put together MVP (see below) that shows timestamped log-ins which can be filtered by username. Show Jordan.
• Does this meet Jordan or other team member needs? Anything missing (and hopefully easy)?
• Implement
• What workarounds to volunteer coordinators do now?
• TBD

Resources/Instructions

We want a complete hsitory of logins, rather than just the most recent prior login, so we use that to possibly generate reports on volunteer participation.
Also, need to determine behavior when browser remembers sessions between visits (maybe session timeout should be shortened?)

[entrotech]

Don't start work on this until we finish #896, and confirmm that we need it first.

[fancyham]

A workaround that might work is to display a single page that shows recent sign-in logs, with a filterable log history of say, the past 100 records.

Nice-to-have would be to select a time period (date-date, year, and/or past X weeks/months) that works with the filter.

MVP

• Log display, showing recent log-ins: Date and time, username.
• Filter by typing username (stretch goal: autocomplete for usernames)
• Make accessible to volunteer administrators

Stretch goals

• Nice to have: Click on username as shortcut to assign tasks? (opens in new window?)
• Nice to have: Show how long user was active, perhaps estimating based on last interaction with server + 5 minutes.
• Nice to have Version A: User can pick a date range (date to date). Default is past week?
• Nice to have Version B: User can pick a date range ("Today", "Last 7 days", "Last 30 days", "Past 6 months", or date range) as well as date range. Default is "Today"
• Check with Jordan (volunteer coordinator) or other users of this function for most useful date ranges and usefulness.
• Nice to have: Logins from a specific date are grouped together

[entrotech]

The MVP version is merged on PR #1136. At this point, it is ready for @gigicobos and Jordan Smith and others to review and suggest future direction.

[gigicobos]

@entrotech Working with LA works to set up a meeting and review the feature with them (Jordan, Stephanie, and Charles). Not sure if we'd be able to meet before the holidays but I'll keep the team posted with comments. Thank you very much!

[Benbaillou]

What Sub User Problem are we solving?
As mentioned above by @entrotech => it is difficult for the volunteer coordinator to estimate the number of hours a volunteer had worked to complete his assignment
Why because "Log in" and "Log off" times, does not reflect the active work done.

What are we building?
To estimate more precisely

1. We want to count the number of organisations completed by each volunteer
   Completion equals one or the other action below
   i) a volunteer pressed the button "hands off"
   ii) a volunteer pressed the button "Submit"

2. We want to display this count on the login table against each volunteer (see mock up)

Stretch question:
Do we want to display the number of organisations done vs the number of organisations assigned to follow the progression of each volunteer?

Source of the solutions:
User interview with Jordan Smith (LA Work) 12 Jan 2022

Important Note:
To confirm with Jordan that counting the number of organisations checked by each volunteer can help to estimate the time spent by the latter.
Why => because the final objectives for the volunteers, is to get a certification of the number of hours done.

What a success looks like - What are our Goals?
=> conversion: how many volunteers were given an estimate of their time spent thanks to this feature.

New actions

• Check the feasibility and the size of the solution - Eng + PM
• Design - designers
• Implement - Eng

[Benbaillou]

Hi @gigicobos, @entrotech @fancyham - please find above the last updates on this issue and the improvements needed based on Jordan's feedback.

Please provide your comments.

Thanks,

[Benbaillou]

@souronion - here is an issue I updated. I would love your design comments on this one.

[fancyham]

Hi folks, is this currently in progress?

[entrotech]

@erin @staceyrebekahscott I think we need to revisit this issue, and decide how to move forward. There is a basic login history available to the Admins now, but do we need additional functionality?

[staceyrebekahscott]

@itserindean Moving this to the Product board. As you have more involved with this I will defer to your judgement as to what else is needed here, or if we should close this as completed.

[itserindean]

I don't think we need additional functionality so i'm closing as completed