vaguiar

Attaching externally stored container field documents to email in scheduled script

Discussion created by vaguiar on Oct 18, 2017
Latest reply on Oct 23, 2017 by vaguiar

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

Outcomes