I am using autocrat to create documents based off input from my google form. I have autocrat running on a timestamp = NOT NULL trigger. When the form response tab in google sheets is populated it automatically creates my documents and gives me the google document within the response sheet that I can print off for my students. Here is my issue I am using this as a high school discipline referral and tracking system and streamlining the amount of paperwork that I have to make and send home. If I fill out the form the documents are what I need them to be since I have access to all of the necessary sections within the form that autocrat calls on for filling in the documents. If a teacher uses the referral google form (which they only have access to one section) because of the timestamp = NOT NULL trigger is triggered when the teacher submits the form the documents are created WITHOUT all of the necessary information that gets pulled from the sections that the teacher does not have access to (thus these documents are not complete and not what I need to send home). When a teacher submits the referral I get an email notifying that I need to meet with the student, discuss the issue, and usually provide consequences. I then go into the form (using an edit url) and choose my sections and fill out the additional information for the situation. Once I am done making these edits I want autocrat to regenerate the documents and populate them with this new information. Is this possible? The only way that I have found to do this is to create a checkbox column on my form response tab and set an autocrat trigger that ColumnA = TRUE, and then run autocrat from the extensions after I check the box of the rows that I want to run the merge on. I would rather this step of having to go to Extensions--> Autocrat --> Run be removed from the process if possible.
0 Answers
Related