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