🌟Check-In Time: Record the exact time when an attendee checks in

[trashken]

ℹ️ Please check if the feature you're requesting already exists in the project's roadmap or issues.

Is your feature request related to a problem? Please describe.
Unable to find the check-in time for each attendee.

Describe the solution you'd like
Display the check-in time and checkout-time for each attendee

Additional context

[daveearley]

Good suggestion! Thank you. This data is stored in the DB, so it will be easy to display.

[trashken]

the current version doesn't seem to record the check-in time in the attendees table.

[trashken]

Good suggestion! Thank you. This data is stored in the DB, so it will be easy to display.

Is it a bug? Should I create a bug report?

[dave-roofr]

@trashken Those columns relate to the deprecated check-in endpoints. There's another table that stores the check-in list data. I'm currently away from my laptop so I can't recall the exact name of the table

[trashken]

@trashken Those columns relate to the deprecated check-in endpoints. There's another table that stores the check-in list data. I'm currently away from my laptop so I can't recall the exact name of the table

Do you mean attendee_check_ins? It doesn't have a timestamp for check-ins only timestamps for creation and last_update.

[daveearley]

You can infer the check-in time from the created date. There's no need for an explicit "check-in" timestamp.

[trashken]

SELECT a.first_name, a.last_name, b.updated_at::timestamp at time zone 'UTC' at time zone '<your time zone>' FROM attendees a JOIN attendee_check_ins b ON b.attendee_id = a.id ORDER BY a.first_name ASC

Yes.. I am using the SQL above to get the times in my time-zone. Would be great if it was a report or somewhere for organizers to see who was early, on-time and late. Thanks.

[daveearley]

@trashken It has been requested a few times, so I'll add it into the next major version.