Victor Font Staff answered 12 hours ago
Many ways to do this. What's your question?
Joe Semones
replied 11 hours ago This help system loses the post every time. Maybe a comment will survive...
Complex filter View
I have a form which collects sign ups for an annual event. We have registrations from 2024 and more this year. I'd like to create a view which provides a list of people who registered last year but exclude those from last year who've already registered for this year's event. We already use event year as a field to filter the registrations by event year.
It seems I need to get a list of names who've registered this year and exclude them from the list of all 2024 registrations. Is that possible within the View Filter?
Joe Semones
replied 11 hours ago This help system loses the post every time. Maybe a comment will survive...
Complex filter View
I have a form which collects sign ups for an annual event. We have registrations from 2024 and more this year. I'd like to create a view which provides a list of people who registered last year but exclude those from last year who've already registered for this year's event. We already use event year as a field to filter the registrations by event year.
It seems I need to get a list of names who've registered this year and exclude them from the list of all 2024 registrations. Is that possible within the View Filter?
This requirement sounds like it needs custom SQL. I'm not sure how you would do this with the view filter, but using the frm_view_filter hook, you can run your own SQL to feed the view.
Please login or Register to submit your answer
