Choose your file - hyperlink in google spreadsheet

  • rjohn646
    Asked on July 8, 2014 at 7:50 AM

    Hello,

     

    Is it possible that when someone uploads a file at the end of a form, it automatically changes into a hyperlink, like the format below, in Google Spreadsheet?

     

    <a href="URL">View </a>

     

    I ask the question because the form is for idea sharing on Google Sites and their file is the main link which needs to be displayed immediately for others to view.

     

    Currently, the upload comes through like...

     

    https://www.jotformeu.com/uploads/rjohn646/41381244804349/270628472701320350/Kaizen%20Delivery.pdf

    Jotform Thread 400811 Screenshot
  • Welvin Support Team Lead
    Replied on July 8, 2014 at 10:11 AM

    Hi,

    Unfortunately, that is how the files will be presented in the Google Spreadsheet integration, the files are not hyperlink. The same when you export the submissions into an excel file.

    Allow me to forward this thread to our developers as a feature request. We can't give you an ETA but if there are updates, you should know it via this thread.

    Thanks

  • alp_deniz
    Replied on July 16, 2014 at 1:46 PM

    Hello,

    I have just implemented conversion to hyperlinks in Google spreadsheets, however, it only works for the first time on initialization. Unfortunately, new submission uploads stays as full links because Google's Spreadsheets interface does not allow this kind of operation. 

    Meanwhile I will be looking for some answers from google's developers, so that we will be converting hyperlinks if it is possible to do so.

    Thank you very much

    Kind regards

  • alp_deniz
    Replied on April 21, 2015 at 8:49 AM

    Hello,

    I have just fixed hyperlinks in excel downloads and spreadsheet integration. 

    Kind regards

  • etcroop
    Replied on April 29, 2015 at 2:30 PM

    This creates a big problem for any user who needs the URL address. There is not an easy way to automatically get the URL from hyperlink function in Google Sheets. Can this be a setting for the integration or in the file upload settings on the form?

  • Sammy
    Replied on April 29, 2015 at 3:32 PM

    Hi,

    Could you kindly refer to this thread http://www.jotform.com/answers/557168

    it addresses the issue you're being faced with regarding showing the full link.

     

    Kind regards.

     

     

  • alp_deniz
    Replied on April 29, 2015 at 4:58 PM

    Hello,

    Per your requests, we have reverted to full url version without the hyperlink. Thank you for your feedback.

    Kind regards