Communication between more than 2 datatype

[darren.james7518]

I am new to databases so this will probably be a dummy question!

I have Users who can create Events.
Users can mark certain Events to save to their Favourites.

I created a column for “yes/no” in the Events datatype.
The “save to favourites” button is set to add “yes” to the current event (see below)

and the “view my favourites” repeating group is set up as below:

I realised after setting this up that if one User adds an event to their favourites, ALL users will see the same favourited event! I am not sure how best to show a favourited event ONLY to a user who favourited it.

Do I need to create a new datatype and link them or something?

[robhblake]

Hey @darren.james7518 welcome aboard.

Instead of having a “favourite” field in “Events” you should have a “favourite events” field (list) in the “Users” table.

When a user favourites an event your workflow is:
Make change to a thing → current User → favourite events add this event

[darren.james7518]

Ah that makes perfect sense, thank you for that!