Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Two thoughts
1. Have in the advanced properties tab for the payment record, which in this case is opportunities, it is always good practice to check the checkbox �Save parent record automatically when a child record is created�. That way at least when the user goes to add child it will automatically save the carriage.
2. But the bigger tip is to simply include an embedded report on the opportunities record of the children and the user can edit (create) those records directly while creating the parent record before having saved the Parent record. Be sure to make the embedded report editable in form properties. That means that when you edit the parent the embedded child report table a table goes into Grid edit mode.
1. Have in the advanced properties tab for the payment record, which in this case is opportunities, it is always good practice to check the checkbox �Save parent record automatically when a child record is created�. That way at least when the user goes to add child it will automatically save the carriage.
2. But the bigger tip is to simply include an embedded report on the opportunities record of the children and the user can edit (create) those records directly while creating the parent record before having saved the Parent record. Be sure to make the embedded report editable in form properties. That means that when you edit the parent the embedded child report table a table goes into Grid edit mode.
- MarkComish8 years agoQrew Assistant CaptainI am pretty new to QuickBase so I am not quite following your response. Do I need to create a new table that is the child to "Companies" "Contacts" and "Opportunities" and on the form for that new table have the fields I need to populate each parent table when saved? Hope I am making sense? Here are the fields I need populated in each Parent table...
Companies Table
1. Company Name
2. Account Type
3. Phone
4. Fax
5. Mailing address
Contacts Table
1. Salutation
2. First name
3. Last Name
4. Preferred first name
5. Title
6. Credentials
7. Contact type
8. Direct phone
9. email
Opportunities Table
1. Service
2. Stage
3. Year
4. Status
5. Type
6. Opportunity Value
7. # of days per visit
8. # of visits per year
When I create the fields for the new table do I use the "From another table" as input type? Sorry for all the questions but I am confused how to do this and need details or if there is a better way to do this.
Thanks in advance! - QuickBaseCoachD8 years agoQrew CaptainYou do not need any new tables.
Presumably you have a relationship where 1 Company has Many Contacts and 1 Company has many Opportunities.
If you really want to have the initial setup all on one form, then you would put the field probably called [Contacts] on you customer form and set the form properties to display the records on the form and further set the form properties to allow them to be editable. You would make a report of the fields you want to show, and use that on the form for that Report Link field.
Post back if you are still stuck or if you prefer, you can contact me via my website QuickBaseCoach.com for some one one one assistance to get you unstuck. - MarkComish8 years agoQrew Assistant CaptainI know there was at least one other person that wanted something like this so it would be nice to post a solution here.
Can I get step by step? Do I go into the "Companies Table" settings and create a new form? So confused as to where I start and how I create this report to just have the fields I detailed. Plus when saved all the tables be updated. Plus how this form and or report will allow me to enter new data as many of the fields are drop downs.
I think if I can get an outline of the steps I could fill in the gaps, hopefully. - QuickBaseCoachD8 years agoQrew Captain... it's a lot of typing to explain every click. There are excellent videos on learning Quick Base at Quick Base University https://university.quickbase.com/
Some times Quick Base support will give a certain amount of help to users who just recently signed up, but they are really trying not to be in the business of building apps. (Same as Microsoft is not really in the business of building your excel spreadsheets).
The ? at the top of the screen takes you to Help and Manage Support cases if you want to try Quick Base Support. Or an hour or two invested with a QSP (Quick Base Solution Provider) like myself or these https://www.quickbase.com/partners/find-a-partner can go a long way to getting you started.