fmgo13 Help with Email script for iPad

[Nakizimbo]

As a filemaker novice I am having great difficulty getting the script correct so that I can send data from my filemaker database as an excel file from the iPad. 

 

My script is as below.  All I want to do is export all the fields as an Excel file from the current record being browsed.  It works fine when I use the "Export Records" script and the user then manually chooses Type:Excel, and the email is created with the excel attachment ready for the user to type in the recipeint email address.

 

Any help on what I am missing would be appreciated.  Using the script below I get everything I need except the attachment is not there.

 

 

 

[bcooney]

This might be the subtle difference FMGo13 has when it comes to READING a file. https://fmhelp.filemaker.com/docs/13/en/fmgo13_development.pdf See top of page 15. You need $path="file:" & Get (TemporaryPath) & $myfilename.ext

 

EDIT: Sorry, just reread your script. Save Records as Excel is NOT supported on FMGo13 (see p. 16 of dev guide. However, you can Export Records in the .xlsx format).

 

At the bottom left of the Edit Script window, select Show Compatibilty: iOS to avoid including unsupported script steps when you're developing for iOS.

[Nakizimbo]

Thanks bcoony for your help, I should have checked the compatibility first. It seems strange to me that FMGo can export as well as save a .xlsx file but you cannot have a script to put that file into an email and populate the To, subject and message fields automatically. Anyhow, you have shown me how yo do that with a PDF so I am one step firther ahead.

Cheers

[Rgordon]

FMGO can export an .xlsx but it can not save a copy to .xlsx. You can attach the file and fill out the email with a script in fmgo. Your script didn't work because you used Save Records as Excel instead of Export file type Excel. Your $path doesn't work because you didn't specify the file name. Your $path only specifies what folder the file is in. Without the name of the file, FileMaker has no idea what file to attach to the email.

[Nakizimbo]

Thanks for help.  I have now got this working and it works a treat.