Images in merge templates
995 views
Skip to first unread message
Lisa Mick
May 14, 2021, 2:50:56 PM5/14/21
to NV Autocrat Add-on
I am working on a Google Form to Google Sheet to Google Doc Template merge that includes standard text and number fields and 3 images (could be screen shots or PDF images that an individual uploads either from their computer or their Drive to the Form). Once they submit the form, I would like AutoCrat to take that data and most specifically the actual images and merge them into my document template. I have not been successful in using the Image option native to AutoCrat to make that happen. Any assistance would be greatly appreciated.
Joseph Schmidt
May 14, 2021, 11:32:46 PM5/14/21
to nv-autocr...@googlegroups.com
I'm not sure what a PDF image is. Google forms will store a link to the photo. That is the link that must be used in the image merge tag.
See the FAQ that is located in the description of the group. The image URL must match a specific format. The image file must be hosted publicly. Anyone with the link can view.
On Fri, May 14, 2021 at 2:50 PM Lisa Mick <mic...@aps.edu> wrote:
I am working on a Google Form to Google Sheet to Google Doc Template merge that includes standard text and number fields and 3 images (could be screen shots or PDF images that an individual uploads either from their computer or their Drive to the Form). Once they submit the form, I would like AutoCrat to take that data and most specifically the actual images and merge them into my document template. I have not been successful in using the Image option native to AutoCrat to make that happen. Any assistance would be greatly appreciated.
--
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/5b8f4854-2c1f-44e8-a872-c3fe6a20056bn%40googlegroups.com.
Lisa Mick
May 19, 2021, 10:55:02 AM5/19/21
to NV Autocrat Add-on
Joe - thanks for the response. I mis-spoke on the PDF images. The individual is going to be uploading screenshots or images saved on their own computer to a form which feeds the direct link to a GSheet. I would then like that data to merge into individual documents to include the actual image, not just a link to the image. Each time I try to do this it only places a link or just text into the merged document. Any advice?
Lisa
Joseph Schmidt
May 19, 2021, 11:21:16 AM5/19/21
to nv-autocr...@googlegroups.com
There is an option to display the image. You can merge text, URL, or an image.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/9e8195ac-49a4-4ede-8c28-dc804b4ca7e0n%40googlegroups.com.
Patrick Murphy
May 19, 2021, 11:39:12 AM5/19/21
to nv-autocr...@googlegroups.com
BUt the image has to be publicly hosted,. Iam having issues with this as well.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQqGuA8sFjfp2J3xZpmuzFqtHrwVXbzT0TbV_wi-u8vnA%40mail.gmail.com.
Lisa Mick
May 19, 2021, 11:44:42 AM5/19/21
to nv-autocr...@googlegroups.com
I hear you and I see the option to merge the image, but it is not working for me. I'm sure it is something simple, but I cannot get it to work.
Lisa J. Mick, OTR/L, ATP
Occupational Therapist, Assistive Technology Professional
Access and Communication Technology Team
Albuquerque Public Schools, Special Education Department
CONFIDENTIALITY NOTICE: This email and attached documents may contain confidential information. All information is intended only for the use of the named recipient. If you are not the named recipient, you are not authorized to read, disclose, copy, distribute or take any action in reliance on the information and any action other than immediate delivery to the named recipient is strictly prohibited. If you have received this email in error, do not read the information and please immediately notify sender by telephone to arrange for a return of the original documents. If you are the named recipient you are not authorized to reveal any of this information to any other unauthorized person. If you did not receive all pages listed or if pages are not legible, please immediately notify sender by phone.
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/3uIH0m4k9D8/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAPWPTOQqGuA8sFjfp2J3xZpmuzFqtHrwVXbzT0TbV_wi-u8vnA%40mail.gmail.com.
Lisa Mick
May 19, 2021, 11:45:49 AM5/19/21
to nv-autocr...@googlegroups.com
I want to merge an image that an individual has on their own computer, not available on the internet.
Lisa J. Mick, OTR/L, ATP
Occupational Therapist, Assistive Technology Professional
Access and Communication Technology Team
Albuquerque Public Schools, Special Education Department
CONFIDENTIALITY NOTICE: This email and attached documents may contain confidential information. All information is intended only for the use of the named recipient. If you are not the named recipient, you are not authorized to read, disclose, copy, distribute or take any action in reliance on the information and any action other than immediate delivery to the named recipient is strictly prohibited. If you have received this email in error, do not read the information and please immediately notify sender by telephone to arrange for a return of the original documents. If you are the named recipient you are not authorized to reveal any of this information to any other unauthorized person. If you did not receive all pages listed or if pages are not legible, please immediately notify sender by phone.
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/3uIH0m4k9D8/unsubscribe.
To unsubscribe from this group and all its topics, 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/CACq9Fjuyb6bCReZseGU%3Dg86w5rRsN%2BZt1vjagZ_t7RNgJqLBJQ%40mail.gmail.com.
Joseph Schmidt
May 19, 2021, 1:24:18 PM5/19/21
to nv-autocr...@googlegroups.com
It can't be done. The image has to reside someplace that can be found via a link. That means online. Also, it has to be shared with anyone with the link can view.
The anyone one with a link isn't as bad as it sounds. They have to have the link. If you limit who can see the link, you are limiting who can see the photo.
In the FAQ there are certain items that must be in the URL. Sometimes the only problem is something missing from the URL.
And then to be completely honest, there are times when all the rules are followed and some images will not show. That is usually many images on the same page or using single output for many rows.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CANUvisgwCqf3dxHUyhRq78ekphn%2Bw-8qioi11CV1toWSRdJCWA%40mail.gmail.com.
Joseph Schmidt
May 19, 2021, 1:25:52 PM5/19/21
to nv-autocr...@googlegroups.com
Did you look at the FAQ for help in reformatting the link?
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CACq9Fjuyb6bCReZseGU%3Dg86w5rRsN%2BZt1vjagZ_t7RNgJqLBJQ%40mail.gmail.com.
Patrick Murphy
May 21, 2021, 3:46:40 PM5/21/21
to nv-autocr...@googlegroups.com
Yes.
Here is my sample sheet. I have the formulas added, but the images do not show up. I added a screenshot of the images from my google drive. Not sure which URL I am supposed to be using for the original image link
I tried the ":share" link and I tried opening the jpg file and copying the view link that shows in that window. In both cases, the image will not show in the new Col E and will not show in the autocrat merge either.
https://docs.google.com/spreadsheets/d/1ZzPsyG8nN8GIfQfYhupp07ZJYkXMFqfPYpqshSA7_XA/edit?usp=sharing
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOSV4x2%2BmxT5Xp7dnJBvHQYGHCYQ%2BxxNk4OzxH0NN4qJNw%40mail.gmail.com.
Joseph Schmidt
May 21, 2021, 5:23:48 PM5/21/21
to nv-autocr...@googlegroups.com
Patrick,
That formula was to correct a problem with images collected via a Google Form. Your URL is different than the URL when you have a file stored in your drive.
I managed to change the URL so it will work. The new link brings back the thumbnail of the image.
I'm beginning to hate images and Autocrat. They are so darn temperamental.
I hope this works for you. I have multiple other projects on my plate including cutting the grass which I'm off to do right now.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CACq9FjtBe8AVrQ6DNJ3xwRi39t%2B7av0XQU6dYTrYHVUVjTm8Rw%40mail.gmail.com.
Nate Card
May 21, 2021, 6:33:54 PM5/21/21
to NV Autocrat Add-on
I had no success with the formula in the FAQ. What has been working (with about 75% success rate) is
=arrayformula(if(row(A:A)=1,"Merge this",substitute(D:D,"drive.google.com/open?","doc.google.com/uc?")))
I've used Google Slides for my template, and for the image tag <<Merge this>> it didn't work until I used a labeled shape object for the tag (not a text object). Still occasionally AutoCrat gets stuck on "Starting..." or the image url won't work, despite it being shared publicly like all the others
Hope that helps folks! If anyone here does have success with the FAQ formula, I would love to hear about it.
Nate Card
May 21, 2021, 6:44:44 PM5/21/21
to NV Autocrat Add-on
Joseph Schmidt
May 21, 2021, 9:24:18 PM5/21/21
to nv-autocr...@googlegroups.com
I think you are correct that the FAQ needs changing. I don't remember seeing your solution but will give it a try when I have time.
As you say, even when you get a URL that will work, if you have a lot of photos, there is a good chance that some will not merge.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/40d45a05-a6a3-4677-951a-9619017a6ea9n%40googlegroups.com.
Joseph Schmidt
May 22, 2021, 3:10:54 PM5/22/21
to nv-autocr...@googlegroups.com
I just did over a hundred rows and the best I can tell all of the photos appear n the single output document.
I think it is a combination of how busy are Google's computers. How large are the image files. Conditions outside of our control.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/bfc13597-845f-4879-a5ea-341cfb7a4d76n%40googlegroups.com.
Patrick Murphy
Jun 18, 2021, 11:21:36 AM6/18/21
to nv-autocr...@googlegroups.com
Hi Joe
Wanted to let you know your thumbnail link did work. THANK YOU.
Care to share how you did that? so I could replicate it with other similar images for future projects?
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOQ1VOkLTiUS%3DTVOqGGWQdHLs%2BRy1RKAG82-_59rpR9Q5Q%40mail.gmail.com.
Joseph Schmidt
Jun 18, 2021, 11:34:35 AM6/18/21
to nv-autocr...@googlegroups.com
Magic! The formula is in cell D1 of the example. I used an arrayformula. Arrayformula
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CACq9Fjvm7OmS5AH%3DHKaEyJd40op3hKA_PALtdVo8S7s1vAZX%3Dg%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages