AutoCrat: Can you set it to run on specific rows and not others OR does it always do the entire spreadsheet

2,410 views
Skip to first unread message

Kirsten Dexter

unread,
Apr 25, 2019, 9:05:04 AM4/25/19
to NV Autocrat Add-on
AutoCrat: Can you set it to run on specific rows and not others OR does it always do the entire spreadsheet

glua...@gmail.com

unread,
Apr 25, 2019, 9:41:34 AM4/25/19
to NV Autocrat Add-on
You can set conditions by checking for NULL, NOT NULL, or a specific value in a column.  You set this in step 7.  

You can use a formula to calculate the value if you have a complex set of conditions.  Use Arrayformula or CopyDown to have the formula on new responses.

Also, Autocrat will not run for any rows that are not blank in the status column.

Kirsten Dexter

unread,
Apr 28, 2019, 4:33:09 PM4/28/19
to NV Autocrat Add-on
If you do this, can you then set the trigger....meaning it automatically runs when someone submits and the column I set the conditions for apply. When I manually run it only does the ones where I set the condition to say yes in a specific column.  If I now set to run on a trigger, will it still only run when they submit and column says yes?

Joseph Schmidt

unread,
Apr 28, 2019, 5:59:19 PM4/28/19
to nv-autocr...@googlegroups.com
No matter how Autocrat runs, it will follow the filters.  You can use a Form Trigger or Time Trigger.



--
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 on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/d1a288a8-1ecd-4d76-b8d6-732307451c34%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Kirsten Dexter

unread,
Apr 28, 2019, 7:32:09 PM4/28/19
to nv-autocr...@googlegroups.com
Just want to make sure I have this right before I mess up everything for my science department.  Under the filter, I selected that when I manually run autocrat, then ONLY the submissions with the word yes in a designated column one receive the google doc.  If I select either type of trigger, it will run when the designated column says yes and NOT before?

Kirsten Dexter, M.Ed.
Science Department Chair

Biology & BRVGS AP Biology Instructor
William Monroe High School
434-939-9004

Education is not the filling of a pail, but the lighting of a fire. W. B. Yeats


To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQv-YCyH96OF2heaZLZC3ctnZpu3eNKH%2ByPxVgWkC26Rg%40mail.gmail.com.

glua...@gmail.com

unread,
Apr 28, 2019, 7:39:09 PM4/28/19
to NV Autocrat Add-on
If you are concerned, create a test Form and spreadsheet.  When Autocrat runs via a manual, Form trigger, or Time Trigger, it looks at all of the rows and only those that have the status column blank and meets the condition of the filter are used in the merge.


On Sunday, April 28, 2019 at 7:32:09 PM UTC-4, Kirsten Dexter wrote:
Just want to make sure I have this right before I mess up everything for my science department.  Under the filter, I selected that when I manually run autocrat, then ONLY the submissions with the word yes in a designated column one receive the google doc.  If I select either type of trigger, it will run when the designated column says yes and NOT before?

Kirsten Dexter, M.Ed.
Science Department Chair

Biology & BRVGS AP Biology Instructor
William Monroe High School
434-939-9004

Education is not the filling of a pail, but the lighting of a fire. W. B. Yeats


On Sun, Apr 28, 2019 at 5:59 PM Joseph Schmidt <glua...@gmail.com> wrote:
No matter how Autocrat runs, it will follow the filters.  You can use a Form Trigger or Time Trigger.



On Sun, Apr 28, 2019 at 4:33 PM Kirsten Dexter <kde...@brvgs.k12.va.us> wrote:
If you do this, can you then set the trigger....meaning it automatically runs when someone submits and the column I set the conditions for apply. When I manually run it only does the ones where I set the condition to say yes in a specific column.  If I now set to run on a trigger, will it still only run when they submit and column says yes?

On Thursday, April 25, 2019 at 9:41:34 AM UTC-4, glu...@gmail.com wrote:
You can set conditions by checking for NULL, NOT NULL, or a specific value in a column.  You set this in step 7.  

You can use a formula to calculate the value if you have a complex set of conditions.  Use Arrayformula or CopyDown to have the formula on new responses.

Also, Autocrat will not run for any rows that are not blank in the status column.


On Thursday, April 25, 2019 at 9:05:04 AM UTC-4, Kirsten Dexter wrote:
AutoCrat: Can you set it to run on specific rows and not others OR does it always do the entire spreadsheet

--
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-on+unsub...@googlegroups.com.

--
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-on+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages