form is not sync with the columns in table view

  • myhillals
    Asked on August 14, 2022 at 9:42 AM

    Why are the COLUMNS in the table view not following the sequence in the form?

    This wasn't a major problem before. Now it is such a hassle!

    I always need to fix the sequence of the COLUMNS in the table view when it should LOGICALLY and AUTOMATICALLY just follow how we laid out the fields in the form.

    Again, this was not an issue before :(

    What's happening JOTFORM? CHECK THIS FORM.

    https://form.jotform.com/221594888056469

  • Norwyn JotForm Support
    Replied on August 14, 2022 at 10:03 AM

    Hello Eliza,

    Thanks for reaching out to Jotform Support. Were the columns modified before this happened? Unfortunately, we do not have the option to automatically match the order on the form. In this case, you need to manually adjust the order on the Tables based on the form. Another option is to clone which will give you fresh Submissions/Tables that will have the columns in order the same as the form since the form does not have a submission yet. Here's a guide that will show you how to do that.

    Give it a try and reach out again if you need more help.

  • myhillals
    Replied on August 14, 2022 at 10:31 AM

    That is what I am doing and it is such a bane to resequence the columns because the drop down display is too short PLUS we could not move multiple columns but have to do it ONE AT A EFFIN TIME :(((


  • Marina_V
    Replied on August 14, 2022 at 10:59 AM

    Hello Eliza,

    Thanks for getting back to us. I understand how frustrating this is for you and I’ll do my best to help you. As my colleague suggested, we do not have the option to automatically match the order on the form. Please try cloning your form and see if that helps.

    Reach out again if you need any other help.



  • myhillals
    Replied on August 15, 2022 at 10:41 PM

    I realized that when updates are done to the form, the TABLE system does not update along with the form builder. So the solution is to clone the form again that will create a new table sheet.

    the problem with this is instead of making life easier for us, we now have the problem of consolidating different batches of form responses. this effect trickles into the google sheet attached to the form.

    i really hope your tech guys can create a deeper integration between the FORM BUILDER and the TABLE SPREADSHEET.

  • Finley JotForm Support
    Replied on August 16, 2022 at 3:03 AM

    Hi Eliza,

    Thanks for reaching out to Jotform Support. I cloned your form and tried to replicate the issue, but when I sent a dummy submission to the form, my table updated right away. Check out my results in the screencast below:

    1660633095 62fb40073fdcc GOS1 Screenshot 10

    Also, here's the Google Spreadsheet integrated with the cloned form:

    1660633265 62fb40b177207 GOS1 Screenshot 21

     Can you clone your form and test it to see if you're able to receive the data? Here's how to do that:

    • On your My Forms page, click on Create Form. After that, select Import Form.
    • Click on the From a Web Page option. Paste the URL of the form in the Enter URL field and then click on Create Form. That's it.

    1660115636 62f35ab463833 G1 Screenshot 32

    Can you give it another try and let us know what happens? If you're still having the same problem, we'll do a more in-depth investigation and work on finding a solution.

  • myhillals
    Replied on August 17, 2022 at 2:21 AM

    Yes I have already answered my problem. Didn't you read my message carefully before you replied?

    1660717305 62fc88f9b37f7  Screenshot 10

  • Raymond JotForm Support
    Replied on August 17, 2022 at 3:20 AM

    Hello Eliza,

     We're very sorry for your experience. So that we can understand the issue better, I made a test form on my end and added fields named "1", "2", and "3". I then made a test submission, then added new fields to the form. These new additions automatically reflected in my forms table. Please check out the screencast below for my results:

    1660720693 62fc963502874  Screenshot 10

    You may also consider checking out the Manage Columns option that can help you organize your table's column. Columns can also be hidden or shown from here.

    1660720804 62fc96a4b5c4e  Screenshot 21

    Reach out again if you need any help.

  • myhillals
    Replied on August 21, 2022 at 11:32 AM

    Ok thanks for this! Will do!