So, there is no way to do that kind of chart off the record itself. The only way to do this would be to go to the effort of making a trial table, which contains the individual choices, and then have a Pipeline maintain those child records.
of making a trial table, which contains the individual choices, and then have a Pipeline maintain those child records.
In general the pipeline with trigger when the main record, is that a bit and your multi select field changes. The way I would do, it would be to first delete all the child records so you know you are starting with a clean slate every time, and then I would copy all of the possible choices from a choices table to be children of the record, and then delete the ones which don't deserve to be there. The child records would have a lock off of the multi select field from the parent record and therefore it's possible to make a formula which would determine whether or not the record should be immediately deleted.
It might also possible to have the pipeline check each child record before being added to make sure it deserves to be there. That would be more efficient because it wouldn't be creating and then deleting unneeded records.
if you want to tackle that pipeline, and need some help, feel free to post back.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
