UseCase: There is custom object called Business Meeting with the fields start time, end time, Date, Subject. In this I also want to add users who are all attending the business meeting while creating new meeting record.
Workaround solution 1: Created a lookup on the custom object called Attendees, But we can add only one user as attendee per meeting record.
Workaround solution 2: Tried to create lookup on the user object so that we can related list on the Business meeting. But we cant create lookup relationship on the user object.
Workaround Solution 3: Tried using the event object as it has an inbuilt feature of adding an attendees. But attendees cant be added in the lightning experience view which can be added only using lightning sync. Our company has security restrictions with lightning sync.
Could you please provide a solution to this to add multiple users in the record who are all attending the meeting?