by using set variable you're only getting the text name of the container contents. Filemaker does not store container contents as variable strings, only text is stored.
If you want to use a variable for your attachment path (rather than the container table::field name directly), you need to export the field contents first, then use a variable path to that saved file.
Thanks for the reply.
I'm not too worried about using the variable, but I can't see there is a direct way to call the file location into the attachment properties without it.
Edit: Sorry having re-read I see what you are saying. I am trying to use the variable to find the location of the file, I've tried a fully qualified name but this doesn't seem to work.
You’re right, my non-caffienated mind thought it was a calc field and not a field path dialog.
You have to export the file and use the file path in a variable. Unfortunately "export field contents" is not a server compatible script step.
This beezwax article covers how to get around that, but it takes a bit of work to achieve:
Thanks again for your help - I do apreciate it.
I think I must be really confused as it seems like such a simple process in my mind. Locate file, attach it, send it.
Just to clarify...
....even though the file is stored externally (using the standard filemaker open storage RC_Data_FMS folder), I am not able to pickup and send the file even if I know the exact location of the file (I have tested this using both absolute and relative locations and it wouldn't work)?
1 of 1 people found this helpful
As per Mike's link it turns out the server can only work within the confines of some folders.