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.
How to Edit what data is sumbitted to Google SpreadsheetAsked by trigrammaton on June 28, 2016 at 04:58 PM
Hi I am having trouble controlling the data sent in my google spreadsheet integration. I would delete some of the categories from submission and also combine the First and Last name cells into one cell.
I want to remove the IP category, and Submission ID among others.
Here is my form -https://form.jotform.com/61795076754165
how to edit how JotForm name submission id div
If you want to combine first and last name cells, simply delete your name field, and replaced it for native text box which you can label as "Full name":
If you do edits into the spreadsheet, the integration will break. I would recommend you to pull data from the integrated spreadsheet to a new spreadsheet by using IMPORTRANGE, and then customize the new one as you want to.
Let us know if you need more help, we will be glad to assist you.