- hartmutguntherAsked on July 27, 2014 at 03:48 AM
Hi I just finished a fairly long form. Everything was working until now
Both the email that shows the fields submitted AND the submission via excel are incomplete i.e. cut of at a certain point.
I do have many fields on my form. Is there some limit. I noticed that when I go into the submission area it is painfully slow to load.
The form and all the fields however show up on my site
Also I have checked the sum mission email setup and it seems ok - contains all fields
I also keep getting message ERROR " #CaVb5fxs3BxVEbI"
The Submissions only go to " Personal Care - Sub Category Eye Care "
- JotForm SupportKiranAnswered on July 27, 2014 at 01:21 PM
I have cloned the form and tested. Since the form is longer and contains more number of fields, it is taking some time to render the page by the browser. Also, as I submit my cloned form I was able to receive the submissions upto 1000 fields i.e., upto Groundwater exposed to CSG activity | Water | 442 - Duration.
I would suggest to breakdown the form in to different forms as much as you can and to setup Custom Thank you page to continue with the next forms.
Hope this information helps. I am also forwarding the issue to our next level to look into this issue. You'll be notified as soon as we get an update on this issue.
Please get back to us if you need further assistance. We are happy to assist you.
- hartmutguntherAnswered on July 27, 2014 at 11:41 PM
Thanks for the response.
The whole point of this long form was to use the edit link feature and as can be seen my form design and flow relies on this feature for this long form.
However so I can decide where to go from here I need a lot more clarity. I spent a lot of time working on this long form in the last few weeks only to hit this brick wall just as it was done.
What I need to know is
1/ What are the limits for the jot form fields.
2/ Does the form just not work as you go beyond these limits (as is my case) and is performance degraded both for the user and the developer (also in my case)
3/ Has my form been corrupted. I can still see it on the site but the submissions are not working properly at all.
Please could you let me know what is happening either way as soon as possible
- JotForm SupportKiranAnswered on July 28, 2014 at 03:11 AM
I do understand that the features you are looking into and the time you have spent to build such a long form. To answer your questions :
1. As I aware there are no restrictions on the fields. Since we observed that we are not able to download the data more than 1000 fields, I have escalated this issue with our next level support. They'll be coming up with a solution at the earliest possible.
2. This could not be the issue with JotForm. The performance of the form slows down due to the number of fields in the form and the processing time by the browser to display.
3. I don't think the form is corrupted since I am able to clone it and work on it normally.
I request you to bear with us for a while, since our development team is already working on this. You'll be receiving an update on this thread very soon.
- hartmutguntherAnswered on July 28, 2014 at 03:13 AM
Appreciate your response.
- JotForm Supportashwin_dAnswered on July 28, 2014 at 05:44 AM
On behalf of my colleague, you are welcome.
Do get back to us if you have any questions.
- alp_denizAnswered on July 29, 2014 at 04:16 AM
Hello Mr. Gunther,
Excel export maximum column limit was set to 676 and is now increased to 2048 in accordance with your request. You should now be able to export your excel file with all of the submission data.
About the emails, I realized that email providers (like gmail) truncate the email since it is too long, however, redirects to a page for a full view.
Please let us know if the issue still persists.
- hartmutguntherAnswered on July 29, 2014 at 04:52 AM
Thanks a lot Alp. Will give it a try.
Just as a matter of interest does that mean everyone can now export 2048 column or just me.
Also do you mean the notification emails? Thanks for the heads up but the email is not that important to me.
I do a lot of post processing of the excel data, so that is what counts.
Thanks again and will keep you posted.
- alp_denizAnswered on July 29, 2014 at 04:55 AM
Everyone can export maximum 2048 columns per excel file. Please let us know about the issue, your feedback is very much appreciated.
- hartmutguntherAnswered on July 29, 2014 at 05:00 AM
Thanks Alp. While you are there ... is there any way we can make the download/export of the excel file a little more automated or at least streamlined.
What would be optimal would be the ability to log in via secure ftp and get a download of the excel file.
That way we can automate the download at the user end i.e several times per day.
- alp_denizAnswered on July 29, 2014 at 05:16 AM
You can always use JotForm's report feature to export your excel files. When report feature is used, the excel file gets cached and can be served very quickly and easily. The reports, by their design, are public and they can be secured with a password. Do you think it is applicable in your case?
- hartmutguntherAnswered on July 29, 2014 at 05:25 AM
Thanks Alp. Will look into that.
I have just tested my form.
Looks like all fields (1111) are coming through HOWEVER the same problem as before is still there .... the data from the fields stops at about field 1003 ... Any ideas ... the field is called Indoor Heated Swimming pools. In other words the field name is coming through but NOT the associated data after field 1003??
- jedcadornaAnswered on July 29, 2014 at 07:50 AM
Your message has reached my colleague and will update you via this thread once he is available. Thank you for your patience.
- hartmutguntherAnswered on July 31, 2014 at 02:45 AM
Any further progress on this issue??
- alp_denizAnswered on July 31, 2014 at 02:51 AM
Hello Mr. Gunther,
I was just re-studying the issue again. I will update here as soon as I can.
- hartmutguntherAnswered on July 31, 2014 at 03:01 AMThanks Alp.
- alp_denizAnswered on July 31, 2014 at 03:24 AM
I have checked your form and I was able to get all of the fields until the column APT (~1135 fields) in google spreadsheets. However, ubuntu's LibreOffice and OpenOffice has 1024 limit when displaying excel files. Older versionss of Microsoft Excel may well have this limit.
Which program do you have to view the excel files? Can the issue be related to it?
- hartmutguntherAnswered on July 31, 2014 at 03:28 AM
This is not an issue of showing the fields. However ONLY all the fields NAMES are there but NOT the content - after a certain point. Around the 10000 foiled mark. Try it out. The CSV file - which is a basic text file - is the same.
- hartmutguntherAnswered on July 31, 2014 at 03:30 AM
That is the 1000 field mark.
- alp_denizAnswered on July 31, 2014 at 03:51 AM
I can see that only one submission is fully filled in and it extends to ~1130th column. The other submissions, though, they are not filled until over 1000th column, so do not show up.
As far as I checked they are consistent with submission data. Please review.
- hartmutguntherAnswered on July 31, 2014 at 04:11 AMI just tried it again and same thing happening. Attached are the excel and csv files
- hartmutguntherAnswered on July 31, 2014 at 04:38 AM
Any luck Alp
- alp_denizAnswered on July 31, 2014 at 05:08 AM
We are now trying to replicate the issue with different settings and browsers.. This might take some time.
- alp_denizAnswered on July 31, 2014 at 05:17 AM
Hello Mr. Gunther,
We ran some tests with my colleague and they resulted as expected. So I will be attaching the file we generated, could you please check that file?
- hartmutguntherAnswered on July 31, 2014 at 05:41 AMIts the same problem, the fields are there but the last lot of data is missing.
I will delete all submissions and do a fresh filled in form and let you know. Will take a few minutes
- hartmutguntherAnswered on July 31, 2014 at 05:51 AMI just updated the notification form and deleted all previous submissions and it STILL doing the same thing. When I go into edit link the first lot of fields are there filled in but not the last lot.
The data is just not being saved towards the end of the form.
Try filling in the form on the website
particularly the fields at the end and see what happens.
- JotForm SupportWelvinAnswered on July 31, 2014 at 06:46 AM
I'm sorry, but I'm confused now. The original issue is that the Excel File doesn't contain all the data that was submitted to the form, particularly after 1000th column. BUT it seems that the issue is now related to the form notification which is working fine as you have mentioned on your original posting, and then to the EDIT LINK as well.
Can you please tell us if this is a new issue or still, you mean, the excel file? I have downloaded your form submission and all data are there.
- JotForm SupportWelvinAnswered on July 31, 2014 at 06:49 AM
I'm sorry, please disregard my last message. I'll do some test now. Thanks
- hartmutguntherAnswered on July 31, 2014 at 06:51 AMNo it is the same issue. The data is NOT there.
Please try and fill in the form yourself, particularly the fields near the end, submit the form and look at the resulting excel submission.
As mentioned the data STOPS at the field " Indoor heated swimming pool | Water | 445 - intensity
- JotForm Supportashwin_dAnswered on July 31, 2014 at 07:34 AM
Your message has reached my colleagues and they will take a look at the issue again.
I will also do my test by doing a test submission and exporting the submission in excel. As you have a long form, it may take some time but we will get back to you on this.
- alp_denizAnswered on August 02, 2014 at 05:26 AM
Ok. I looked into the issue and come across some server limits on number of form variables posted. So I will have to make a deeper investigation, followed by a discussion in order to fully and securely resolve this issue.
Please stand by. I am going to update here as soon as I can.
- hartmutguntherAnswered on August 02, 2014 at 05:41 AMThanks Alp. Much appreciated. In your discussions can you also please help resolve what would be the OPTIMAL limit for for amount of fields in a form. Meaning that there is a balance between number (of fields) and performance. What is that point
i.e. how far can we push the amount of fields we use before performance - both for the form administrator (me) AND the client/User of the form.
This would be really good to know.
With my large form as it is at the moment, the time delay while trying to download the CSV/excel files is cumbersome to say the least.
thanks for your help.
- JotForm SupportWelvinAnswered on August 02, 2014 at 09:34 AM
We don't have a limit based on a number of fields you can add to a form. However, if you are concern about the speed, we advise to divide the fields into two or three separate forms. You have almost 1500 fields in your ToxNo Form.
- alp_denizAnswered on August 05, 2014 at 12:38 AM
Hello Mr. Gunther,
We discussed with our Chief Technical about the limit and it concluded that 1000 variable limit is an optimized result of previous research and development, which ensures security and usability of JotForm. So it would be acceptable to say that you can freely use a form when its question count is under 1000, around 900 maximum to be sure of its performance and integrity.
Thank you for your understanding. Please let us know if we can assist you further.