Google Spreadsheet to show the photos

  • Profile Image
    cklint
    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
    jonathan
    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
    Chriistian
    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.

     

    Regards.

  • Profile Image
    Chriistian
    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