Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2013
    Posts
    11
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Hyperlink Location

    I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.

    The location filed looks like

    M:\New\1234.pdf
    M:\New\1111.pdf
    M:\New\2222pdf
    M:\New\4444pdf

    If the user clicks on this link then the respective file should be open

    I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:\New\1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    There are several ways to solve this problem. One is to create a separate field which contains the path to the directory/folder where the file is stored, and then concatenate the two fields to form the hyperlink when the field is clicked (I would suggest using a double click). The other is to use the InStrRev() function to find the last "\" character in the field and only display the text from that point to the end. See InStrRev Function for the syntax.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •