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

    Mapping Form To Specific Google Sheet

    Asked by buyrvaart on May 29, 2015 at 01:20 PM

    Hello, 

    I am trying to create a form that my customers can fill out that will map exactly to a predetermined spreadsheet. Currently when we sync it adds other information about when it was submitted etc.

    We need control over two things.

    -control over the column titles so they match the preexisting system. 

    -the ability to drop certain items to a new row in the  spreadsheet

     

    Is anything like this currently possible? 

    mapping sheet create a form create fill map
  • Profile Image
    JotForm Support

    Answered by Mike_G on May 29, 2015 at 02:50 PM

    I understand what you mean, however, renaming the column names would only result to data input being skipped so it will just be blank on the google sheet because it already has a different name from the field name on the form. (Please check the image below)

    As for removing a column on the sheet, I believe that it is possible. I was able to make a submission transferred to google sheet after deleting some of its columns. The image below shows a fourth submission without the Submission date column.

    However, I would still recommend for you to just create a new spreadsheet that will match your preexisting system and just gather data from the google sheet integrated with your form. 

    I hope this helps. Let us know if you have any other questions. Thank you.