-
buildingpicksAsked 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!
Page URL: https://form.jotform.com/201403977557057 -
Jed_CReplied 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
-
buildingpicksReplied 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_CReplied 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.