Get corresponding filepath by selecting a file using File Dialog Box
I am working on a record which stores filepath of different images. I have a button which executes script "Open URL" to open the image from filepath. Instead of typing the whole filepath as a field value (it is a text field), I want a file dialog box to appear and it allows a user to select a file. Moreover corresponding filepath of the selected file should be stored in the field.
Also if a shared network drive (eg. \\path-fst1.ad.XXX.edu\Public\) is mapped to a drive (eg. Z:) , is there a way to extract the mapped info and get the whole path when select a file from the file dialog box.
eg. Instead of filepath: Z:\\Mary Kovalovsky\Analog MM11-11111 Mamma.bif, it should be:
\\path-fst1.ad.XXX.edu\Public\Mary Kovalovsky\Analog MM11-11111 Mamma.bif
Let me know if you want more details.
Thanks in advance!!