What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Google Spreadsheet to show the photosAsked by cklint 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
Submissions integrate google spreadsheet
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.
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.
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 SupportHi 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