How to add more number of users in the custom object record?

Question

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?

Answer 1

In attendees object create a lookup fields to user object and meeting object. Create a new button on meeting detail page to show visualforcepage in that you can listing list of users in multi select pick list. Then have a save button on your visualforce page, on save action you can create new attendees records that lookup with meeting object equivalent to selected users. So you have list of users under meeting object.