Quick way to translate checkbox items into different columns in Excel export?
When using Excel to deal with some FMP data, it is sometimes very helpful to easily and quickly sort by some checkbox items. However, this doesn't work too well with the standard Excel export because everything from one checkbox set comes out in one column. This means, you can't sort quickly and checkbox items that are checked can actually be in a different order, depending on when you checked them.
Does anyone have a suggestion for how to quickly convert the checkbox items into their columns in Excel?
I have thought about discontinuing the use of checkboxes (since it seems they were not made for this), but it would be such a pain to create separate fields for every option...
Thank you! (I am on FileMaker Pro 8)