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.


  • Profile Image

    Can't see fields in submissions even though they are on form

    Asked by hartmutgunther 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

    https://toxno.com.au/assess.html

     

    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  "

     

    Please help

     

    Thanks

     

    Page URL:
    https://toxno.com.au/assess.html

    Submissions excel long form site checked
  • Profile Image
    JotForm Support

    Answered by Kiran 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.

  • Profile Image

    Answered by hartmutgunther 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

    Thanks

  • Profile Image
    JotForm Support

    Answered by Kiran 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.

  • Profile Image

    Answered by hartmutgunther on July 28, 2014 at 03:13 AM

    Thanks Kiran.

    Appreciate your response.

     

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 28, 2014 at 05:44 AM

    Hello hartmutgunther,

    On behalf of my colleague, you are welcome.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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.

    Kind regards

  • Profile Image

    Answered by hartmutgunther 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.

     

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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.

    Thanks

  • Profile Image

    Answered by hartmutgunther 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.

     

    thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on July 29, 2014 at 05:16 AM

    Hi Gunther,

    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?

  • Profile Image

    Answered by hartmutgunther 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??

     

    thanks

  • Profile Image

    Answered by jedcadorna on July 29, 2014 at 07:50 AM

    Hello,

    Your message has reached my colleague and will update you via this thread once he is available. Thank you for your patience.

  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 02:45 AM

    Any further progress on this issue??

     

    thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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.

    Best

  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 03:01 AM
    Thanks Alp.
    ...
  • Profile Image
    JotForm Support

    Answered by alp_deniz on July 31, 2014 at 03:24 AM

    Hello again,

    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?

  • Profile Image

    Answered by hartmutgunther 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.

  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 03:30 AM

    That is the 1000 field mark.

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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.

    Thanks!

     

  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 04:11 AM
    I just tried it again and same thing happening. Attached are the excel and csv files
    thanks
    Hartmut
    ...
  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 04:38 AM

    Any luck Alp

  • Profile Image
    JotForm Support

    Answered by alp_deniz on July 31, 2014 at 05:08 AM

    Hello,

    We are now trying to replicate the issue with different settings and browsers.. This might take some time.

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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?

    https://shots.jotform.com/welvin/userfile/ToxNo(2014-07-31%2019_03_15).xlsx

  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 05:41 AM
    Its 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
    thanks
    Hartmut
    ...
  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 05:51 AM
    I 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
    https://www.toxno.com.au/assess.html
    particularly the fields at the end and see what happens.
    thanks
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin 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.

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on July 31, 2014 at 06:49 AM

    I'm sorry, please disregard my last message. I'll do some test now. Thanks

  • Profile Image

    Answered by hartmutgunther on July 31, 2014 at 06:51 AM
    No 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
    thanks
    ...
  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 31, 2014 at 07:34 AM

    Hello hartmutgunther,

    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.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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.

    Kind regards

  • Profile Image

    Answered by hartmutgunther on August 02, 2014 at 05:41 AM
    Thanks 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.
    ...
  • Profile Image
    JotForm Support

    Answered by Welvin 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.

    I think it's a nature that speed will affect long forms since a few functions (Javascripts and all other server files) needs to be loaded first before the form will be properly rendered to the page. But note that we always make sure that our servers can handle such huge files. But sometimes, you will experience a delay since our servers process your request first before it becomes available.

    Thank you!

  • Profile Image
    JotForm Support

    Answered by alp_deniz 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.

    Kind regards