Google Spreadsheet: New submissions goes on top of the header when you hide a column.

  • Profile Image
    Graham Price
    Asked on December 04, 2016 at 06:30 PM

    Okay, make a simple form and integrate it with google

    make a post

    manke another

    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.

  • Profile Image
    EltonCris
    Answered on December 04, 2016 at 06:56 PM

    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.

    Thank you!

  • Profile Image
    graham1370
    Answered on December 04, 2016 at 06:59 PM

    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.

    Thanks Elton

  • Profile Image
    graham1370
    Answered on December 04, 2016 at 07:21 PM

    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?

  • Profile Image
    Chriistian
    Answered on December 04, 2016 at 08:45 PM

    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.
    Regards.

  • Profile Image
    graham1370
    Answered on December 04, 2016 at 10:03 PM

    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.

  • Profile Image
    Chriistian
    Answered on December 04, 2016 at 10:43 PM

    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.
    Thank you.

  • Profile Image
    graham1370
    Answered on December 04, 2016 at 11:18 PM

    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.

     

  • Profile Image
    Denis
    Answered on December 06, 2016 at 05:08 AM

    Hello,

    Hidden column problem should be fixed now. Please test it and let us know if issue still persists. 

    Thanks.

  • Profile Image
    graham1370
    Answered on December 06, 2016 at 04:56 PM

    Fixed. Thank you