MBS FileMaker Plugin Example Databases

Send Email via Email Application

All examples are included with download of MBS FileMaker Plugin.

Send Email via Email Application.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts4
Value Lists0
Custom Functions0
Custom Menus0
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Send
13 fields defined, 4 records
Send

Fields

Table Name: Send - 13 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
From EmailNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      From NameNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          To EmailNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              To NameNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  CC EmailNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      CC NameNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          BCC EmailNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              BCC NameNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  SubjectNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      TextNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          DescriptionNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                                Attachment ContainerNormal, BinaryAuto-Enter:
                                                • Allow editing
                                                Validation:
                                                • Only during data entry
                                                Storage:
                                                • Repetitions: 1
                                                    Attachment FileNormal, TextAuto-Enter:
                                                    • Allow editing
                                                    Validation:
                                                    • Only during data entry
                                                    Storage:
                                                    • Repetitions: 1
                                                    • Indexing: None
                                                    • Automatically create indexes as needed
                                                    • Index Language: German

                                                        Layout Objects: Send

                                                        Regular Fields

                                                        Field Name: Send::From Email
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 62 pt
                                                        • Left: 93 pt
                                                        • Bottom: 84 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::From Name
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 86 pt
                                                        • Left: 93 pt
                                                        • Bottom: 108 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::To Email
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 110 pt
                                                        • Left: 93 pt
                                                        • Bottom: 132 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::To Name
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 134 pt
                                                        • Left: 93 pt
                                                        • Bottom: 156 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::CC Email
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 158 pt
                                                        • Left: 93 pt
                                                        • Bottom: 180 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::CC Name
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 182 pt
                                                        • Left: 93 pt
                                                        • Bottom: 204 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::BCC Email
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 206 pt
                                                        • Left: 93 pt
                                                        • Bottom: 228 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::BCC Name
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 230 pt
                                                        • Left: 93 pt
                                                        • Bottom: 252 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::Subject
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 64 pt
                                                        • Left: 561 pt
                                                        • Bottom: 86 pt
                                                        • Right: 814 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::Text
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 88 pt
                                                        • Left: 561 pt
                                                        • Bottom: 338 pt
                                                        • Right: 814 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::Description
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 343 pt
                                                        • Left: 561 pt
                                                        • Bottom: 390 pt
                                                        • Right: 814 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Field Name: Send::Attachment Container
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 254 pt
                                                        • Left: 93 pt
                                                        • Bottom: 379 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        No

                                                        Field Name: Send::Attachment File
                                                        Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                        • Top: 384 pt
                                                        • Left: 93 pt
                                                        • Bottom: 406 pt
                                                        • Right: 346 pt
                                                        • Anchoring: Left, Top
                                                        Field Format:
                                                        • Edit Box
                                                        Field Behavior:
                                                        • Allow field to be entered: In Find mode, In Browse mode
                                                        • Touch keyboard type: Default for Data Type
                                                        • Go to next field using: Tab key
                                                        Yes

                                                        Buttons

                                                        Button PropertiesCoordinatesScript/Script Step
                                                          Type:
                                                        • Text: Send Email
                                                        • Top: 65 pt
                                                        • Left: 851 pt
                                                        • Bottom: 88 pt
                                                        • Right: 1003 pt
                                                        • Anchoring: Left, Top
                                                        Perform Script [ “Send Email” ]

                                                        Scripts:


                                                        Button PropertiesCoordinatesScript/Script Step
                                                          Type:
                                                        • Text: Select File
                                                        • Top: 384 pt
                                                        • Left: 350 pt
                                                        • Bottom: 407 pt
                                                        • Right: 474 pt
                                                        • Anchoring: Left, Top
                                                        Perform Script [ “Select Attachment” ]

                                                        Scripts:


                                                        Button PropertiesCoordinatesScript/Script Step
                                                          Type:
                                                        • Text: Import Picture
                                                        • Top: 257 pt
                                                        • Left: 356 pt
                                                        • Bottom: 280 pt
                                                        • Right: 474 pt
                                                        • Anchoring: Left, Top
                                                        Perform Script [ “Import Picture” ]

                                                        Scripts:


                                                        Button PropertiesCoordinatesScript/Script Step
                                                          Type:
                                                        • Text: Import File
                                                        • Top: 282 pt
                                                        • Left: 357 pt
                                                        • Bottom: 306 pt
                                                        • Right: 475 pt
                                                        • Anchoring: Left, Top
                                                        Perform Script [ “Import File” ]

                                                        Scripts:


                                                        Script Hierarchy

                                                        Send Email
                                                        Select Attachment
                                                        Import Picture
                                                        Import File

                                                        Next Script: [Select Attachment]
                                                        Script NameSend Email
                                                        Run script with full access privilegesOff
                                                        Include In MenuYes
                                                        Layouts that use this script
                                                        Scripts that use this script
                                                          Script Definition
                                                          Script Steps
                                                          • Set Variable [ $email; Value:MBS( "WinSendMail.CreateEmail" ) ]
                                                          • If [ not IsEmpty ( Send::To Email ) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.AddTo"; $email; Send::To Email ; Send::To Name ) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::CC Email ) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.AddCC"; $email; Send::CC Email ; Send::CC Name ) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::BCC Email ) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.AddBCC"; $email; Send::BCC Email ; Send::BCC Name ) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::From Email ) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.SetFrom"; $email; Send::From Email ; Send::From Name ) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::Subject ) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.SetSubject"; $email; Send::Subject ) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::Text) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.SetText"; $email; Send::Text) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::Attachment Container) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.AddAttachmentContainer"; $email; Send::Attachment Container ) ]
                                                          • End If
                                                          • If [ not IsEmpty ( Send::Attachment File) ]
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.AddAttachmentFile"; $email; Send::Attachment File ) ]
                                                          • End If
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.Send"; $email ) ]
                                                          • If [ MBS("IsError") ]
                                                          • Show Custom Dialog [ Title: "Failed to send email"; Message: $r; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                          • Else
                                                          • Pause/Resume Script [ Duration (seconds): 2 ]
                                                          • End If
                                                          • Set Variable [ $r; Value:MBS( "WinSendMail.Release"; $email ) ]
                                                          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]Next Script: [Import Picture]
                                                                  Script NameSelect Attachment
                                                                  Run script with full access privilegesOff
                                                                  Include In MenuYes
                                                                  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: [Select Attachment]Next Script: [Import File]
                                                                            Script NameImport Picture
                                                                            Run script with full access privilegesOff
                                                                            Include In MenuYes
                                                                            Layouts that use this script
                                                                            Scripts that use this script
                                                                              Script Definition
                                                                              Script Steps
                                                                              • Go to Field [ Send::Attachment Container ]
                                                                              • Insert Picture [ ]
                                                                              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: [Import Picture]
                                                                                      Script NameImport File
                                                                                      Run script with full access privilegesOff
                                                                                      Include In MenuYes
                                                                                      Layouts that use this script
                                                                                      Scripts that use this script
                                                                                        Script Definition
                                                                                        Script Steps
                                                                                        • Go to Field [ Send::Attachment Container ]
                                                                                        • Insert File [ ] [ Storage method: Let user choose ] [ Display icon ] [ Compression: Let user choose ]
                                                                                        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: Send Email via Email Application

                                                                                                Used functions:




                                                                                                Links
                                                                                                MBS Xojo Plugins