Retrieve participation status of a guest to an event (when several events exists)

[clementine.grosset]

Hello,

I’m currently working on an event management app and I’m facing difficulties in displaying the accurate participation status (pending/confirmed/declined) that corresponds to the correct event (as Users can create multiple events, and a same guest could be invited to several events).

I currently have two tables: “Event” and “User/Guests.”

The “Event” table includes the following fields:

• Event_Name
• Event_Guests (list)

The “User/Guests” table includes the following fields:

• User_Mail
• User_Event (list)
• User_Participation (list)

Should I add another table to establish the connection between users, events, and participation?

or do you know what would be the best solution to display the correct participation status?

Thanks for your help

[tylerboodman]

Yes you need another datatype Participation with fields for Event and Guest

That allows you to do searches for a specific guest and get all their events and vise versa

Very similar to this:

Trying to forward think

Yes, you make another datatype called “Like” With a field for Post (Post datatype) and a field for User (User datatype) When they click like it creates a new Like, sets those two fields. Then later in the future if you want to look at all your liked posts you do Do a search for Like, constraint User = Current user, then do :each item's Post Or to get all the Users that liked a specific post, you do Do a search for Like, constraint Post = [specific post], then do :each item's User There would…

[clementine.grosset]

Thanks a lot for you help, that worked perfectly indeed !