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 ************************************************** On Thu, Mar 24, 2011 at 5:14 PM, Jon <[email protected]> wrote: > 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. > > On Feb 9, 3:40 pm, martin <[email protected]> wrote: > > 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 > > -- > You received this message because you are subscribed to the Google Groups > "SIMILE Widgets" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/simile-widgets?hl=en. > > -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en.
