What I can do
I can create a automation that Creates a PDF with the chosen data in a single column format. What I would like to do is take that Data and create a formatted PDF . Example data is a patient intake form. I would like to be able to recreate the Clinic's existing paper form in a Google Doc using sheets or excel. The goal is that when the bot is triggered by a data change the resulting PDF is a completed and formatted intake form. Not a column of data that uses only 1/3 of the page.
<<[First Name]>> | <<[Middle Name]>> | <<[Last name]>> | <<[Date of Birth]>> |
<<[Address]>> | Etc...Etc |
User | Count |
---|---|
31 | |
11 | |
3 | |
2 | |
2 |