In Manage Registrations View, how to export only the lastest registration per user?

Created on 14 May 2024, 11 months ago
Updated 20 May 2024, 11 months ago

Problem/Motivation

I have an Event set up which users can Accept or Decline. They can also change their response from Accept to Decline and vis versa. This means there are multiple records in the Manage Registration view for the Event node e.g

Registration ID|| User || Status || Date created
...
12 || John Smith || Not attending || Mon, 06/05/2024 - 11:03
11 || John Smith || Attending || Mon, 06/05/2024 - 10:33
...

This is a problem because if we filter the view by Attending, John Smith will be in the results even though his latest response is Not Attending.

Therefore my question is, is it possible to filter the Manage Registration view so that only the latest record for each user is visible?
So for example, we would have have the record with Registration ID of 12 and not 11.

I know I could un-check "Allow multiple registrations" in the settings and have the users just email the admin if they want to change their RSVP, but thought I'd check I could fix it in the View as well.

Thank you

πŸ’¬ Support request
Status

Closed: works as designed

Version

3.1

Component

Registration Views

Created by

πŸ‡³πŸ‡ΏNew Zealand dominictaylor

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @dominictaylor
  • πŸ‡ΊπŸ‡ΈUnited States john.oltman

    Thanks for the post @d_t - instead I would give the users permission to edit their registrations. Then you could uncheck "Allow multiple registrations" and avoid this whole issue. Even better may be to enable registration_workflow and enable the Cancel transition for them so they can cancel without needing to edit.

  • πŸ‡³πŸ‡ΏNew Zealand dominictaylor

    Hi @john.oltman, thanks for the quick reply.

    This worked although it means that users can't use the Form on the node to edit their registrations, they have to go to the Registration tab on their profile. I think that should be fine, so I just updated the confirmation text to explain this.

    Thanks again

  • Status changed to Closed: works as designed 11 months ago
  • πŸ‡ΊπŸ‡ΈUnited States john.oltman
Production build 0.71.5 2024