Applying user input in lightbox form to direct page

I am working on a wedding website, and would like to build in the ability to RSVP online. Guests are either invited to all events (call them “Guest Type A”) or only a few events (“Guest Type B”). I have different Events pages set up for A and B.

I’d like to be able to have everyone enter their last name into a text box/form and, based on their response, direct them to the appropriate Events page.

I first tried setting up a Database with all of the guests’ names, then running a data query on that database to get them to the right Events page. However, that doesn’t seem to work. Any advice (or a better solution — I am totally new to this) would be incredibly appreciated!

Hi,
Why not to use member area pages each will be to different roles?

GL and congratulation, Erez

Thanks for the reply. I would prefer not having a membership component to the site (it would just be a hassle for people not using Wix). Since I already have a guest list I thought that could serve as a database to reference. Is that possible.

You can verify the guest by name, email … and then redirect to the relevant page…