google spreadsheet form and commas

[martin]

Using a google spreadsheet with a form for input to populate the
spreadsheet that is providing data for exhibit I find that when I use
the "checkbox" form field which enables a simple selecting of choices,
it will insert the choices separated with a comma, however the field
values need to separated with semi colons.
has anyone come across this and is there something I can do to make
this work?
Thanks for any help...
Martin

[Jon]

I use a separate form for submissions that I approve by cleaning up
and moving over. This prevents your live datasource from much mucky
data and lets you monitor it pretty closely.

[John Callahan]

You could also create a new field that is a copy of the checkbox field but replaces commas with semi-colons.  Google Docs should have a string replace function. You can do cleanup work as well.  I believe I've done this in the past by reformatting date columns.

- John

**************************************************
John Callahan, Research Scientist
Delaware Geological Survey, University of Delaware
URL: http://www.dgs.udel.edu
**************************************************

--
You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group.
To post to this group, send email to simile-...@googlegroups.com.
To unsubscribe from this group, send email to simile-widget...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en.

[Jay Wherley]

i use a 2nd sheet to "clone" over data from the submitted form and do a
little clean up / translation on it.
a formula in the 2nd sheet something like:
=ARRAYFORMULA(IF(ISNUMBER(FIND("Yes", SubmittedData!E2:E)); "✓"; ""))
clones a continuous column with some translation (in this case changing a Yes to a check mark).
you should be able to do something similar to change commas to semi-colons.

jay w.