10 Replies Latest reply on Jul 13, 2011 10:17 AM by brian.curran

    Using a field to calculate a URL path?

    brian.curran

      Title

      Using a field to calculate a URL path?

      Post

      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:
      LocationMap
      SitePlan
      ZoneList
      KeyHolders

      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" 

      Thanks
      Brian.