Choose your file - hyperlink in google spreadsheet

  • Profile Image
    rjohn646
    Asked on July 08, 2014 at 07: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 target="_blank" 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

  • Profile Image
    Welvin
    Answered on July 08, 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

  • Profile Image
    alp_deniz
    Answered on July 16, 2014 at 01: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

  • Profile Image
    alp_deniz
    Answered on April 21, 2015 at 08:49 AM

    Hello,

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

    Kind regards

  • Profile Image
    etcroop
    Answered on April 29, 2015 at 02: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?

  • Profile Image
    Sammy
    Answered on April 29, 2015 at 03: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.

     

     

  • Profile Image
    alp_deniz
    Answered on April 29, 2015 at 04:58 PM

    Hello,

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

    Kind regards