| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
MBS FileMaker Plugin Example Databases
Build and send Email
All examples are included with download of MBS FileMaker Plugin.
| Overview | |
| Tables | 3 |
| Relationships | 2 |
| Layouts | 3 |
| Scripts | 4 |
| Value Lists | 1 |
| Custom Functions | 0 |
| Custom Menus | 33 |
| File Options | |
| Default custom menu set | [Standard FileMaker Menus] |
| When opening file | |
| Minimum allowed version | 12.0 |
| Login using | Account Name; Account= Admin |
| Allow user to save password | Off |
| Require iOS passcode | Off |
| Switch to layout | Off |
| Hide all toolbars | Off |
| Script triggers | |
| OnFirstWindowOpen | Off |
| OnLastWindowClose | Off |
| OnWindowOpen | Off |
| OnWindowClose | Off |
| OnFileAVPlayerChange | Off |
| Thumbnail Settings | |
| Generate Thumbnails | On; Temporary |
| Table Name |
Statistics
| Occurrences in Relationship Graph |
|
12 fields defined, 1 record
| ||
| Recipient |
4 fields defined, 4 records
| Recipient |
| Attachment |
5 fields defined, 2 records
| Attachment |
| Table Name: Recipient - 4 Fields | ||||||||
| Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
| Type | Normal, Text | Auto-Enter:
|
|
|
||||
| Name | Normal, Text | Auto-Enter:
|
|
|
||||
| Normal, Text | Auto-Enter:
|
|
|
|||||
| EmailID | Normal, Number | Auto-Enter:
|
|
|
||||
Relationship: EMail=Attachment
| Table Occurrence | Attachment | ||
| Field | EmailID | = | EmailID |
| Source Table | Attachment | ||
| Source File | Build and send Email.fmp12 | Build and send Email.fmp12 | |
| Allow creation of records via this relationship | Off | Off | |
| Delete related records in this table when a record is deleted in the other table | Off | Off | |
| Sort records |
Off | Off |
Layout Hierarchy
EMail
Recipient
Attachment
| Layout Name | Include In Menu | Quick Find | # of Objects | Show Records From | Save record changes automatically | Show field frames when record is active | Show field frames only on current record | Show current record indicator in List View | Used in Scripts | Custom Menu Set | Script Triggers | Theme ID |
| Yes | Yes | On | On | Off | On | [File Default] | 01 | |||||
| Recipient | Yes | Yes | Recipient | On | On | Off | On | [File Default] | 01 | |||
| Attachment | Yes | Yes | Attachment | On | On | Off | On | [File Default] | 01 |
Layout Objects: EMail
| Field Name: EMail::SMTP Server | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No | |
| Field Name: EMail::SMTP Username | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No | |
| Field Name: EMail::SMTP Password | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No | |
| Field Name: EMail::Subject | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::FromName | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::PlainText | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::HTMLText | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::EmailID | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Recipient::Type | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Recipient::Name | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Recipient::Email | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Attachment::Name | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Attachment::Type | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Attachment::Container | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No | |
| Field Name: Attachment::Path | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::FromEmail | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::EmailSource | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::DebugInput | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: EMail::DebugMessages | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Button Properties | Coordinates | Script/Script Step | |||
|
| Perform Script [ “Build Email” ] Scripts: |
|||
| Button Properties | Coordinates | Script/Script Step | |||
|
| Perform Script [ “Send Email” ] Scripts: |
|||
| Portal Properties | Coordinates | Fields | Options | ||
|
| Field Objects
|
|
||
| Portal Properties | Coordinates | Fields | Options | ||
|
| Field Objects
|
|
||
Layout Objects: Recipient
| Field Name: Recipient::Type | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Recipient::Name | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Recipient::Email | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Recipient::EmailID | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
Layout Objects: Attachment
| Field Name: Attachment::Name | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Attachment::Type | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Attachment::Container | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| No | |
| Field Name: Attachment::Path | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Field Name: Attachment::EmailID | |||||
| Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes | |
| Value List Name | Source | Values | On Layouts |
| RecipientTypes | Custom |
|
| Run |
| Build Email |
| Send Email |
| Clean Logs |
| Next Script: [Build Email] |
| Script Name | Run |
| Run script with full access privileges | Off |
| Include In Menu | No |
| Layouts that use this script |
|
| Scripts that use this script | |
| Script Definition | |
| Script Steps |
|
| Fields used in this script |
|
| Scripts used in this script |
|
| Layouts used in this script | |
| Tables used in this script | |
| Table occurrences used by this script | |
| Custom Functions used by this script |
|
| Custom menu set used by this script |
|
| Previous Script: [Run] | Next Script: [Send Email] |
| Script Name | Build Email |
| Run script with full access privileges | Off |
| Include In Menu | Yes |
| Layouts that use this script | |
| Scripts that use this script |
|
| Script Definition | |
| Script Steps |
|
| Fields used in this script |
|
| Scripts used in this script | |
| Layouts used in this script |
|
| Tables used in this script |
|
| Table occurrences used by this script |
|
| Custom Functions used by this script |
|
| Custom menu set used by this script |
|
| Previous Script: [Build Email] | Next Script: [Clean Logs] |
| Script Name | Send Email |
| Run script with full access privileges | Off |
| Include In Menu | Yes |
| Layouts that use this script | |
| Scripts that use this script |
|
| Script Definition | |
| Script Steps |
|
| Fields used in this script |
|
| Scripts used in this script | |
| Layouts used in this script |
|
| Tables used in this script |
|
| Table occurrences used by this script |
|
| Custom Functions used by this script |
|
| Custom menu set used by this script |
|
| Previous Script: [Send Email] |
| Script Name | Clean Logs |
| Run script with full access privileges | Off |
| Include In Menu | Yes |
| Layouts that use this script |
|
| Scripts that use this script |
|
| Script Definition | |
| Script Steps |
|
| Fields used in this script | |
| Scripts used in this script |
|
| Layouts used in this script |
|
| Tables used in this script | |
| Table occurrences used by this script | |
| Custom Functions used by this script |
|
| Custom menu set used by this script |
|
Download example: Build and send Email
Used functions:- CURL.GetDebugMessages
- CURL.GetInputAsText
- CURL.New
- CURL.Perform
- CURL.Release
- CURL.SetOptionCAInfo
- CURL.SetOptionPort
- CURL.SetOptionSSLVerifyHost
- CURL.SetOptionSSLVerifyPeer
- CURL.SetOptionSSLVersion
- CURL.SetOptionUseSSL
- SendMail.AddAttachmentContainer
- SendMail.AddAttachmentFile
- SendMail.AddBCC
- SendMail.AddCC
- SendMail.CreateEmail
- SendMail.GetSource
- SendMail.PrepareCURL
- SendMail.Release
- SendMail.SetFrom
- SendMail.SetHTMLText
- SendMail.SetPlainText
- SendMail.SetSMTPPassword
- SendMail.SetSMTPServer
- SendMail.SetSubject
- String.ReplaceNewline