Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
A far better way is simply to create a Combined text summary field on the relationship to summarize up all the certification names from the child tale up to the parent.
- RusselNdip6 years agoQrew TraineeThe reason I wanted to try and avoid this method is that I need that field to still be a dynamic filter, and I've noticed that summery text fields don't have that ability.
- QuickBaseCoachD6 years agoQrew CaptainYou can make a new field to use as a DF.
ToText([my combined Summary text field]) - RusselNdip6 years agoQrew TraineeThanks you! this helps!
- RusselNdip6 years agoQrew TraineeHaving done this method, the dynamic filter lists all the possible values instead of each values separately. For example
1. US ; Mexico
2. US
3. Mexico
unlike the filter for a regular multi-select field that would just list US and Mexico separately whether or not a record had both values selected. Is there a way to fix that? - QuickBaseCoachD6 years agoQrew Captainno, you would need to use the filter box to search or else search at the detail level - the child table instead.