- manjulapraAsked on August 12, 2012 at 11:26 PM
What is the maximum number of fields per form?
I have a form with about ~900 fields. Which is devided to 2 pages. The page looks grate. Thanks. But when I submit it with data, some of the data gets truncated. Only some data is submitted to the Google spreadsheet with only some columns are there. Jotform submission viwer does not show the submissions, but sometime it can be seen with by pressing "Larger grid". Even though I can't see the data at the submission page, I can download the Excel file, but again some data is missing. How can I rectify this?
Again If I want to make two forms out of this, Can I split one form to two?
Thanks in advance.
- JotForm SupportNeilVicenteAnswered on August 13, 2012 at 09:33 AM
Based on my observation, your form should be okay. Having that many fields in a form should not affect the way data is recorded.
We would like to help you with this, but we need more information to solve this problem in the quickest time possible.
Can you please specify the columns wherein data is being truncated? Your form has quite a lot of fields, so comparing the submissions page against your form to find out which data is omitted can take some time to finish.
Also, I think it would be great if you can share to us your form's Google Docs spreadsheet. I have set this thread to private mode so you don't have to worry about your data's privacy.
- manjulapraAnswered on August 16, 2012 at 03:22 AM
Thank you. Sorry for the delay. Here is the link to my google doc
I downloaded the Excel from jotform site. I noted that both Excel and Google doc looks similer in terms where the columns gets trancated. But The grid in Jotform shows all the fields. I am sorry I do not have much test data, and every form will not have all fields filled also.
- JotForm SupportNeilVicenteAnswered on August 16, 2012 at 04:58 AM
After doing some research, I found out that spreadsheet applications such as Excel and Google Docs have a 256 column limit.
JotForm's grid displays all your fields because it is not limited in any way - it uses html tables to display data fetched from an SQL database. SQL can handle up to thousands of columns, that's why all questions are recorded.
I'm afraid that with your current form setup, ther would be now way to export all data onto a spreadsheet.
Try creating a grid listing report for your form instead, so data can be accessed without logging in to your JotForm account.
- manjulapraAnswered on August 22, 2012 at 12:37 AM
Thank you very much. Now there are two problems. One is that I have about 8 submissions and about 3 new ones. When I go to submissions page I do not see any of the submissions (but I can see "3 NEW" when I log in), and when I press large grid, which I used to do, then also I can not see any submissions. But Download to Excel gives me data (just as previously). But when I press Doanload asd CSV, nothing happens. If I can download as CSV, I might import it in to database. I tried creating a grid list. It also does not show any results. Only a blank grid. But I was able to create a CSV report and IT WORKED. I imported to Excel and, somehow it SHOWS upto the last field. I am still looking whether any fields are missing.
I will be grateful if you can help me with this.
Thank you again
- fxrAnswered on August 22, 2012 at 05:07 AM
I have had a look at your submissions, I think the problem may be with the spreadsheet package rather than your data on JotForm.
There is definately some kind of odd problem happening, I tried opening your submissions and importing the CSV in both Excel & OpenOffice Calc with no success.
As you have alluded to you could consider breaking up your form into 2.
To do this:
1. First design your first form with half of your questions.
2. Change the label of the Submit button to 'Next'.
3. Then create a 2nd form with your 2nd half of questions.
4. Obtain the URL of the 2nd form.
( In my example its : http://form.jotformeu.com/form/22341808254349 )
5. Back in the 1st form, use the URL of the 2nd form as the Custom URL of a Thankyou Page.
You can my example form(s) here