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.


  • Profile Image

    Choose your file - hyperlink in google spreadsheet

    Asked by rjohn646 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

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Welvin 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
    JotForm Support

    Answered by alp_deniz 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
    JotForm Support

    Answered by alp_deniz on April 21, 2015 at 08:49 AM

    Hello,

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

    Kind regards

  • Profile Image

    Answered by etcroop 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

    Answered by Sammy 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
    JotForm Support

    Answered by alp_deniz 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