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

  • Profile Image
    malcantara619
    Asked on November 15, 2017 at 05: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. 

  • Profile Image
    Marvih
    Answered on November 15, 2017 at 07: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?

    1510791510657.png

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

    We will wait for your response.

  • Profile Image
    malcantara619
    Answered on November 15, 2017 at 07: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?

  • Profile Image
    Kiran
    Answered on November 15, 2017 at 09: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!