Can we create more column in google spreadsheet?

  • Profile Image
    ITU_contacts
    Asked on March 21, 2014 at 01:02 PM

    I created the form linked/connected with google spreadsheet but I need additional columns for "internal use".

    I created twice and it got deleted twice, please help me if I can add column, thanks.

  • Profile Image
    EltonCris
    Answered on March 21, 2014 at 03:42 PM

    Hi there!

    I would suggest not to do it on the same sheet where the submissions goes to avoid breaking the integration. The best way to make that possible is to create a separate sheet on the same spreadsheet and create the columns there. If you're going to create calculations or if you want to populate data to the new sheet you can use formula with the sheet name e.g. Submisions!A1:A5

    Hope this helps!

  • Profile Image
    ITU_contacts
    Answered on March 22, 2014 at 01:41 AM

    Thanks for your help.

  • Profile Image
    ITU_contacts
    Answered on March 25, 2014 at 03:16 PM

    Hello, 

    It does not work, I put the new spreadsheet and it got deleted automatically the next day, can you please help me so that we have data that stayed in the new spreadsheet, thanks.

  • Profile Image
    Welvin
    Answered on March 25, 2014 at 06:00 PM

    Did you delete the current sheet that is created by the form after the integration? Can you share it to us? We'd like to check how you've added the new sheet.

    We have a few users that is using this method and we don't receive a report from them. I tried it today, but the additional sheet is not deleted when new submission is added. 

    Thanks

  • Profile Image
    ITU_contacts
    Answered on March 26, 2014 at 04:43 PM

    Hello, 

    I attached the video file where I created the new spreadsheet and no I did not delete the form after the integration. Please let me know how you can help, thanks.

    I think the next day when i check it, the new spreadsheet disappeared.

    http://tinypic.com/r/211s0w3/8

    Please let me know if you have any questions. Thanks.

  • Profile Image
    Welvin
    Answered on March 26, 2014 at 06:22 PM

    What I mean is the Google Spreadsheet that is created by the form. Please share the link of the Google Spreadsheet so we can check it here. Also let us know the form URL so we can test it.

    Let me also explain further that when you create the new sheet, all submissions from the form will not automatically get copied to this new sheet NOT unless, you've added a formula that will make queries to the original sheet that captures the form submission.

    I tried it again and still, I'm not able to replicate the issue. You can test and check the following:

    Form URL: http://www.jotformpro.com/form/40846772466970

    Google Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AgEiJQf5QINCdHJ5eFhVSzZkbDhubEF0YXVEdkFGNlE#gid=0. On this spreadsheet, I've added the sheet called "Others". You are free to submit to the form and check the spreadsheet.

    Thanks