Two Jobs for the same Google Sheet

[Kam Spoto]

Hello,

I have set up two jobs in Autocrat for form responses stored in the same Google Sheet. Two separate forms are used because the generated document templates differ based on a specific response:

1. If someone answers NO to a certain question, Autocrat uses a full template (1st job).
2. If someone answers YES, Autocrat uses an abbreviated template (2nd job).

To manage the generated files, I use a Google Script that automatically organizes them into a specific designated folder. This script is necessary because Autocrat doesn’t allow files to be stored in a shared drive directly.

The issue arises when I run the second Autocrat job after the first one. Autocrat creates 4 new columns (Merged Doc ID, URL, Link to Merged Doc, and Status) for the second job. Since my script relies on links from a specific column to store the files, the links from the second job are in different columns, and the files aren't being saved correctly.

My question is:

• Is there a way to configure Autocrat so that both jobs use the same set of columns for their output (e.g., overwrite or append to the same Merged Doc ID, URL, etc., columns)?
• Or does Autocrat require that each job generate its own set of 4 columns?

If a solution exists to align the output columns between jobs, I’d appreciate guidance on how to implement it. 

Thank you

[Joseph Schmidt]

Each merge job will create its own set of columns as you have found out.

I don't know of anyway around this.  You could modify your script to look in the correct place depending on the Yes/No question.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
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/179db0cc-be9a-4b44-bc19-be3727ee296bn%40googlegroups.com.

[Roger Banister]

Hi

Cant have multiple merge jobs on a single sheet

I have worked around this by using one sheet for each merge and then using importrange(....) (in G Sheets)  to copy relevant columns between the sheets so the results of each merge can be easily used in the others.

Best wishes

Roger

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOTKi2mJ_GxT_yJpg86XN0nFa3Oph-_VaoTOn3x2F-JOeg%40mail.gmail.com.

[Joseph Schmidt]

You can have multiple merge jobs on the same sheet.  My issue with the merge not being on the responses sheet is that if someone deletes a row from the responses sheet, they must move the status columns in the sheet with the importrange so the data lines up appropriately.

I don't understand the need for two forms when the Yes/No question to branch to the appropriate section of one form.

If the information would be in the same sheet, they could add some formulas to combine the status columns into a new single set of columns.

I'd have to see the script and know more about the project to suggest a solution.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CACfS0z7BQ_5SGsbin_hcaO%3DtwiC2H4DoHxbOd29T3yuNUqeM9Q%40mail.gmail.com.