Can I enter an activity - say a workshop I've hosted and spoken for - and then connect multiple contacts to that activity? Is this possible?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I"m a new user - so thanks for your patience with me!  I'd like to not have to re-enter all the company and contact information each time I add an activity for a whole group of them.  For instance - I'd like to indicate that 100+ people attended a presentation I recently gave... but I can't figure out how to simply add the contacts (with their companies) TO that activity.  What am I missing?

Photo of Carmen

Carmen

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
Can you explain a bit more about the Tables you have and how they are currently related.  Like One xxx has Many yyy's?
Photo of Carmen

Carmen

  • 0 Points
I have only three tables:  Companies, Contacts, and Activities.  I use this as a general CRM database, so I'd like to be able to not have to enter the address & related info for companies AND contacts, I'd like to be able to add one activity & then link several contacts to it, etc.  Again - I'm not tech savvy, and don't really know what I"m doing here! :-)  I didn't create this database, so I'm kinda flying blind.

From my table-to-table relationships tab:
One Activity has many Companies
Each Company has many Contacts

Does this help?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
Are you looking to actually "take attendance" ie to see a list of say 100 contacts at a Company and indicate which of them attended the Presentation?  Or  are you looking to simply indicate that you did a Presentation at Company XYZ and all the contacts at that company were deemed to have attended?
Photo of Carmen

Carmen

  • 0 Points
Thanks for your response.  I need to log this presentation as an Activity for each attendee (Contact).  Trying to NOT have to re-enter the details of this Activity 100 times.  Seems like I should be able to enter the presentation as an Activity, and then link 100 Contacts to it.  I just can't figure out how.  Appreciate your help!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
To actually create 100 Activity records quickly is possible to do, but you would need to contact me off line for help setting that up.  I think that the design of your tables and their relationships will need to be adjusted.

I tnink that it will need to be something like this

One Company has Many Contacts
One Contact has Many WorkShop Attendances.  ie indicating that a particular Contact attended a particular session of a Workshop.
One Workshop Session has many Workshop Attendances
One Workshop has many WorkShop Sessions (ie the same basic course is probably run on different dates.)

You may want to have a button which automatically creates the detailed 100 WorkShop Attendances for all Contacts at a company, and then you would just adjust those 100 for say a few people who missed that session due to illness or travel commitments.  Alternatively, you will need to create those 100 Workshop Attendance records manually.
Photo of Mike Ruoppoli

Mike Ruoppoli

  • 64 Points
I have something similar i am trying to accomplish.
Tables and relationships
Accounts with many Contacts
Accounts with many Sales Activities
Contacts with Many Sales Activities.

I would like to have a Contact pick list when adding a new Sales Activity (ie sales meeting) to an Account . Like selecting all of the contacts that were in a meeting.

Suggestions?

Thanks
Mike
Photo of oliver mah

oliver mah

  • 930 Points 500 badge 2x thumb
I am trying to do the exact same thing.  Has anybody shed further light on this?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
I have a way to allow you to select a course, and then be presented with a list of contacts.  Then just click on each contact who attended and it will make an attendance record for that contact.

The setup for this usually takes me an hour to 1.5 hours to do, depending on how much training you want to understand my technique.  Contact me off line if you want help setting this up in our app.

QuickBaseCoach.com