What is JotForm?
JotForm is a freeonline form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

Why do you not want to answer this thread?(Your answer will be sent to Jeanette and Aytekin)

Can we create more column in google spreadsheet?

Asked by
ITU_contacts
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.

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!

Answered by
ITU_contacts
on March 22, 2014 at 01:41 AM

Thanks for your help.

Answered by
ITU_contacts
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.

JotForm Support

Answered by
Welvin
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

Answered by
ITU_contacts
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.

JotForm Support

Answered by
Welvin
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: