Can I download music files which have been uploaded to a form as a link within a CSV or Excel file?

  • Profile Image
    GLORIA 
    Asked on February 13, 2020 at 02:53 AM

    We have competitors who need to upload up to 2 music files with a submission (files up to 4.5 minutes).   I know we can have our competitors upload the files and I have already tested that.   

    I know we can download all attachments in one go, but this puts the music in one folder and the information relating to the attachments into another folder.   We need to marry up the music file with the data.

    Can these files be downloaded en-masse using excel or csv and displaying as a link to the music file within the document? 

    We have set up a pretty basic form which needs to capture more information, we are just experimenting with the uploads. 

    Is this a possibility.  Thanks - Gloria

  • Profile Image
    Richie_P
    Answered on February 13, 2020 at 08:43 AM

    This is possible when you create a Grid listing report.

    Screenshot:

    When you download your submission as CSV or Excel, the uploaded file path is given and not a link.

    You may try to integrate your form with Google Sheet.

    https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets

    Screenshot:

    Please give it a try and let us know how if this fits your requirements.

  • Profile Image
    GLORIA 
    Answered on February 13, 2020 at 11:50 PM
    That worked perfectly - thank you.
    ...