Autocrat Time Trigger is needed below 1 hours.

[Mehdi Naqvi]

Dear Autocrat Team,

Currently, I am facing an issue where documents are not being generated in real time. Since my Google Sheet recalculates regularly, the condition column takes time to update, which delays the document generation process.

Proposed Solution: If the time trigger could be set to run every 5 minutes, this issue would be resolved effectively.

You are kindly requested to look into this matter and do the needful, as we are completely reliant on your extension.

[Joseph Schmidt]

If the time trigger were set to 5 minutes, look at all of the jobs that would be delayed.

If the time trigger had an adjustable delay, then folks would have to figure out what to set it at.

If your spreadsheet is too complicated and you made it less complicated, then everybody wins.

For example.

If you had 500 rows and you wanted to find the return the data from 6 columns and used the following.

=iferror(vlookup(A2,'Pledges sorted by most recent on top'!A2:M,1,false))) would result in 

3000 figure out what to do and do it 3000 times.

=ArrayFormula(if(row(N:N)=1,{"comments"},iferror(vlookup(A:A,'Pledges sorted by most recent on top'!A2:M,1,false))))

6 figure out what to do and do it 3000 times.

=ArrayFormula(if(row(N:N)=1,{"comments","going the extra mile"},iferror(vlookup(A:A,'Pledges sorted by most recent on top'!A2:M,{1,2,,3,4,7,6},false))))

figure out what to do once, do the lookup 500 times and return 6 values each time.

Do you have extra rows in a sheet that are empty?

Do you have empty columns?

Do you have many rows that do longer apply?  Consider moving to a backup spreadsheet.

While computers have gotten faster, we tend to forget that an operation still takes time.  

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/89d0c224-d3ae-47b8-9d5c-854c2bb19b78n%40googlegroups.com.