Creating a dynamic file reference as a text field
Posted on 2007-03-23
I am using an email plug called mailit that can send emails within Filemaker with attachments. I have created a script that grabs the file reference for the attachment from a global field. The only way it works is if the file reference is a text field with the reference contained in quotes.
I wanted to change the file reference so that it works on any computer. I tried changing the contents of the global field to Substitute(Quote(Get( DesktopPath) & "Inventory Update.xls");"/C";"C"), and it didnt work.
I am not sure what to do