Importing images collected in Google forms to a Google Doc w/Autocrat

449 views
Skip to first unread message

Kathy Boulet

unread,
Jan 30, 2020, 1:50:34 PM1/30/20
to NV Autocrat Add-on
We are using Google Forms & Autocrat to collect applications.  The text part of the information is working beautifully.  
For this application the individuals submitting need to submit a picture of themselves and a few other pictures of their family.

We are using the [File Upload] question type in Google Forms.  

When we go to Autocrat to set up the mapping, we select {image} for the type and make the folder that the images are stored in viewable by anyone with the link.  
As you have probably guessed, the images are not showing in my document.

My questions are:
--Should I use a different question type for applicants to submit pictures?  or
--Is there a way to automatically Host the submitted images?
--I've tried to install the previous version of Autocrat (with a new account) to see if that would work.  But the only version I've been able to install is the current one. 

Thanks for your help!  

Joseph Schmidt

unread,
Jan 30, 2020, 2:57:46 PM1/30/20
to nv-autocr...@googlegroups.com
You have to share the folder with anyone with the link can view.  Also, the URL will not work without a small change.  

See FAQ there is a section on images.



--
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/f4bd31ae-e8dd-438a-88f1-0771f3bbf352%40googlegroups.com.

Kathy Boulet

unread,
Feb 3, 2020, 10:25:09 AM2/3/20
to NV Autocrat Add-on
Joe,
        Thanks for your response.  I've seen the code in the FAQ section on images...I'm just not sure what I need to do with it or where to put it.  I've never worked with an Array Formula, so it's looking Greek to me.  :)


Kathy


On Thursday, January 30, 2020 at 1:57:46 PM UTC-6, Joseph Schmidt wrote:
You have to share the folder with anyone with the link can view.  Also, the URL will not work without a small change.  

See FAQ there is a section on images.



On Thu, Jan 30, 2020 at 1:50 PM Kathy Boulet <boule...@gmail.com> wrote:
We are using Google Forms & Autocrat to collect applications.  The text part of the information is working beautifully.  
For this application the individuals submitting need to submit a picture of themselves and a few other pictures of their family.

We are using the [File Upload] question type in Google Forms.  

When we go to Autocrat to set up the mapping, we select {image} for the type and make the folder that the images are stored in viewable by anyone with the link.  
As you have probably guessed, the images are not showing in my document.

My questions are:
--Should I use a different question type for applicants to submit pictures?  or
--Is there a way to automatically Host the submitted images?
--I've tried to install the previous version of Autocrat (with a new account) to see if that would work.  But the only version I've been able to install is the current one. 

Thanks for your help!  

--
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-on+unsub...@googlegroups.com.

Joseph Schmidt

unread,
Feb 3, 2020, 10:48:57 AM2/3/20
to nv-autocr...@googlegroups.com
It depends on if you allowed multiple photos per question.  If you only allowed one photo per question, you need to insert a column and put this formula in row one.  

If you only have allowed a single image, then this formula will work. 

=arrayformula(if(row(A:A)=1,"photo id",substitute(D:D,"open?","uc?export=view&")))

Change the D:D to the column that has the URL to the photo.

An arrayformula is a way to eliminate the need for the CopyDown add-on.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.

--
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/10fbbd3e-165b-49be-bffc-82bd01bf6608%40googlegroups.com.

Kathy Boulet

unread,
Feb 3, 2020, 11:25:09 AM2/3/20
to NV Autocrat Add-on
Joe,
       Thank for so much!  I was able to get an image to go through on my testing form.  

Kathy


On Monday, February 3, 2020 at 9:48:57 AM UTC-6, Joseph Schmidt wrote:
It depends on if you allowed multiple photos per question.  If you only allowed one photo per question, you need to insert a column and put this formula in row one.  

If you only have allowed a single image, then this formula will work. 

=arrayformula(if(row(A:A)=1,"photo id",substitute(D:D,"open?","uc?export=view&")))

Change the D:D to the column that has the URL to the photo.

An arrayformula is a way to eliminate the need for the CopyDown add-on.



On Mon, Feb 3, 2020 at 10:25 AM Kathy Boulet <boule...@gmail.com> wrote:
Joe,
        Thanks for your response.  I've seen the code in the FAQ section on images...I'm just not sure what I need to do with it or where to put it.  I've never worked with an Array Formula, so it's looking Greek to me.  :)


Kathy


On Thursday, January 30, 2020 at 1:57:46 PM UTC-6, Joseph Schmidt wrote:
You have to share the folder with anyone with the link can view.  Also, the URL will not work without a small change.  

See FAQ there is a section on images.



On Thu, Jan 30, 2020 at 1:50 PM Kathy Boulet <boule...@gmail.com> wrote:
We are using Google Forms & Autocrat to collect applications.  The text part of the information is working beautifully.  
For this application the individuals submitting need to submit a picture of themselves and a few other pictures of their family.

We are using the [File Upload] question type in Google Forms.  

When we go to Autocrat to set up the mapping, we select {image} for the type and make the folder that the images are stored in viewable by anyone with the link.  
As you have probably guessed, the images are not showing in my document.

My questions are:
--Should I use a different question type for applicants to submit pictures?  or
--Is there a way to automatically Host the submitted images?
--I've tried to install the previous version of Autocrat (with a new account) to see if that would work.  But the only version I've been able to install is the current one. 

Thanks for your help!  

--
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-on+unsub...@googlegroups.com.

--
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-on+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages