How to make newest submissions show up at the top of the Google Sheet?

  • Profile Image
    GCAmerica
    Asked on August 12, 2019 at 11:15 AM

    Hi, I'd like new submissions to show up in the top row of my integrated Google Sheet rather than at the bottom.  Is that possible? Even if I sort the sheet it does not stay that way when a new submission comes in.

  • Profile Image
    John_Benson
    Answered on August 12, 2019 at 11:49 AM

    The normal behavior of our integration is to push the data to the integrated spreadsheet when a new submission comes in. Unfortunately, all new data will be at the bottom and not on the top. You can sort it by Submission Date (A-Z) in the actual sheets, however, you need to do this every time you open the spreadsheet.

    According to this post from one of our users, it is possible by running a custom script in Google Sheet. Here's the link to his post: https://www.jotform.com/answers/133139#609474.

    Please take note that the thread I've shared is an old one. Also, I haven't tested it if it will work or not.

    Thank you for your understanding.