Help with Associating multiple contacts to a single event
I am creating a new app and I am struggling on setting up a feature request for our marketing team. The ask is this:
Create a way to utilize our database of account contacts with their associated name, email, and phone number on file so we can create a "guest list" for virtual events being planned and tracked in a QuickBase table. The idea is we would create a sales event in the events table and create a multi-select field or embedded report to select multiple contacts from multiple accounts to invite to this event.
I believe I need to do a many to many relationship between my tables of accounts, account contacts, and events to do this but I am struggling on getting the "select multiple contacts from multiple accounts in one drop down or report" where you search by the persons name in the events table and they get associated to the event.
Any help is appreciated
------------------------------
Joshua Case
------------------------------
Create a way to utilize our database of account contacts with their associated name, email, and phone number on file so we can create a "guest list" for virtual events being planned and tracked in a QuickBase table. The idea is we would create a sales event in the events table and create a multi-select field or embedded report to select multiple contacts from multiple accounts to invite to this event.
I believe I need to do a many to many relationship between my tables of accounts, account contacts, and events to do this but I am struggling on getting the "select multiple contacts from multiple accounts in one drop down or report" where you search by the persons name in the events table and they get associated to the event.
Any help is appreciated
------------------------------
Joshua Case
------------------------------
