- cklintAsked 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
- JotForm SupportjonathanAnswered 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.
These 2 JotForm report have option to make the images in embedded view.
Hope this help. Let us know if you need further assistance.
- grade4pagasaAnswered on April 28, 2016 at 05:40 AM
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.
- JotForm SupportChriistianAnswered 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.
- JotForm SupportChriistianAnswered on April 28, 2016 at 07:59 AMHi 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