Linked data from submission table in google sheet

  • Profile Image
    Asked on August 05, 2014 at 10:33 PM

    When you do a google sheet integration, the hyper linked data is populated in the spreadsheet and you can open the links if there isn't more than one url in the cell.  I have found that the integrated google sheets break links to the database frequently and therefore don't work for my application.  

    What I am doing is an importhtml function which brings the table data into the google sheet.  The issue is that the importhtml function strips the hyper linked data so you can't open the urls to the data.  Since Jotform is able to do the integration and bring the url data into a google sheet, there must be a way to do this.  Can you let know what to do.


  • Profile Image
    Answered on August 06, 2014 at 05:24 AM

    Hello tazola,

    I am not sure if I have understood your question correctly.

    Do you mean to say that when multiple files are uploaded, the google spreadsheet does not show the hyperlink?

    I did test this by cloning your form and integrating it with google spreadsheet. Upon sending test submission, I found that the google spreadsheet does not display the hyperlink if multiple files are uploaded. But if we upload only one file, the hyperlink is being displayed. Please check the screenshot below:

    I am not sure if this is a bug but I am anyway reporting it to our back end team. We will get back to you as soon as we have any update from them.

    Thank you!

  • Profile Image
    Answered on August 16, 2014 at 08:36 AM


    I am the maintenance developer of Google Spreadsheet integration. I would be happy to help you on this. Could you be more specific please?

    Kind regards

    PS: Upon above support request, I have made research about links in spreadsheets cells and unfortunately I couldn't find a way to enable multi-links in a cell whether in google spreadsheets or Excel. However, you may use it with single upload fields