JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Mapping Form To Specific Google SheetAsked by buyrvaart on May 29, 2015 at 01:20 PM
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?
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.