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 HTML Email with inline graphics
All examples are included with download of MBS FileMaker Plugin.
Build and send HTML Email with inline graphics.fmp12
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 |
13 fields defined, 1 record
| ||
Recipient |
4 fields defined, 2 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 HTML Email with inline graphics.fmp12 | Build and send HTML Email with inline graphics.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 |
Field Name: EMail::Recipient | |||||
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 HTML Email with inline graphics
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
- Text.EncodeToHTML
- Text.ReplaceNewline