Create PDF with updated information

Robert Lucas

unread,

Apr 15, 2019, 12:41:12 PM4/15/19

to NV Autocrat Add-on

I have a scholarship application form that students have the capability of editing. The form asks for a lot of information that students don't always have at their fingertips, so they fill out what they can, then come back to edit the application. I have autoCrat triggered upon completion of the form and creates a nice PDF of the application. The problem I'm having is that if I run the job manually, after corrections / updates have been made, autoCrat only gives the original information, not the updated information that I see in G. Sheets. Is there ANYWAY I can get a pdf of the updated information? Unfortunately, we're under a deadline.

Thank you in advance for your assistance!

Amanda Smith

unread,

Apr 15, 2019, 12:53:23 PM4/15/19

to NV Autocrat Add-on

Hi Robert,

You will need to clear the success message text from the 'Merge Status' Columns. ( Autocrat will not run a row if there is text in the 'Merge Status' cells)

Our wonderful moderator Joe has created a script for your exact purpose of running new merges when data in the sheet is updated.

See his post here: https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!topic/nv-autocrat-add-on/sokUD5tY1OE

Robert Lucas

unread,

Apr 15, 2019, 4:04:44 PM4/15/19

to nv-autocr...@googlegroups.com

Thank you! I've copied the script and made the changes in the script associated with my columns (columns 71-74). I submitted a new application and Autocrat was able to create the PDF. However, when I made a revision, it did not produce the updated information. I'm not sure what I'm doing wrong.

Thanks.

Robert Lucas

TOSA - Educational Technology Coach

----------------------------------------

--
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/a9551dca-f5f4-45e0-b740-95338fb26832%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Joseph Schmidt

unread,

Apr 15, 2019, 5:46:47 PM4/15/19

to nv-autocr...@googlegroups.com

Did you remember to set the triggers for the script? Watch the video. Look at the creation time for the document. I'm guessing that it is the old document.

Joe Schmidt

GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CA%2BqcNCwRT8YvvvxZbrhYvW2rRu91rriYF%2B8s%2Be0i49%2B8A4V5LQ%40mail.gmail.com.

Robert Lucas

unread,

Apr 15, 2019, 7:19:48 PM4/15/19

to nv-autocr...@googlegroups.com

Thank you, Joe. Yes, I did set the trigger. I did miss that I needed to create both triggers. I created the 'on form submit' and it seemed to work. I still haven't seen job run on the 'on edit'. Should that not be instantaneous, as well? Here are screenshots of my script and triggers. Obviously I'm missing something.

Screen Shot 2019-04-15 at 4.15.49 PM.png

Thanks, again, for your assistance.

Robert Lucas

TOSA - Educational Technology Coach

----------------------------------------

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

Joseph Schmidt

unread,

Apr 15, 2019, 8:50:46 PM4/15/19

to nv-autocr...@googlegroups.com

With both triggers set, the form trigger should cause the status to be erased and then autocrat should immediately run. For the direct edit, the status columns should be erased and Autocrat run on the next Form or Time trigger whichever happens first.

Joe Schmidt

GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

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

Wim van Koppenhagen

unread,

Apr 16, 2019, 7:32:04 AM4/16/19

to NV Autocrat Add-on

The columnEdited must be the cells that will be changed not the cells from the Autocrat cells. The rowEdited are the cells that must be cleared when there's a edit on the columnEdited cells.

I hope you understand what i'm try to explain.

Op maandag 15 april 2019 18:41:12 UTC+2 schreef Robert Lucas:

Geizy Alves

unread,

Apr 22, 2019, 10:08:51 AM4/22/19

to NV Autocrat Add-on

Hello, I had the same problem, is there any update that can be made to resolve?

Em segunda-feira, 15 de abril de 2019 20:19:48 UTC-3, Robert Lucas escreveu:

Thank you, Joe. Yes, I did set the trigger. I did miss that I needed to create both triggers. I created the 'on form submit' and it seemed to work. I still haven't seen job run on the 'on edit'. Should that not be instantaneous, as well? Here are screenshots of my script and triggers. Obviously I'm missing something.

Thanks, again, for your assistance.

Robert Lucas
TOSA - Educational Technology Coach
----------------------------------------

On Mon, Apr 15, 2019 at 2:46 PM Joseph Schmidt <glu...@gmail.com> wrote:

Did you remember to set the triggers for the script? Watch the video. Look at the creation time for the document. I'm guessing that it is the old document.

Joe Schmidt

GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Mon, Apr 15, 2019 at 4:04 PM Robert Lucas <rlu...@chehalisschools.org> wrote:

Thank you! I've copied the script and made the changes in the script associated with my columns (columns 71-74). I submitted a new application and Autocrat was able to create the PDF. However, when I made a revision, it did not produce the updated information. I'm not sure what I'm doing wrong.

Thanks.

Robert Lucas
TOSA - Educational Technology Coach
----------------------------------------

On Mon, Apr 15, 2019 at 9:53 AM Amanda Smith <asm...@newvisions.org> wrote:

Hi Robert,

You will need to clear the success message text from the 'Merge Status' Columns. ( Autocrat will not run a row if there is text in the 'Merge Status' cells)
Our wonderful moderator Joe has created a script for your exact purpose of running new merges when data in the sheet is updated.
See his post here: https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!topic/nv-autocrat-add-on/sokUD5tY1OE

On Monday, April 15, 2019 at 12:41:12 PM UTC-4, Robert Lucas wrote:

I have a scholarship application form that students have the capability of editing. The form asks for a lot of information that students don't always have at their fingertips, so they fill out what they can, then come back to edit the application. I have autoCrat triggered upon completion of the form and creates a nice PDF of the application. The problem I'm having is that if I run the job manually, after corrections / updates have been made, autoCrat only gives the original information, not the updated information that I see in G. Sheets. Is there ANYWAY I can get a pdf of the updated information? Unfortunately, we're under a deadline.

Thank you in advance for your assistance!

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/a9551dca-f5f4-45e0-b740-95338fb26832%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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.

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CA%2BqcNCwRT8YvvvxZbrhYvW2rRu91rriYF%2B8s%2Be0i49%2B8A4V5LQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

--
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.

Joe Schmidt

unread,

Apr 22, 2019, 11:03:26 AM4/22/19

to NV Autocrat Add-on

Can you be specific as to what is not working? If you watch the video you should see that there must be changes to rows 15 to 19 of the script to adjust for where the columns are that you want to delete and which sheet the script should use.

Geizy Alves

unread,

Apr 22, 2019, 11:30:32 AM4/22/19

to NV Autocrat Add-on

Hello Joe, thanks for the reply!

I made these changes in the same way as Robert Lucas and it happened the same, when I edit the form response the trigger works, but when I edit directly in the worksheet it does not work, even though I made the two triggers, one for each occasion.

Joe Schmidt

unread,

Apr 22, 2019, 1:09:24 PM4/22/19

to NV Autocrat Add-on

The script will only clear the status columns for Autocrat. The script does not cause Autocrat to run.

If Autocrat is set to run on a Form Trigger, a submission via an Edit URL will cause Autocrat to run immediately after the status columns have been deleted.

For changes made inside the spreadsheet, Autocrat will run on the next event which can be a change via a Form, a Time trigger, or manually being run.

I hope this helps.

Geizy Alves

unread,

Apr 22, 2019, 2:28:37 PM4/22/19

to NV Autocrat Add-on

Thank you very much for your attention, I hope that the creator of Autocrat has a way to make it work automatically after editing directly in the spreadsheet.

Reply all

Reply to author

Forward