Links to uploaded files aren't working in Excel

  • icpaconnect
    Asked on February 17, 2016 at 11:51 AM

    I created several contest forms and allowed contestants to upload a file of the writing/photo/design entries. I downloaded the submissions into Excel. The uploaded files appear as URLs that are supposed to link to the file that was uploaded in Jotform, but when I click the link, I get a message from Excel: Cannot locate internet server or proxy server. I figured out why, but it would take forever to correct.

    The URL appears like this:

    https://www.jotform.com/uploads/icpaconnect/53613945282156/330623288212227959/Crescent-Best Use Photo_Art-NeuChapel.pdf

     

    When you click it, it won't open. However, if you copy and paste it into a browser, it opens because it changes the URL to this:

    https://files.jotform.com/jufs/icpaconnect/53613945282156/330622956212486679/Crescent-Best%20Use%20Photo_Art-Albion.pdf

     

    Can you fix this so when the Excel file downloads that it provides the second URL format? I have 1,000 contest entries, and I can't ask a judge to copy and paste every link. :(

     

  • Mike
    Replied on February 17, 2016 at 3:42 PM

    I cannot reproduce the Excel error on my side using Microsoft Excel 2013 on Windows 7.

    We do not provide any alternative link format for Excel, so you may consider manually updating the links. It should be easy with a Replace All option in Excel.

    Links to uploaded files arent working in Excel Image 1 Screenshot 20

    However, there is a chance that error is not related to the redirect upon a link click.

    Error message when clicking hyperlink in Office: "Cannot locate the Internet server or proxy server"

    If you need any further assistance, please let us know.

  • icpaconnect
    Replied on February 17, 2016 at 4:03 PM

    Why is the link that is created in the Excel download different than the link created in the PDF download?

  • Mike
    Replied on February 17, 2016 at 5:14 PM

    Excel and email download links are considered as standard download links, so unfortunately, there is nothing we can do about this at the moment. The PDF is being generated in a different way compared to the Excel files.