Yes. There is a parent record and it has 32 children checkmark fields
Qrew LegendOK, 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]), " ; ", ", ")
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?
