18 views
Skip to first unread message
Erin Hommeland
Sep 15, 2025, 11:46:31 PM (6 days ago) Sep 15
to nv-autocr...@googlegroups.com
Hello! I've been using Autocrat for at least two decades, and have never had any issues. All of my jobs are set as "manual."
I've noticed for awhile now when new forms are submitted, info from the last row is copied into the rows for the new forms. This happens across all of my forms and into all of my sheets.
Because all of my jobs have been manual, I just delete the copied info, add my condition (a "y" in a column I name "Run") and I get exactly what I need.
Now, I'd like to have Autocrat run when a new form is submitted, but I know that if there is data in the "merge" columns, I won't get a new report.
Does anyone know why this data copies into rows for new forms and how I might be able to stop it? I'd really like to give this form trigger a try!
Thanks in advance for any advice or troubleshooting tips.
---------------------------------------------
Erin Hommeland
AAIC | Director of Professional Services
Joseph Schmidt
Sep 16, 2025, 12:13:21 AM (6 days ago) Sep 16
to nv-autocr...@googlegroups.com
I don't know how many forms you have and it is strange that the error is occurring on all of them.
My best guess is that Autocrat has lost track of where the last row is.
This can happen when a row of data is deleted and the following data is moved up. You should always delete the entire row.
For one of the forms, select a new destination for the responses. It can be in the same spreadsheet.
If the number of rows don't match, you might have found the problem.
Created the merge job pointing to the new response sheet.
If the old response have fewer rows and the status columns are correct, you can copy and paste the old information on top of the new information.
Delete any extra rows in the new sheet and submit a test form.
You may want to set the form to not allow form submissions before you begin and back on before you test.
If the old response sheet has more rows than the new sheet, it means that someone manually added a row.
Let me know if the new response sheet is less than the old response sheet.
Let me know if you have any questions.
--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAKsGjXVexxu9fFfqDpKErSoCeP_8VwB6Ay8xPp2yHANRvaOnjQ%40mail.gmail.com.
Erin Hommeland
Sep 16, 2025, 12:59:32 PM (5 days ago) Sep 16
to nv-autocr...@googlegroups.com
Thanks for this information, Joe. Over the last two decades, I've lost count of how many forms/autocrat reports I've created.
When deleting in the spreadsheet, we definitely delete the entire row.
We also have manually added rows to some spreadsheets, but not all. I'm not sure we can avoid this practice, but I'll use this information as a starting point.
I appreciate this information because it absolutely gives me a starting point for determining our next steps.
---------------------------------------------
Erin Hommeland
AAIC | Director of Professional Services
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOS_a_HDemkq3JgaBv1mfe9q8JiCAA_QjrL_bpcYavUejg%40mail.gmail.com.
Joseph Schmidt
Sep 16, 2025, 1:23:29 PM (5 days ago) Sep 16
to nv-autocr...@googlegroups.com
When you insert a row, do it in the middle of the rows. Do not add it to the bottom of the sheet.
So if you start with a new response sheet, insert enough rows so that there is room for all of the rows from the old response sheet. Insert the rows above the last row.
You should be able to copy the old to the new and then deleted any unneeded rows.
Insert or delete rows from the middle of the new response sheet so the last row doesn't change when you copy and paste from the old sheet.
In the future, when you need to add a row, consider doing it via the form. That way, should you ever have to recover from the responses sheet, the data will be there. If you have to delete a row, do it in the sheet and in the form. That way the two should stay in sync.
I hope this helps.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAKsGjXVSKatRpb46QHwVehdeZ4KyVOMLhDUahhcBeDz9kjW2Mw%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages