-
GCAmericaAsked 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.
-
John_BensonReplied 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.