JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Linked data from submission table in google sheetAsked by tazola 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.
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.
I am the maintenance developer of Google Spreadsheet integration. I would be happy to help you on this. Could you be more specific please?
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