Google spreadsheet integration: Ability to insert the new submission to the first row

  • malcantara619
    Asked on November 15, 2017 at 5:08 PM

    My latest submission are uploading at the bottom of my sheets, I want them to import to the top, could you please help, the build url is provided below. 

  • Marvih
    Replied on November 15, 2017 at 7:19 PM

    Can you take a screenshot of your google spreadsheet since I don't have access to it.

    https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

    Is this the issue you are referring to?

    Google spreadsheet integration: Ability to insert the new submission to the first row Image 10

    Please confirm so we can escalate this to our backend team.

    We will wait for your response.

  • malcantara619
    Replied on November 15, 2017 at 7:26 PM

    New submission are entering my google sheet at the bottom and I have to sort it to go to the top, is there a way to have this corrected so the new submissions come in at the top?

  • Kiran Support Team Lead
    Replied on November 15, 2017 at 9:51 PM

    Unfortunately, Google spreadsheet integration doesn't have an option to insert the new submission to the top of the sheet. You may consider creating a new sheet on the same spreadsheet to copy the contents using QUERY function and perform additional tasks like sorting, filtering etc.

    Let me also forward the thread to our backend team as a feature request for evaluation. We cannot guarantee that the feature will be implemented or cannot provide any ETA at this moment. However, if there is any update in this regard you'll be posted here.

    Thank you!