What is JotForm?
JotForm is a free online 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.
Google Spreadsheet: New submissions goes on top of the header when you hide a column.Asked by Graham Price on December 04, 2016 at 06:30 PM
Okay, make a simple form and integrate it with google
make a post
look at google form and hide the first column
make a post
look at google and it has posted this above the header
to restore the new submissions to the bottom, simply unhide the first column
Although not recommended by jotform and as I know, you can in fact change alignment and a few other things in the google sheet without it crashing.
And as long as you don't hide any columns it seems to be okay with the few tests i have conducted.
As mentioned on the other thread, I was able to reproduce this.
Please do not make any changes on the integrated sheet for now as our devs will look into this and provide you some insights.
Wow, I almost feel like a tech myself. At least I found out where the problem originates from and you were able to produce it yourself.
Thanks for the idea of creating a copy on sheet 2. Look like a solution for the moment.
I have just tried your idea, but I'm afraid it does not work that well.
Yes you can copy from sheet 1 to sheet 2, and continue the equation in the blank spaces of sheet 2 for new submissions to show as and when they arrive to sheet 1. But as you can see in the examples, if you make a new submission, the line of this new submission gets deleted from the equations in sheet 2. Look at the reference top left. It says 25, but it is actually 24 as in sheet1.
Good fun this eh?
I made some tests on my end and I can confirm that when I made a new submission, the line of this new submission does not appear from the equations in sheet 2.
However, I've also found out that dragging the first cell to the rest of the cells again should display the submission correctly. So if you receive a new submission again, you can drag the formula to make the latest submission visible in the second Sheet.
You can also try this other workaround using ImportRange, which you can use to copy the data of the Integrated Sheet into an entirely new spreadsheet. You can check out this guide on How To Import Data From Other Google Spreadsheets
If you need further assistance, please let us know.
Yes of course if you reinstall the equations across the sheet 2, then they will be back and a direct copy, but this is totally unworkable as the results get published for my clients and need to be up to the minute accurate. Can't wait for me to keep going back and forth. Silly.
I shall read the How to import thingy, so thanks for your help.
I understand that you need the spreadsheet to update automatically instead of having to edit it constantly. Perhaps the ImportRange function will be more suitable for your requirement. If you do encounter any issues or need further assistance, please let us know.
There's something quite sexy about a spreadsheet solution that actually works. (or is it just me,..don't answer that.
The IMPORTRANGE function works like a treat, and you can hide whatever you like and format whatever you like. A brilliant workaround Christian, thank you so much.
I'm now off to see if I can make it crash with a little bit of fiddling. I hope I don't succeed.
Hidden column problem should be fixed now. Please test it and let us know if issue still persists.
Fixed. Thank you