I am creating a list of files from all over my filesystem and would like to include the file path each entry
What do you mean by "link"?
sorry, could have been clearer.
I want to copy a filepath from a Finder file 'get info' window and paste it into a FMP field as a text string which, when clicked, will take me to the file ( or better still, the enclosing folder)
Try a script with the Open URL step, using this calculation:
Let ( [
pathList = Substitute ( YourTable::yourLinkField ; "/" ; ¶ ) ;
enclosingPathList = LeftValues ( pathList ; ValueCount ( pathList ) - 1 ) ;
enclosingPath = Substitute ( enclosingPathList ; ¶ ; "/" )
"file://" & enclosingPath
Retrieving data ...