How do I stop autoCrat from re-merging the same data every time it runs?

shh22 · 09-28-2023 10:00 AM

I have Autocrat set up using Google Forms set up with a form trigger.

Everytime a new form submission is created, it sends the new submission along with ALL previously submitted entries. Is there a way to set the trigger to only send the new submission rather than it repeatedly sending all the old PLUS the new?

b_gorsky1

In the Google Sheet, when you install Autocrat, it sets up a few columns including a Status column. Once Autocrat runs a job, it should put some data in there. So long as that is happening as it should, it should not be re-merging those completed rows.

From the Autocrat FAQ:

How do I stop autoCrat from re-merging the same data every time it runs?

By default, autoCrat will NOT re-merge any data that has already been merged. Each time autoCrat runs, it will first look to the status column for the given merge job. If this column has any text in it at all, that row will be skipped.

See also https://docs.google.com/document/d/1WTGSSlH6gwUHpipusPKLIsgfFUamDbFbJ7JaoG6-ZBo/edit#heading=h.bb8f4...

View solution in original post

Autocrat triggers

How do I stop autoCrat from re-merging the same data every time it runs?