PROBLEM TO MERGE DOC AUTOMATICALLY

[BIKINCV MAHASISWA]

Hi, it seems autocrat can´t create via form trigger my PDF document wich uses data from a google forms. I still can generate them manually but I need to run it 24/7.

[Bart van Dalfsen]

Hi Bikincv,

In the GSheets menu under File - Settings you'll get a menu with an import second tab: Calculation

Here you can set for this specific spreadsheet what the specifid interval for Recalculation sshould be.

If it's configured to 'On change' you may from time to time encounter your issue of "manually working okay, automatically not".

Triggers can be delayed sometimes or may not even start if new results of your data have not been processed yet.

The larger a sheet becomes - sheets with a formresponse tab grow organically with every submitted form - the more time it will take before everything is recalculated.

Setting recalculation to hourly or for each minute can solve this problem.

If a trigger couldn't start now, it may in the next minute or hour.

Cheers, Bart