form is not sync with the columns in table view

  • Profile Image
    myhillals
    Asked on August 14, 2022 at 09: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

  • Profile Image
    Norwyn
    Answered 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.

  • Profile Image
    myhillals
    Answered 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 :(((


  • Profile Image
    Marina
    Answered 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.



  • Profile Image
    myhillals
    Answered 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.

  • Profile Image
    Fenryr
    Answered on August 16, 2022 at 03: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.gif

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

    1660633265_62fb40b177207_GOS1.png

     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.gif

    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.

  • Profile Image
    myhillals
    Answered on August 17, 2022 at 02:21 AM

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

    1660717305_62fc88f9b37f7_

  • Profile Image
    Raymond
    Answered on August 17, 2022 at 03: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_

    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_

    Reach out again if you need any help.

  • Profile Image
    myhillals
    Answered on August 21, 2022 at 11:32 AM

    Ok thanks for this! Will do!