mailto script step

[Capt JB]

Hi,

 

not sure I am in the correct place - sorry moderator if you have to move this post around.

 

I made a simple script mailto, passed all the steps to find out that to get an attachment FMP12 is looking for a file path.

The database stores PDF files, I want to be able to share throughout email.

Is there any trick to go around and send the PDF stored in the PDF field as an attachment to the email...?? 

Storing the PDF in a folder and only the location into the PDF Field has the advantage to keep the database slim, but any wrong manipulation of the folder can ruin work, and oblige to rebuilt all the file path ..

On other hand, if I want to pass the database to iPad, I'll be obliged to pass the "store folder" too... I have no iPad to check if the file path becomes a problem....

 

I am kind of stock here and any help will be appreciated.

 

[HALBURN]

I don't fully understand your question or the problem that you are trying to solve. Are you generating the PDF that you want to email in FileMaker or do you want to email an existing PDF that is being stored within a container field?

[Capt JB]

Hi,

 

I have PDF files stored into a container field in the database, I would like to have the file stored into the field attached to the mail I send..

I am looking for a trick to go around the FMP process which look for a file path to get the file as attached.. 

Any help will be very much appreciated

[HALBURN]

Here is a solution by AHunter3:
 
You would first set a variable, let's call it $AttachmentPath, to GetValue (GetAsText (YourContainerField); 2) and then do this:

Send Mail [To, Subject, Body set as you normally do; specify attachment as $AttachmentPath]

If the container field file is stored IN FileMaker (i.e., not "as a reference") you would need to export it first, using Export Field Contents and specifying the full path to export it to.  The file NAME will usually be returned if you query GetAsText (YourContainerField) -->  "myfile.xls"  so you'd set your $AttachmentPath variable to Get (TemporaryPath) & GetAsText (YourContainerField) and then do this:

Export Field Contents [no dialog, YourTable::YourContainerField, to $AttachmentPath]
Send Mail [To, Subject, Body set as you normally do; specify attachment as $AttachmentPath]

[Capt JB]

Whooaaa, Thanks, 

I am going to try this and let you know what happened..

[HALBURN]

Yes, please do, I am curious to know if it works from an iPad.

 

If you don't have access to an iPad and want me to test it for you please send me a demo file.

 

Good luck!