Hi,

Steps to create a formula field which contains an hyperlink to a local file.
Knowledge Article Number: 838295  


Description
Steps to create a formula field which contains an hyperlink to a local file.


Resolution
For creating a link to a network/local file, you may need a custom text file (to introduce the path) and a formula field. A URL field will always add "http://" prefix.  Please follow the steps below:

1. Create a text field (for example, with the following name: "Path")
(Setup | Customize | {Object} |Fields and click New in the Custom Fields & Relationships section of the page)
2. Create formula field with data type: Text (for example, with the following name: "File")  to link to that file:

HYPERLINK("file://"&{!Path__c},"View")

You now have a link, called "View," for example, with which the file can be accessed directly from the object by right clicking and selecting "Save Target As."

You can also use this concept to point to network folders - create a formula field on the Account record which links to the network folder for that client, etc.
NOTE: For security purposes, Mozilla applications block links to local files (and directories) from remote files. This includes linking to files on your hard drive, on mapped network drives, and accessible via (UNC) paths. To have access to those files you need to install "Local Link" add-on in your Firefox: http://kb.mozillazine.org/Links_to_local_pages_don%27t_work

Hope this helps !!
--
Thanks,
Swayam