+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Excel export missing data (/showthread.php?tid=791)
Excel export missing data - royalwise - Jul 23rd, 2010
Hi, Just installed FormTools and love it so far. I have a form with multiple checkboxes that I am collecting as an array and storing in one db field. When in PHPAdmin, I can see the contents as correct (i.e. 'a,b,c,d,e,f'), but when I use the Excel export feature, that field comes out as just a series of commas (i.e. ",,,,,,,") and corresponding letters are absent.
Any ideas?
Thanks,
~Jamie
Royalwise Solutions
RE: Excel export missing data - Ben - Jul 28th, 2010
Hey Jamie,
Excellent! Hope it continues to work out.
From what you described, it sounds like your Field Option Type doesn't have any corresponding display values.
Here's how it works. Form fields like radios and checkboxes typically have a value (value="...") and a label. The label is what is displayed to the user; the value is hidden.
Now, when you add a form to Form Tools for storage, the script can only figure out the values - not the labels. This is because labels for radios & checkboxes, the labels are outside of the element and could be anywhere in the markup. So when adding those field types to Form Tools, it won't figure out the labels - you have to manually enter them. But that isn't required, I don't think.
So! Long story short, go to the Field Option Groups page and hunt down the field group for your checkboxes (or you can find it by going to Edit Form -> Fields -> Options link -> Edit Field Option Group). On that page, confirm that there is something entered in the "Display Text" column for each value: that's what's used when outputting the contents of a field - not the values.
Whoah, that was kind of Explanation Overkill. Apologies.
- Ben