Google Sheets integration: FR to change the MIME type of Signature field to "IMAGE/PNG to faciliate GSheets to read the image file and display it

  • Profile Image
    oakphotos34
    Asked on October 22, 2020 at 07:34 AM

    Hi, I am using the signature form element to allow people to submit signatures.

    I export the form to a google sheet through the integration offered, however the signature comes through as a URL.

    This is fine under normal circumstances as you can use a URL of an image to display an image in google sheets. However the issue is that the signature URL when opened does not display in the web browser, but goes straight to download. This means that google sheets cannot view the image.

    This is due to the file having an incorrect MIME type. It should be set as image/png.This would allow the image to display in browser when the URL is opened, and therefore allow google sheets to display the image.

    If this is something your technical team could address, or provide me a work-around to get a URL to the signature image that displays in browser instead of downloads, that would be perfect.

    The reason for my need for google sheets integration is that we expect to have close to 2000 submissions, and a google sheet integration allows this database of information to generate our own PDF format, where the jotform PDF format will not suffice.

    Any help would be appreciated. Thank you! Joe.

    If we can get this system working as intended, we will be taking Jotforms as our primary form service for our business.

    Useful links:

    https://developer.mozilla.org/en-US/docs/Web/HTTP/Basics_of_HTTP/MIME_types#Important_MIME_types_for_Web_developers

    https://stackoverflow.com/questions/10158804/images-downloading-instead-of-being-displayed

    http://forums.mozillazine.org/viewtopic.php?p=3243738

    https://eu.jotform.com/oakphotos34/tenant-booking-form-version-2

    Above is our form.

  • Profile Image
    Patrick_R
    Answered on October 22, 2020 at 10:35 AM

    Hello! Thank you for your valuable suggestion. I'll forward the same as a feature request. If and when this gets implemented, we'll let you know via an email under this thread.

    Thank you!