Using a field to calculate a URL path?
Is it possible to calculate a URL that a Web viewer can use to find and display an image or PDF from an online source?
I have a shared folder on Dropbox.com that will soon contain hundreds of other folders.
Each of these sub-folders will be named with a 3-digit number such as 587 which will match the PK for a customer site.
A sub-folder will contain a number of files relating to a site such as:
These files may be a mixture of .jpg .png .pdf so it would be helpful if I didn't have to specify the file extension if possible.
I'm sure there is probably a better way of doing this but at the moment I have a tab that contains 5 sub-tabs, each one is to display the online files listed above. I will probably change this later to a single web viewer and 5 buttons, 1 for each file.
Back to the question, the calculation field would need to do something like:
http://www.dropbox.com/myprofile/appendices/"find 3-digit PK folder"/"show whatever file begins with SitePlan"