1 Reply Latest reply on Feb 27, 2013 9:49 AM by TSGal

    Exporting Excel Spreadsheet



      Exporting Excel Spreadsheet



           I have an Excel graphic icon on a iPad form that I would like users to click on to automatically send an email. Currently I am using the "Send Email" script for a button setup. The function works however I would like to attach an excel spreadsheet to the email that gets sent however I’m not sure what I should be setting as the file path. I've built the layout on my desktop and denoted a file coming directly from my desktop and it does not work. More so what is the file path once I copy this DB to my iPad? What is the path for the attachment once it’s on the iPad? I wish there was a way to indicate a FTP or Web Url to attach the file. I suppose I could always simply add a URL in the message body to have folks download the file however for their convenience it would be nice to have it already attached.

           Also because this file is not remotely associated to a current record adding it as a container is not conducive and doesn't offer all of the same options that are really nice with using the Send Email script.

           Any help would help, Thank you!

        • 1. Re: Exporting Excel Spreadsheet


               Thank you for your post.

               Only files in the FileMaker Go work area are accessible.  Therefore, either place the Excel file into a Container field, or sync the file over via iTunes to the FileMaker Go work area.  Then, in your Send Mail script step, attach the local filename.  If the file was in a Container, then use the Export Field Contents script step first.

               Let me know if you need additional clarification.

               FileMaker, Inc.