Forum Discussion
- QuickBaseCoachDQrew CaptainCan you explain a bit more about the Tables you have and how they are currently related. Like One xxx has Many yyy's?
- CarmenCarmenQrew MemberI 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? - QuickBaseCoachDQrew CaptainAre 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?
- CarmenCarmenQrew MemberThanks 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!
- QuickBaseCoachDQrew CaptainTo 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.- MikeRuoppoliQrew MemberI 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 - olivermahQrew Assistant CaptainI am trying to do the exact same thing. Has anybody shed further light on this?
- QuickBaseCoachDQrew CaptainI 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