Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
For the # 2 question, I assume that you have a relationship where 1 Parent has many Children. Open up that relationship and on the left side you will see a button to make a summary field.
- MCFNeil9 years agoQrew Captain
- GeoffreyHarmuth9 years agoQrew CaptainThis works, but the field list is limited to what I assume are "numeric type fields". Is there any way to combine formula text fields from a child to a single field in the parent. example; I have a field on each job card for items used, I want to get all the items used accross all job cards and summarise in 1 field on the parent record
- MCFNeil9 years agoQrew CaptainCan you give some examples of the current set up you have and the information in the field you are looking to summarize? Maybe an example of what you want it to look like?
- GeoffreyHarmuth9 years agoQrew Captainsetup is as follows:
Parent table: Job
Child table: Job Cards (multiple job cards per job)
In the child table, there is a text field where the user lists the items seperated by a comma. I have a formula text field that takes the items and lists them below each other after each comma.
What I want to do:
1) Combine all the items together (accross many child records) - and show it on the parent record.
2) Create a summary report for these fields as well. - QuickBaseCoachD9 years agoQrew CaptainIt is possible to do a series of what are called reverse relationships to float up text values form a limited number of child records. In practical terms how many child records would you need to be able to handle?
- JoshuaNorton9 years agoQrew MemberHow do you create a reverse relationship? I'm having the same issue but my example is more like: "Parent table: Practice, Child table: Multiple Providers