The number of Choices varies from 2 choices to 10 choices. These also may be updated in the future and more choices added.
Originally was trying to get a pie chart but a bar chart would also work.
Qrew LegendSo, 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.
Thanks Mark!
Is there a way to get any kind of useful chart out of the multi-select fields? I have not been able to get any good visualization of the data in the fields.
Seems like the multi-select field is probably not the field for this type of data collection. I was hoping there would be more useful charting built into this type of field because it makes the forms and tables much cleaner.
Qrew LegendThe only useful way to use multi select fields in a chart would be to make use of dynamic filters. There was a way to present the individual multi select choices as dynamic filters. But then the church only makes sense if you have selected one or more dynamic filters.
