inserting text from google sheets into an existing numbered list in google docs
139 views
Skip to first unread message
Ellen Walder
Jun 11, 2021, 4:26:09 AM6/11/21
to NV Autocrat Add-on
I have a legal document in google docs with a numbered list for the clauses that are separated by hard returns. I use autocrat to update this doc from a google sheet of data. Sometimes there are clauses that need to be added into the document and sometimes there are not. This data is all stored in the google sheet. I have used char(10) & char(9) to add a new clause into the google doc but it just enters the clause on a new line without carrying on the numbering from the list above. Is there a way to do this? My project basically depends on it! thank you.
Joseph Schmidt
Jun 11, 2021, 9:53:06 AM6/11/21
to nv-autocr...@googlegroups.com
Autocrat only creates new docs, spreadsheets, or presentations. If updating an existing document is requires, Autocrat is not your tool.
Maybe I just don't understand.
On Fri, Jun 11, 2021 at 4:26 AM Ellen Walder <eewa...@biglittletech.com> wrote:
I have a legal document in google docs with a numbered list for the clauses that are separated by hard returns. I use autocrat to update this doc from a google sheet of data. Sometimes there are clauses that need to be added into the document and sometimes there are not. This data is all stored in the google sheet. I have used char(10) & char(9) to add a new clause into the google doc but it just enters the clause on a new line without carrying on the numbering from the list above. Is there a way to do this? My project basically depends on it! thank you.
--
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 on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/05ddd414-070d-4bf2-ac81-03ef311377a6n%40googlegroups.com.
Ellen Walder
Jun 17, 2021, 5:16:49 AM6/17/21
to NV Autocrat Add-on
Thank you for replying. I could explain better.... I am using autocrat to update an existing google doc by matching <<COLUMN_NAME>> with the column name of a column in a googlesheet. Sort of like mail merge in Microsoft word. It works reasonably well. The issue is that when autocrat overwrites <<COLUMN_NAME>> in a numbered or bullet point list in the google doc the numbering/bullet point list does not carry on. At best it puts in a line break if I use char (9) or char(10) at the start of the text string in my googlesheet. I was wondering whether there is any workaround for this?
Joseph Schmidt
Jun 17, 2021, 8:14:43 AM6/17/21
to nv-autocr...@googlegroups.com
Ellen,
You will not be updating a document, you will be creating a new document. I guess I got hung up on your words.
You need to add a column to your source. You can build what you need using a formula. The formula will use Char(10) to start a new line. The formula has to include the numbers for the bullets. The formula needs to have all of the items in the list in one column.
I would use an arrayformula for the column so you don't need to have the formula in all rows.
Look at Column S in Form Responses 2 of Spreadsheet.
=D$1 &char(10)& "Correct answer: "& D$2& char(10)&"Your answer: "& D2&char(10)&"Hint: "&D$3&char(10)&"Points possible: "&L$2&" Points earned: "&L2 &Char(10)
I used CopyDown but I now like arrayformula better. Arrayformula
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/70f4ceb7-f7af-4c7f-87ce-9f0ca959635cn%40googlegroups.com.
Ellen Walder
Jun 17, 2021, 10:00:27 AM6/17/21
to NV Autocrat Add-on
Thanks. That is what I have done as a work around. The issue is that the numbering will not always be the same each time and this method assumes that the numbering is a certain way. I think that all I can do is have multiple templates for the different types. It would be great to be able to dynamically pick the google doc from which to create a new doc. That way I could have multiple templates but only one autocrat script.
Joseph Schmidt
Jun 17, 2021, 10:31:48 AM6/17/21
to nv-autocr...@googlegroups.com
Ellen,
That is where you have to take biglittletech and write a formula that adjusts to the data. It is a more complex formula but it can be done.
I don't know if you want this for a school, non-profit, or for-profit organization.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/7d2eb195-b1c4-4a0c-a1a2-72eba151b1f2n%40googlegroups.com.
KANNAN M
Jun 20, 2021, 2:13:32 PM6/20/21
to nv-autocr...@googlegroups.com
We have plan to photo certificate. But still now photo not added to certificate... Kindly rectify...
Joseph Schmidt
Jun 20, 2021, 3:33:31 PM6/20/21
to nv-autocr...@googlegroups.com
I am only a volunteer. I tried to open one of the image files and it indicated that I didn't have access.
You must change the sharing on the folder that contains the images to anyone with the link can view. That is in the instructions.
On Sun, Jun 20, 2021 at 2:13 PM KANNAN M <kan...@kascsathy.ac.in> wrote:
We have plan to photo certificate. But still now photo not added to certificate... Kindly rectify...
--
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 on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAHBL%3DfoggffpOE7bvvxL88D_M3dR_Swhx7aLD31KRVRV6%2B6D-w%40mail.gmail.com.
Joseph Schmidt
Jun 20, 2021, 3:42:50 PM6/20/21
to nv-autocr...@googlegroups.com
You may want to check your sharing options. You may have shared your files with all of the members of the Autocrat group.
On Sun, Jun 20, 2021 at 2:13 PM KANNAN M <kan...@kascsathy.ac.in> wrote:
We have plan to photo certificate. But still now photo not added to certificate... Kindly rectify...
--
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 on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAHBL%3DfoggffpOE7bvvxL88D_M3dR_Swhx7aLD31KRVRV6%2B6D-w%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages