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

    Extra columns in a spreadsheet...

    Asked by jenloch on July 22, 2014 at 05:05 PM

    When integrated with Google Spreadsheets, I want the form data to enter into the correct columns in the spreadsheet, but I also want to add other columns to that same spreadsheet for our internal use. For instance these are customers creating a Return Merchandise Authorization and I want to add a column to record if/when we've received their returned item. Can I add other columns in the spreadsheet and will it still work correctly, or will the form data not enter into the spreadsheet correctly if I do that?

    Page URL:
    http://www.jotform.us/jenloch/jenclothing

    form data integrated same and
  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on July 22, 2014 at 11:43 PM

    I just made some test too see if it won't brake the integration, and as far as I can see, it doesn't

    So, it should work with no problem

  • Profile Image

    Answered by jenloch on July 23, 2014 at 03:37 PM

    I created a test form to test it, and it is not working. Once I added a new column as the first column and submitted the form again, the submissions are not going into the form now.

  • Profile Image
    JotForm Support

    Answered by david on July 23, 2014 at 04:42 PM

    Hi,

    As my colleague stated, it does break the integration, but it could be causing errors when trying to forward the data when it finds a new field in the spreadsheet where it expected a different one.  I would try removing and re-doing the integration once the spreadsheet is fully setup.  If this still does not work, please let us know and we will be happy to look into this further.

    Thank you for using Jotform!