WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
We all know that email is the hottest new way to communicate since the paper and pencil. FileMaker has some basic email operations built in and of course you can also use plug-ins for more functionality.
The problem with e-mailing portal data is that it is spread out to 2 or more records. At the very minimum, we has the record in the primary file and the record in the child file. So what we need to do is combine all this information into a single field. Think of it as an assembly operation where you may need to combine a few scripts running in multiple files.
If you have FileMaker 8.5 or higher, the List function can be quite handy in gathering multiple related data that is displayed in a portal.
Another technique quite popular, global fields used with the SET Field script steps are great for providing a method to combine different pieces of text. You can script it so that all the child records are placed nicely into a global field. At the end of the operation, you will want to place the combined text string into either a standard text field or a global field that is suitable for e-mailing.
***Note: You can also use Copy, Copy Record, Copy All Records script steps to get information from related fields. I tend to stay away from all Copy related script steps because I don’t like interacting with the computers clipboard and I don't like the layout specific limitations it has. ***
Here are some links to other posts that might be of interest in regards to this topic...
The List Function
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2008 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.
====================== ADVERTISEMENT ==============================
For more information on the Virtual One On One Training, please visit http://www.dwaynewright.com/training.html===================================================================
Posts
