tonyrampedi / php-form-builder-class

Automatically exported from code.google.com/p/php-form-builder-class
0 stars 0 forks source link

Google Spreadsheets - Textbox contents not posted if space in textbox name #76

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago

1. Name a textbox like "First Name" and it will not post the contents to google 
spreadsheet rename to FirstName and it works.

2. Radio Button names with spaces works as expected.

Version: 1.1.2

Original issue reported on code.google.com by neoncs...@gmail.com on 16 Oct 2010 at 11:59

GoogleCodeExporter commented 9 years ago
Paul,

I wasn't able to re-create this error.  When you say "Name a textbox", are you 
referring to the element's label or name parameter?  The element's label is 
what is used to decide which column to populate in your spreadsheet.

Can you provide me with more information about the specific steps you took to 
produce this issue?  This will help me know more about your scenario.  For 
instance...

1.  Copy and paste your addTextbox function.
2.  Are you creating a spreadsheet manually in docs.google.com, or are you 
letting this project create one when the first form submission is made?
3.  What are the specific column headers of your spreadsheet?

- Andrew

Original comment by ajporterfield@gmail.com on 16 Oct 2010 at 1:52

GoogleCodeExporter commented 9 years ago
I was using the following:

$form->addTextbox("Safety Comments", "Safety Comments");

It would not create the Column Automatically in Google Docs.

So I manually added the Column with header Safety Comments.

Then posted the form again with comments in the text box but still nothing 
appeared in spreadsheet.

I renamed to $form->addTextbox("SafetyComments", "SafetyComments");

and the corresponsing column header to the same SafetyComments and it posted 
fine.

Hope this helps

Original comment by neoncs...@gmail.com on 16 Oct 2010 at 2:07

GoogleCodeExporter commented 9 years ago
Ok, this helps.  Thanks for providing more information.

1.  The only time columns are created in your Google Spreadsheet is if you're 
specifying a spreadsheet title that doesn't exists.  When this happens, the 
project will create a new spreadsheet with the appropriate title and columns.  
If a spreadsheet already exists, new columns will not be added automatically by 
the project.

2.  The first parameter of the addTextbox function - label - is what is used to 
match a spreadsheet's column header.  Spaces and non-supported characters will 
be automatically removed by the project.  This means that "Safety Comments" and 
"SafetyComments" should both map to "SafetyComments".

3.  The textbox's name (the second parameter of the addTextbox function) 
shouldn't have spaces.  This may or may not affect the project's spreadsheet 
functionality.  It's more of a "best practices" thing.

- Andrew

Original comment by ajporterfield@gmail.com on 16 Oct 2010 at 2:53

GoogleCodeExporter commented 9 years ago

Original comment by ajporterfield@gmail.com on 8 Nov 2010 at 4:05