Forum Discussion
Can you give us a little more detail? Are you saying that there is a parent record and then it has 32 children, and some of those children have a checkbox, and you want to roll up a Summary all of the names of the children which either have or do not have a checkbox?
- MaritzaAcosta7 months agoQrew Trainee
Yes. There is a parent record and it has 32 children checkmark fields
- MarkShnier__You7 months ago
Qrew Legend
OK, np,
Just go to the relationship or one parent has many children and create a Combined Text Summary field of all of the tasks which are incomplete. So set the filter for that summary field perhaps some checkbox field that is unchecked.
If you observe the field that is now created on the parent it will have a bubble like appearance which I personally dislike.
If you want to make a nice vertical list that looks better on a report, you can them make a new sumamry tect ield lke this
SearchAndReplace(ToText([My combined text summary field]), " ; ", "\n")
Or if you just want them to appear as comma separated but not vertical.
SearchAndReplace(ToText([My combined text summary field]), " ; ", ", ")
- MaritzaAcosta7 months agoQrew Trainee
I apologize, I don't think I understood it right. There is only one table with no relationship as its a standalone. a single record has multiple checkmark fields and I want a summary of only a group of fields. Here's a visual on how the individual record looks like and how the reports look like. Do i have to make a relationship from the table to its self? in order to get a summary field of all checked concerns?