I have searched but found no solution.
Users can upload supporting documentation to mileage forms in container fields on a locally hosted Windows Server 2012 FM server. The base directory, therefore, is unalterable. Open storage is at:
"Mileage/" & staffer & "/Form#" & form_id & "/document1/"
It ends up on the server machine at a place like:
F:\Program Files\FileMaker\FileMaker Server\Data\Databases\RC_Data_FMS\PowerStation\Files\PowerStation\Mileage\Alejandra Solorio\Form#2414\document1
I'm trying to send an email with that document attached by using a calculated variable file path, such as:
"filewin:\\\F:\Program Files\FileMaker\FileMaker Server\Data\Databases\RC_Data_FMS\PowerStation\Files\PowerStation\Mileage\\" &
Staff::staffer & "\\" & Mileage Forms::form_id & "document1\\" &
GetContainerAttribute ( Mileage Forms::file1 ; "filename" )
I have tried many different variations with backslashes and forward slashes, and a share name for the documents folder, never successfully getting the doc to attach.
Any body know what to do? That would be fantastic. -- Victor