0

If I have a spreadsheet that already contains data, but then I want to add new form responses to it, then Google Forms puts them at the top[1], not at the bottom.

My question is how can I use onFormSubmit() to immediately move the new row into the end of the worksheet? Not the responses must be editable so I can't use cosmetics tricks like putting =SORT() in another worksheet[2].

It's a bit similar to How can an apps-script on a Form store extra data into the Sheet? but not the same (I wish to move the entire row, not store extra information).

LWC
  • 928
  • 1
  • 8
  • 26
  • Hi, by any chance does this (https://stackoverflow.com/questions/66994691/how-to-move-a-row-to-bottom-of-sheet-google-sheet-when-status-is-changed-to) solve your question? Instead of using `e.range.getRow` you could use it as the example on [getRow](https://developers.google.com/apps-script/reference/spreadsheet/range#getrow) – Kessy Jan 20 '22 at 12:19

0 Answers0