Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
The only way to do this will be to Auto create child records matching the Multi select checkboxes.
You would create a child record to hold these and do the chart off the child table.
The Automation would trigger when the parent is edited or added and that multi select field changed.
The Automation would delete all the existing children.
Then add nine new children
then delete children not needed. It would have a formula field on the children which would compare a lookup of the multi select field to the record to detect if the child was legitimate and should stay or be deleted.
You would create a child record to hold these and do the chart off the child table.
The Automation would trigger when the parent is edited or added and that multi select field changed.
The Automation would delete all the existing children.
Then add nine new children
then delete children not needed. It would have a formula field on the children which would compare a lookup of the multi select field to the record to detect if the child was legitimate and should stay or be deleted.