You have 2 things, a Google form that someone submits, and a spreadsheet that stores all the responses.
Because we're using pre-filled links, we also have a sheet in our spreadsheet with our reliable information. That's 2 sheets, probably labeled "start here," or maybe "links," and another called "Form Responses."
We send out progress reports, etc., each quarter. Wouldn't it be nice if we didn't have to redo the pre-filled links and the form? And we wouldn't have to redo the autoCrat script?
Here's an easy way to do it:
Unlink form
Hide sheet
View hidden sheet
On the spreadsheet that is now linked to the form, there are at least two sheets--the original sheet and one that will receive the responses from the recycled form.
Under the add-ons menu of the new sheet, open AutoCrat. Go to step 3, "Map Source Data to Template." Use the drop-down menu to change the "Merge tab" to the name of the new sheet.
I like to add a formula for the date =A2-INT(A2). I use copyDown to post that to each row.
This will require you to fix the first data row to row 5, not row 3.
Change "Merge tab" to the name of the new sheet.