- Robert HelvieAsked on April 28, 2014 at 09:24 AM
The Google Drive and especially Google spreadsheets integration is very useful. However is there anyway to get a submitted image to actually display in the Google spreadsheet instead of having only a link? (Perhaps in a thumbnail format?)
This is a re-post of a comment on Google Docs Integration: Send Responses to Google Spreadsheets. Instantly.
- jedcadornaAnswered on April 28, 2014 at 10:18 AM
I don't think that Google spreadsheet has this feature I tried it and it doesn't seem to show any thumbnails. In the meantime you can use Grid listing and HTML table report showing a thumbnail images.
Please see this sample:
- RobertHelvieAnswered on April 28, 2014 at 07:20 PM
Thanks for the information. On further Googling I think it is possible.
See Serge insas's script down the page a little.
The working spreadsheet is here: (Scroll down to around row 206)
Unfortunately, my scripting abilities are sub-par. Maybe you folks could get it working for Jotform in the future.
- jedcadornaAnswered on April 28, 2014 at 11:02 PM
- grade4pagasaAnswered on April 28, 2016 at 05:56 AM
I know this thread is 2 years old and you may have found the solution you're looking for.
Otherwise, 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.
- BorisAnswered on April 28, 2016 at 08:22 AM
Thank you for your yet another very useful contribution, Randy. :)
Our developer who works on our Google Spreadsheet integration mentioned that inserting a new column, as long as certain conditions are met, should not affect or break the integration. These conditions are that:
- you should not modify any of the existing columns that were created by the integration;
- the header (first cell) of the newly inserted/created column should be different from any of the integrated column headers in the spreadsheet, and should also be different from the main label of any form field you have on your form.
The above two kinds of edits would likely break the Google Spreadsheet integration, while simply inserting a new column does not, of itself, break the integration.
Probably the most important thing to be aware of is that JotForm has a bandwidth/download limit set on any files that are uploaded on our forms, which means that any uploaded image can only be downloaded a certain amount of times. The limit is downloading 100 times for files that are under 10 MB in size, and 10 times for files larger than 10 MB.
This means that if you were to display uploaded images directly in the spreadsheet, each time you would open the spreadsheet, you would also load those embedded images as well. You could quickly run out of available downloads by opening the spreadsheet, and the files could become unavailable. For that reason, it is not recommended to display images from our servers in such a way, as images can only be downloaded a limited amount of times.
- grade4pagasaAnswered on April 28, 2016 at 10:48 AM
Please disregard my suggestion as this will have repercussions on your bandwidth / download limit based on the statement above.
Thanks for the heads-up!
I didn't know that viewing the integrated Google Sheets submissions with in-cell images would trigger the bandwidth / download limit. Could you please expound more on this?
For instance, how is a.) viewing the integrated Sheets with in-cell images different compared to b.) viewing Grid Listings with images or c.) HTML Table Report with images? Would scenarios b & c also trigger the bandwidth / download limit?
Which makes me wonder: If the trigger on the bandwidth / download limit is an important metric that needs to be monitored (much like submissions and form views), why wasn't it mentioned in either the user guides How to create an HTML Table Listing Report and How to create a Grid Listing report (assuming the images on those reports will also load those embedded images)?
While waiting for your reply, I will experiment on scenarios a, b & c. I will be using the 2 images cited in the demo sheet.
Btw, where in my account settings should I go to check the bandwidth / download limit metric (image below)?
Also, I couldn't find any documentation regarding bandwidth / download limit in the FAQ, Pricing page, or User Guide.
Appreciate the guidance.
- grade4pagasaAnswered on April 28, 2016 at 09:15 PM
I'm done experimenting on all 3 scenarios stated above.
No change observed in the usage metrics.
Where can I monitor my bandwidth / download limit metric?
- JotForm SupportKevin_GAnswered on April 28, 2016 at 11:06 PM
This limit is not listed in your account, so this is why you do not see any limit increased, the limits are listed on my colleague's reply above, but you will know this only when you get the message about bandwidth limit exceeded when trying to load a file.
Regarding to how this limit increases, this will do each time that you load a file uploaded to our severs, does not matter how do you load the file, if it is being loaded using the URL which points to our server then this limit will increase.
- grade4pagasaAnswered on April 28, 2016 at 11:44 PM
Besides getting a warning message about exceeded bandwidth limit, what else will happen? Will the account be suspended?
Can the user guides be updated to include that as a natural consequence of using either grid or html table lising with images, the download / bandwidth limit will decrease every time the images are loaded in those reports?
Other users might be using the report with grid or html table with images and are totally unaware of the possibility of exceeding their download / bandwidth limit.
- JotForm SupportKevin_GAnswered on April 29, 2016 at 01:08 AM
That the only thing thing that you will receive, the warning message notifying that you have exceeded the bandwidth limit, the file will not be longer available, we can reset the bandwidth limit, but this can be done only once in a lifetime, this is why we do suggest to integrate your forms with either Google Drive or Dropbox, to avoid this happening.
Yes, you're right this needs to be added to our current guides, all those guides about reports should include this information and let users know about this, thank you for this.
We will keep this in mind and will try to update the guides as soon as possible.
- JotForm SupportKevin_GAnswered on July 03, 2017 at 01:34 PM
We will assist you on the following thread: https://www.jotform.com/answers/1190143