Google Sheet Integration: Inserting rows when adding submission information

  • buildingpicks
    Asked on June 11, 2020 at 5:51 PM

    Hi. I have an integration between my form and Google Sheets and rows are automatically inserted with the information from the forms every time a submission happens. Is there any way to have the information filled on the existing rows instead of inserting rows? I have another tab with formulas that pulls information from the tab that's automatically filled and the inserted rows are causing problems. I hope I'm making sense. Thanks!

  • Jed_C
    Replied on June 11, 2020 at 8:57 PM

    No, it will always insert a new row every new submission. The only workaround is to use formulas on another sheet.

    Guide: https://support.google.com/a/users/answer/9308940?hl=en

  • buildingpicks
    Replied on June 11, 2020 at 9:01 PM

    I'm actually using formulas on another tab but since this tab is referencing the tab where the lines are inserted the formulas get messed up every time a new row is added which means I have to copy/paste formulas all the time - not very convenient. So there's no way to tix this not even on your side?

  • Jed_C
    Replied on June 11, 2020 at 10:28 PM

    Yes, there's no settings in Jotform's integration that allows you to control where the data will be inserted. It will always create and insert a new row every submission.