Hyperlink file uploads in the generated excel file, like the way how they appear in the form submissions page

  • martinbond
    Asked on February 11, 2015 at 2:44 AM

    Hi, 

    Is it possible for response attachments to format the same way in excel / CSV as they do on JotForm response viewer, see attached snip. 

    Below is how the attachments are currently appearing in Excel / CSV. Also when I click the link an error message appears saying file cannot be found.

    Please advise.

     

    Regards,

     

    Jotform Thread 513783 Screenshot
  • jonathan
    Replied on February 11, 2015 at 9:03 AM

    Are  you saying that the uploaded files on your jotform http://www.jotform.me/form/50353246648457 have broken link and could not be downloaded?

    I just checked the uploaded files, and I was able to download them using the URL link

    Hyperlink file uploads in the generated excel file, like the way how they appear in the form submissions page Image 1 Screenshot 20

     

    Please try downloading the submission again and check the upload link to the files.

    user guide: -How-to-Download-Form-Submissions-as-Excel-CSV-PDF

     

    Hope this help. Pleas let us know if issue remains.

    Thanks.

  • martinbond
    Replied on February 12, 2015 at 12:30 AM

    Downloaded again & still getting the same outcome in excel, they are Functional & correctly formatted on JotForm table of responses. See snip below of broken link in excel. Hyperlink file uploads in the generated excel file, like the way how they appear in the form submissions page Image 1 Screenshot 20 

  • Welvin Support Team Lead
    Replied on February 12, 2015 at 6:53 AM

    Thank you for the screenshot. It looks like you have the issue of getting the individual link to work in the Excel file since they are not clickable and currently not wrap.

    Allow me to submit your original request about the order of the link and the way how it appears in the excel file which is a hyperlink to the file name. If there are updates, you should know it via this thread.

    For now, double click the row and highlight the link and copy/paste it to your browser.

    Regards

  • martinbond
    Replied on February 12, 2015 at 7:02 AM

    Splendid, thank you. 

  • alp_deniz
    Replied on April 21, 2015 at 9:17 AM

    Hello,

    As excel or spreadsheets can only get one hyperlink per cell and it is not possible to know number of uploads/links per question, this issue is finalized by proper hyperlinking of 1 link/cell answers. Unfortunately, completely due to the nature of excel files, multiple links are not handled.

    Would you think it is agreeable? 

    Kind regards