How to Edit what data is sumbitted to Google Spreadsheet

  • trigrammaton
    Asked on June 28, 2016 at 4: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 -

     

    Jotform Thread 871408 Screenshot
  • David JotForm Support Manager
    Replied on June 28, 2016 at 5:38 PM

    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": 

    How to Edit what data is sumbitted to Google Spreadsheet Image 1 Screenshot 20

    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.