Google Spreadsheet to show the photos

  • Profile Image
    Asked on April 27, 2016 at 05:44 PM

    I love how the submissions integrate and export to google spreadsheets... but the pics don't show up on the google doc. Only web links to access the pics. Is there a way or is there another program where the pics will appear. It would really help my team with inventory management to see the pics. thanks

  • Profile Image
    Answered on April 27, 2016 at 09:19 PM

    Unfortunately the submission images/pictures on the form will only appear as link in the Google spreadsheet. They will not be an embedded impage/picture on the submission.

    If you are after a submission report that will show the submitted images as an embedded image on the report, you may want to check the HTML Table Report or the Grid Report instead.

    These 2 JotForm report have option to make the images in embedded view.

    Hope this help. Let us know if you need further assistance.

  • Profile Image
    Answered on April 28, 2016 at 05:40 AM

    Hi cklint

    The recommendation of JotForm Support Jonathan is what I use if I want to display the submissions as a webpage (Grid or HTML Table).

    But if you prefer to use the Google Sheets with submissions internally and just as reference, you can opt to follow this YouTube tutorial from The Gooru on how to Insert images into Google Spreadsheet cells (video embedded below - apparently, we can embed YouTube videos???). You just have to create a separate column with this surprisingly simple image() formula. 

    * I'm not sure how adding a new column will affect the Google Sheets integration. Please proceed with caution.

    Hope this helps.

    - Randy, fellow JotForm user. 



  • Profile Image
    Answered on April 28, 2016 at 07:49 AM

    Hi grade4pagasa, thank you for additional input.


    Hi cklint, you may consider the suggestion of grade4pagasa. May I warn you though that editing the spreadsheet sometimes may break the integration with your form. In case that happens, you may try re-integrating the spreadsheet with your form.



  • Profile Image
    Answered on April 28, 2016 at 07:59 AM
    Hi Randy, great suggestion as always :)

    Unfortunately if you modify anything within that first sheet created by the integration, the integration will break at some point. It does not happen right away, but will happen at some point.

    The suggestion would be to actually do that in the second sheet - you can create any number of sheets in the Google Sheet created by integration. As long as the first one is not manually modified, all is good.

    Now to get the data over, you would need to use import range.

    For example, importRange("sheet1!A1:C10000") and then simply change the D1 to D1000 to be image() function that gets the link from sheet1:d1

    Of course replace the columns as per your sheet and let us know how it goes