Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This > < Close to having FM Server save a found set as a .pdf, then e-mail to user


Recommended Posts

Posted

I'm close, but I don't know where I'm muffing it; the user receives the e-mail, but no .pdf file attachment. Here's the script text:

WHen the script runs, I get the attached error message. What do I need to tweak? (Running FMS v20.x on a Windows network.)

Cheers,

Rich

 

Screenshot 2024-10-09 at 2.44.02 PM.png

Screenshot 2024-10-09 at 2.45.15 PM.png

Posted

in your $_Path don't put "file: " 

I usually do this after Save as PDF:

SetVariable $url = "file://" & If ( Get ( SystemPlatform ) = 1 ; "/Volumes" ) & $_Path

Insert from URL Dialog Off Target $attachment ; $url : cURL options: "--FM-return_container-varable" 

The use that $attachment variable in the email

Posted

Thank you, but the user is still receiving an e-mail without an attachment. I _think_ it's because the $_Attachment variable hasn't been defined, yet, after making your recommended changes. (See attached.)

 

What changes should I make?

Thanks tons,

Rich

Screenshot 2024-10-10 at 1.18.04 PM.png

Posted

What happens if you do simply:

Set Variable [ $path ; Get ( TemporaryPath ) & "ESU 7 Monthly Product Code Summary Report.pdf" ]
Save Records as PDF [... ; "$path" ; ... ]
Send Mail [ ... ; "$path" ; ... ]

---
P.S. Please post your scripts as code, not as pictures.

 

 

Posted

Beauty! Thanks, that works.

...and sorry about the pictures vs. code. 

Posted
Just now, Rich S said:

that works.

Good.

Just a small note about the "file:" prefix: you don't have to use it in the present case. But if you do, it needs to be without the trailing space you have in your original script (which I believe would have worked otherwise).

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.