What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is there a limit to the columns on google spreadheets?Asked by radanza on May 28, 2014 at 03:02 PM
I have a super long grant application, some of the fields are not making it into the google spreadsheet. I have 7 sections but the spreadsheet ends somwhere in the middle of section 5.
Yes, and that's 256 columns per sheet. More info: https://support.google.com/drive/answer/37603?hl=en
Actually this isn't it, because I can export manually. I suspect that it has to do with similar column names(Another post commented that this caused data not to populate to google forms).
I suspect that it has to do with similar column names(Another post commented that this caused data not to populate to google forms).
That is correct. If form field have same label names, chances are it will fail to transfer into the google spreadsheet on integration.
Since the column name of the generated spreadsheet uses the field labels/names, similarly name fields will overwrite each other in the spreadsheet -- making it appear that only the last column name is working.
To correct this, do not use same field labels/names in the form that is going to be integrated to Google spreadsheet.