I discovered that text fields <input type="text"> and <textarea>
fields will appear as empty cells in the spreadsheet. This is good.
But if a checkbox, radio button, or select/option list is left blank,
the columns for those names/fields are omitted from the spreadsheet,
and the data will not line up vertically.
My workaround is to always pre-check a radio button entry, so the
visitor MUST fill out something. This may require a "None of the
above" option.
Checkboxes will have to be re-coded as selections with a Yes/No radio
button choice, of course with one of them pre-checked.
Never use a select/option list, use radio buttons instead.
Or, if you must use checkboxes or a select/option list, list it last
in your sort element:
<input type="hidden" name="sort" value="order:alpha, bravo, charlie" /
>
This is a very small price to pay for a terrific free script.
I'd still love to see this designed with the more traditional header
row in the spreadsheet.
Thanks for a great script.