Temp Inhouse alternative to Autocrat

[Francisco Cortes]

If you're not afraid of tinkering with google apps scripts on your google sheets where you have autocrat installed, or even if your are but wouldn't mind asking AI for assistance
I vibe-coded this autocrat inhouse replacement that at a basic level will allow you to merge some table fields from a worksheet into a pdf document (that's it)

https://github.com/fcortesjp/Document_Merger

I started using this for the time being myself, (working ok so far)
there might be other tools out there but just wanted to provide an option if someone would like to explore it and adapt it while we get our beloved autocrat back.

Cheers

[TVDA Dance USA]

Hi, Mr. Cortes:

Thanks for your scripts.

I got this  Error: Document is missing (perhaps it was deleted, or you don't have read access?)

why need both CODIGO  AÑO  , do I need to input the pdf name in those two columns?

• A column named exactly CODIGO. (use to name the pdf file being created)
• A column named exactly AÑO. (use to name the pdf file being created)

Thanks for your help.

Linda

[Francisco Cortes]

Hi

makesure you set up you Setup worksheet accordingly, see below 
That error means that the template (master doc) you are using is a document that you don't have access to or it's simply not anymore which could happen if youd don't have an id or the correct id in you setup tab.
also, in your setup worksheet make sure you enter the correct document id, which the string of characters in the document url
https://docs.google.com/document/d/this the document id/edit?tab=t.0

you don't need the CODIGO and AÑO fields, I do because I use those in my doc merger becuase I want the pdf that is created to include those values in the name of the pdf and I also use CODIGO as one of the values that I merged into the resulting pdf.

you could possible modify this portion of the script, or simply copy my script to google ai studio and just tell google what you'd like to change and the result simply copy it back to you google apps script

--
You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/qnorfSeuVFU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/59386e49-1efc-4897-9c52-15a223f66c31n%40googlegroups.com.

--

Francisco Cortes
Administrador de Red
Instituto Copesal

[Francisco Cortes]

Hi

makesure you set up you Setup worksheet accordingly, see below 
That error means that the template (master doc) you are using is a document that you don't have access to or it's simply not anymore which could happen if youd don't have an id or the correct id in you setup tab.
also, in your setup worksheet make sure you enter the correct document id, which the string of characters in the document url
https://docs.google.com/document/d/this the document id/edit?tab=t.0

you don't need the CODIGO and AÑO fields, I do because I use those in my doc merger becuase I want the pdf that is created to include those values in the name of the pdf and I also use CODIGO as one of the values that I merged into the resulting pdf.

you could possible modify this portion of the script, or simply copy my script to google ai studio and just tell google what you'd like to change and the result simply copy it back to you google apps script

[Academia Puebla]

Hi, espero que alguien pueda orientarme.

TENGO UN PROBLEMA, SE GENERAN LOS DOCUMENTOS, PERO NO SE ENVÍAN AL CORREO, TENGO QUE HACERLO MANUALMENTE. 

YA NO SE ENVÍAN EN AUTOMÁTICO. 

TENGO QUE PRESIONAR EL BOTÓN DE PLAY PARA QUE SE ENVÍEN LOS CORREOS.

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/CAPbheqRRNwpT07ZqWd9Wb0B%3D5FUZGpdh%2BPjcSnfZPvtjFvG51A%40mail.gmail.com.

[mr rizzxhelp]

Do we have an academy on Telegram/WA or DC? 

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