El Autocrat no corre
Centro Integral de Psicoterapia Cognitiva Vivanco
Ahí hay reportes de psicología que son altamente importantes para los pacientes y no veo ninguna solución. Ahora me aparece la opción "help" que no ayuda en nada. No veo en ningún lado una solución y actualmente es crítico para la práctica clínica.
Marcelo Rossi
Francisco Cortes
Hi Gemini
maybe you are familiar with a google sheet addon called AutoCrat, this tool basically takes a master document with some place holders and uses fields on a google sheet that are map to the column values and placeholders in the document and can run through each of the rows and respective field values from the sheet to create a copy of the master document but with the field values marged.
I want to create something similar using google apps scripts.
Google sheet
I have a google sheet called tickets, within tickets a have tabs (worksheets) where I have values to merge onto a master document. I would like to start with the worksheet called 'Paz y Salvo'
Setup
in the worksheet called Setup, I should have 3 columns with headers: Worksheet Name, Master Doc ID, Mapping, Folder ID:
in cell A2: the name of the worksheet 'Paz y Salvo' and in cell B2 the respective file id of the master doc with the place holders to create unique merged documents, in cell C2 the mapping of column numbers and placeholders in the form of a string of json objects with pair values in the form of {'col_num1':'<<placeholder1>>','col_num2':'<<placeholder2>>',...} and in D2 the value of the folder ID where the merged documents should be created and stored in the format of a pdf.
merge worksheets setup
Each merge worksheets, with the exception of the Setup worksheet (first one in the set of worksheets within the Tickets spreadsheet) should have columns and values that will be used to merged onto a copy of a master doc on the respective col number's place holders, the merge worksheet name should match the value under Worksheet Name header in the Setup worksheet. the last columns headers of each merge worksheets should have specific names that include the following strings as follows:
Merged Doc ID: which will have the id of the merged doc that was created
Merged Doc URL: which will hold the url of the merged doc that was created
Link to merged Doc: which will hold the also the url of the merged doc but as a function of the type =HYPERLINK(merged_doc_url value)
Document Merge Status: which should have a string that should read something like: "Document successfully created; Document successfully merged; Manually run by myu...@mydomain.com; Timestamp: Oct 15 2025 6:27 PM" if the respective doc merged was succesfully merged and created.
Functionality
I want the user to click on a custom menu item which will display a dropdown with the names of the different worksheets that appear in the Setup worksheet for the user to select one of the different worksheets (starting with 'Paz y Salvo') so each of the values under column numbers, replace the corresponding placeholder onto a copy of the of the respective master document, once the user click on the worksheet name the script should picked up the placeholder values of the respective worksheet where there are values to to merge onto the master doc, but for which there's no value on the respective field under the Merged Doc ID column. with the set of values to merge onto the master doc, the script should proceed to create a master doc copy, replace the corresponding values to merge onto the placeholders in the copy of the master doc, create a pdf of the merged master doc copy, removed the copy of the master doc copy and log the expected values under the columns which header includes the names of 'merged doc id', 'merged doc url', 'link to merged doc' and 'document merge status' and continue to do so until all rows with values to merge have a doc id logged.
please review the requirements and let me know if you have any questions
despues dell primer resultado con el promt de arriba, solo tomo 3 prompts mas para llegar a un solucion final con la cual ya estamos trabajando
no le quito nada a auto-crat, nos a estado siriviendo mucho pero una solucion de casa a veces puede resultar conveniente.
Centro Integral de Psicoterapia Cognitiva Vivanco
En tus plantillas de autocrat, solo reemplaza << por {{ y podrán tener sus reportes rápido. Pensé que este problema se resolvería para hoy, pero no puedo seguir esperando más.
¡¡Espero les sea de utilidad!!
--
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/KXT9qx8cAbw/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/a3c8ae02-20bf-4a3a-9be5-dc6224e89b93n%40googlegroups.com.
JUAN JOSE
--
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/fe7481ae-d1e9-42b1-a94f-5155fc997d06n%40googlegroups.com.
Francisco Cortes
https://github.com/fcortesjp/Document_Merger