Merging Document with pictures takes too long (only one document merged)

[Ideias Web]

Hello everyone and thanks for creating this group!

I'm using autoCrat to merge a document that can have up to 36 pictures per document.

The user uploads pictures but only when it needs.

The spreadsheet have 270 collumns configured in order to include all text, classification, pictures uploaded and links associated.

With this configuration I can only merge one document at once.

Is there any away to speed up merging using these number of columns and pictures?

Appreciate your feecback.

Thank you very much

Best Regards

[Joe Schmidt]

Can the template be a spreadsheet?

Do you output a spreadsheet or a PDF?

I'm working with another user on a process that seems to be working.  

Insert a column in the sheet that contains the data for the merge and put this formula in row one.  =ArrayFormula(if(row(B:B)=1,"row",row(B:B)))  That will assign a row number to each row.

In the spreadsheet template, create a sheet that had the titles that are the same as your data sheet. You might want to name this sheet "data".

In cell a2 of Data sheet insert this formula,  

=filter(importrange("Link to data spreadsheet","FormResponses1!b2:nr"),importrange("Link to data spreadsheet","FormResponses1!a2:a")=row!A2) You need to change the "Link to the spreadsheet and the other fields as needed.

In another sheet named "row" in the template, put a merge tag <<row>>. This is the only merge tag used in Autocrat.

In your template, create your Report sheet using assignments statements to pull data from the Data Sheet, row two.

=data!B2 Use the Image Function to pull in the image file. =image(data!x2)

How all of this works. When you set up the Autocrat merge you only use the merge tag <<row>>.

Autocrat will make a copy of the template.

The importrange and filter statement will pull the data from the source to the new spreadsheet but only for the single row.

You want to have the folder for the output to be "anyone with the link". This prevents needing to "allow" the connection between the two spreadsheets.

You want to hide the Data and Row sheets so the user only sees the Report part of the template.

I created a very small example folder

Submit a form here if you want to help test the process.

Joe Schmidt

 

[Ideias Web]

Hi @Joe Schmidt I'm very happy for your help and quick response.

I'm merging documents to output in GDocs or PDF but for now, in GDocs because I know that with PDF takes longer (conversion time).

As for as know it's very smart your example so I thank you very much for this.

I will give it a go!

Thanks for sharing this.

Best,

Ideias Web