is there any way to rename the uploaded files when its already created?
If you lock the Details screen of the File asset, you can rename it there. The Title wont rename the actual file, but the File Name field will.
i mean when i upload the file through file builder asset, if a file that already exists, then the file uploader will be giving the error or massage that the file already exists so i need to rename the file then upload it again. is there any way to avoid it, than just renaming first the file before uploading?
I don't think this can be done automatically with files.
It can be done automatically by using a Custom Form's file upload field, though. :) Though, I'm not sure if that field can detect file types and create the most appropriate asset type. I've never tried it.
Is there a way to link the filename of the uploaded document within the submissions download (eg. within a CSV file)?
It currently prints out the file name of the document being uploaded to a form but I'd like to know if the document can be somehow linked in the downloaded spreadsheet?
Does anyone know if this is possible (v4.8.2)? and apologies if this question is hijacking the original post…
[quote]
Is there a way to link the filename of the uploaded document within the submissions download (eg. within a CSV file)?
It currently prints out the file name of the document being uploaded to a form but I'd like to know if the document can be somehow linked in the downloaded spreadsheet?
Does anyone know if this is possible (v4.8.2)? and apologies if this question is hijacking the original post…
[/quote]
Not sure what you are meaning. Are you talking about uploading files? Or downloading Custom Form submissions?
[quote]
Not sure what you are meaning. Are you talking about uploading files? Or downloading Custom Form submissions?
[/quote]
Hi Nic,
When you download custom form submissions as a CSV file, the filename of the uploaded file appears in the spreadsheet however is there a way to actually print out the URL of the uploaded file as well?
So whoever is managing this form can simply download the uploaded form directly from the spreadsheet. Do you think this is possible?
Adeline
[quote]
Hi Nic,
When you download custom form submissions as a CSV file, the filename of the uploaded file appears in the spreadsheet however is there a way to actually print out the URL of the uploaded file as well?
So whoever is managing this form can simply download the uploaded form directly from the spreadsheet. Do you think this is possible?
Adeline
[/quote]
So you are wanting a way to access the form submissions download URL?
[quote]
So you are wanting a way to access the form submissions download URL?
[/quote]
Hi Nic,
I'm wanting to download the 'uploaded files' directly off the CSV file.
Adeline
[quote]
Hi Nic,
I'm wanting to download the 'uploaded files' directly off the CSV file.
Adeline
[/quote]
Ah ok. No, I don't think there is a way to do this. Probably a good feature request though.
You can sort of get this to happen, almost, in Excel post-export. If you don't mind fiddling with the file before sending it on to whomever is going to analyse it.
Assuming your filepath is in column Q and row 1 is headings, your formula in R2 to get the URL is:
="http://rootpath/"&LEFT(Q2,FIND(",",Q2,1)-1)
Where 'rootpath' is the part of the Web Path for up to the folder the files are deposited into when uploaded.
This will display the URL to the file. You can use Excel's HYPERLINK formula wrapped around it, but I find it fails to open on clicking. Perhaps Excel is trying to open the (MS Word, in my test case) file natively rather than using a browser as it's a hyperlink? Anyway, the path is there and your person analysing could at least then copy/paste each one into a browser. So it's still an extra step or two, but better than showing them how to use the back end to navigate to the folder, or you having to download each file to a network folder first.
[quote]
You can sort of get this to happen, almost, in Excel post-export. If you don't mind fiddling with the file before sending it on to whomever is going to analyse it.
Assuming your filepath is in column Q and row 1 is headings, your formula in R2 to get the URL is:
="http://rootpath/"&LEFT(Q2,FIND(",",Q2,1)-1)
Where 'rootpath' is the part of the Web Path for up to the folder the files are deposited into when uploaded.
This will display the URL to the file. You can use Excel's HYPERLINK formula wrapped around it, but I find it fails to open on clicking. Perhaps Excel is trying to open the (MS Word, in my test case) file natively rather than using a browser as it's a hyperlink? Anyway, the path is there and your person analysing could at least then copy/paste each one into a browser. So it's still an extra step or two, but better than showing them how to use the back end to navigate to the folder, or you having to download each file to a network folder first.
[/quote]
Thanks for your suggestion but all of our users download their submissions directly via "_edit" so this is probably not the option we'll explore but thanks for your time and explanation!