Mapping Form To Specific Google Sheet

  • Profile Image
    buyrvaart
    Asked 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? 

  • Profile Image
    Mike_G
    Answered 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.