How best to consolidate personal calendars consolidated within different groups?

Hi, I am new to Bubble & have only been using it for the last few weeks. I believe I have learnt a lot of the basics but I need help on a key aspect of my app.

My plan is for individuals to have their own calendars, but their calendar will be shared with different groups who will also have their calendars shared only to the people in their groups.
So essentially:
Group 1:
Contains person A & B - A & B can see each others individual calendars in their shared group calendar (ideally with a privacy setting so the events just says “person A busy” but not essential)

Group 2:
Contains person A & C - A & C can see each others individual calendars in their shared group calendar, however person B & C won’t be able to see each others calendars unless they create a group together

So far I have installed the Air Calendar plug in as this has the Google sync which is also key & am still to work out. But I have been able to set up the individuals calendar, however I am unsure about the best way to go about the separate groups calendars. My plan was to set up an individual calendar database & a separate group database & have key links & syncs between them. However I am unsure if this is the best way to go about this as I am having issues trying to get the databases to sync up as I am still quite new to using Bubble & learning how if an event is added to one database this also changes in the group on.

I would appreciate any advice people could give me on how best to get this to work, or where I could get some resources to help me understand this myself as I have watched a lot of videos & resources to try to get this to work & I still can’t fully get it to work.

On calendar data type have field for user that is calendar owner and a field of group

1 Like

Thank you, I will give it a go & see if I can make it work