[Solved] Can Multiple Files be Uploaded and then using the Google Spreadsheet Integration have each individual link to the photos appear in my Google Spreadsheet as opposed to one link being generated for all photos?

0

Hi,

 

I’m planning on using the Google integration a lot in the surveys I am creating and I am very interested in using the File upload Question type. 

I’ve created a Google Spreadsheet and linked it all with my account – I have several questions being feed into it and it works great! 

But now I am attempting to integrate the file uploads to my google spreadsheet. This works when only photo is uploaded, but when I upload multiple files it creates one long link with all the photos titles in that URL – e.g.

http://surveygizmoresponseuploads.s3.amazonaws.com/fileuploads/389112/2549051/180-cba4165a916ef7dcd0bf75e5d5df9914_VV+Favicon.JPG%0A180-cba4165a916ef7dcd0bf75e5d5df9914_VillageVerse.JPG%0A57-cba4165a916ef7dcd0bf75e5d5df9914_PTP.jpg

As you can see there are 3 JPG files in that one link. When I click on the file it takes me to a page that says “This XML file does not appear to have any style information associated with it. The document tree is shown below.” And there are no photos?

Can individual links for the photos be created? Have I missed something?

Thank you in advanced for your help

kieranscallan asked

    Best answer

    0

    Hi Kieran,

    Thanks for using community! Unfortunately, the Google Spreadsheet integration works by taking each field and sending it as one string.  So in the case you have a file upload question that has more than 1 file, there is not a way to break that information out individually.

    Under the file upload question, there is an option to limit the files uploaded in each. I would recommend only allowing 1 file and simply adding additional file upload questions to your survey.

    For example, lets say you anticipate a maximum of 3 files being uploaded.  You could have a question ask something along the lines of “How many images would you like to upload?” and simply set logic on the File upload questions so the corresponding file upload questions display. This would allow you to map each file upload question to its own field in Google Sheets allowing for the links to be separated and ensuring they will work.

     

    Here is an example survey you can take a look at that would function similarly and pass each image to a different column in Google Sheets: http://www.surveygizmo.com/s3/2590995/file-upload-google-spreadsheet-action

     

    Take a look and let me know if you think something like this might work for your survey!

     

    Kind Regards,

    Tyler

    Tyler - SurveyGizmo answered
      ×

      Login

      Question stats

      • Active
      • Views776 times
      • Answers1 answer
      • Followers0 followers