Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

MBS FileMaker Plugin Example Databases

List IMAP folders

All examples are included with download of MBS FileMaker Plugin.

List IMAP folders.fmp12

Overview
Tables 1
Relationships 0
Layouts 1
Scripts 2
Value Lists 0
Custom Functions 0
Custom Menus 33
File Options
Default custom menu set [Standard FileMaker Menus]
Default theme Classic
When opening file
Minimum allowed version 12.0
Login using Account Name; Account= Admin
Allow user to save password On
Require iOS passcode Off
Show Sign-in fields Off
Switch to layout Off
Hide all toolbars Off
Script triggers
OnFirstWindowOpen Off
OnLastWindowClose Off
OnWindowOpen Off
OnWindowClose Off
OnFileAVPlayerChange Off
OnWindowTransaction Off
Thumbnail Settings
Generate Thumbnails On; Temporary

 

Tables

Table Name
Statistics
Comments
Occurrences in Relationship Graph
CURL Test
5 fields defined, 1 record
CURL Test

Fields

Table Name: CURL Test - 5 Fields
Field Name Type Options Comments On Layouts In Relationships In Scripts In Value Lists
Result Normal, Text Auto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      Text Normal, Text Auto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          header Normal, Text Auto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              debug Normal, Text Auto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  URL Normal, Text Auto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German

                      Layout Objects: CURL Test

                      Regular Fields

                      Field Name: CURL Test::Result
                      Field Properties Coordinates Field Format Field Behavior Quick Find
                      • Top: 29 pt
                      • Left: 138 pt
                      • Bottom: 43 pt
                      • Right: 391 pt
                      • Anchoring: Left, Top
                      Field Format:
                      • Edit Box
                      Field Behavior:
                      • Allow field to be entered: In Find mode, In Browse mode
                      • Touch keyboard type: System Default
                      • Go to next field using: Tab key
                      Yes

                      Field Name: CURL Test::Text
                      Field Properties Coordinates Field Format Field Behavior Quick Find
                      • Top: 47 pt
                      • Left: 138 pt
                      • Bottom: 175 pt
                      • Right: 391 pt
                      • Anchoring: Left, Top
                      Field Format:
                      • Edit Box
                      Field Behavior:
                      • Allow field to be entered: In Find mode, In Browse mode
                      • Touch keyboard type: System Default
                      • Go to next field using: Tab key
                      Yes

                      Field Name: CURL Test::header
                      Field Properties Coordinates Field Format Field Behavior Quick Find
                      • Top: 179 pt
                      • Left: 138 pt
                      • Bottom: 475 pt
                      • Right: 547 pt
                      • Anchoring: Left, Top
                      Field Format:
                      • Edit Box
                      Field Behavior:
                      • Allow field to be entered: In Find mode, In Browse mode
                      • Touch keyboard type: System Default
                      • Go to next field using: Tab key
                      Yes

                      Field Name: CURL Test::URL
                      Field Properties Coordinates Field Format Field Behavior Quick Find
                      • Top: 11 pt
                      • Left: 138 pt
                      • Bottom: 25 pt
                      • Right: 553 pt
                      • Anchoring: Left, Top
                      Field Format:
                      • Edit Box
                      Field Behavior:
                      • Allow field to be entered: In Find mode, In Browse mode
                      • Touch keyboard type: System Default
                      • Go to next field using: Tab key
                      Yes

                      Field Name: CURL Test::debug
                      Field Properties Coordinates Field Format Field Behavior Quick Find
                      • Top: 180 pt
                      • Left: 612 pt
                      • Bottom: 476 pt
                      • Right: 925 pt
                      • Anchoring: Left, Top
                      Field Format:
                      • Edit Box
                      Field Behavior:
                      • Allow field to be entered: In Find mode, In Browse mode
                      • Touch keyboard type: System Default
                      • Go to next field using: Tab key
                      Yes

                      Group Buttons

                      Button Properties Coordinates Script/Script Step
                        Type:
                      • Text: Query folder list
                        Additional Properties:
                      • Change to hand cursor over button
                      • Rectangular
                      • Top: 48 pt
                      • Left: 421 pt
                      • Bottom: 73 pt
                      • Right: 553 pt
                      • Anchoring: Left, Top
                      Perform Script [ “Query Folder List” ]

                      Scripts:


                      Button Properties Coordinates Script/Script Step
                        Type:
                      • Text: Trace on
                        Additional Properties:
                      • Change to hand cursor over button
                      • Rectangular
                      • Top: 485 pt
                      • Left: 12 pt
                      • Bottom: 510 pt
                      • Right: 145 pt
                      • Anchoring: Left, Top
                      Set Variable [ $result; Value:MBS("Trace") ]

                      Script Hierarchy

                      Query Folder List
                      Clear

                      Next Script: [Clear]
                      Script Name Query Folder List
                      Run script with full access privileges Off
                      Siri Shortcut Visible Off
                      Include In Menu Yes
                      Layouts that use this script
                      Scripts that use this script
                        Script Definition
                        Script Steps
                        • #Start new session
                        • Set Variable [ $curl; Value:MBS("CURL.New") ]
                        • #Set URL to load (HTTP, HTTPS, FTP, FTPS, SFTP, etc.)
                        • Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; CURL Test::URL) ]
                        • #login via username and password
                        • Set Variable [ $result; Value:MBS("CURL.SetOptionUsername"; $curl; "alte-emails@monkeybreadsoftware.de") ]
                        • Set Variable [ $result; Value:MBS("CURL.SetOptionPassword"; $curl; "xxxx") ]
                        • #or if you have a token for gmail or office365 instead of a password
                        • // Set Variable [ $r; Value:MBS("CURL.SetOptionXOAuth2Bearer"; $curl; "xxx") ]
                        • #use encrypted connection
                        • Set Variable [ $result; Value:MBS("CURL.SetOptionUseSSL"; $curl; 3) // required ]
                        • Set Variable [ $result; Value:MBS("CURL.SetOptionSSLVersion"; $curl; 6) // TLS v1.2 ]
                        • Set Variable [ $result; Value:MBS("CURL.SetOptionPort"; $curl; 993) ]
                        • #RUN now
                        • Set Field [ CURL Test::Result; MBS("CURL.Perform"; $curl) ]
                        • #Check result
                        • Set Field [ CURL Test::header; MBS("CURL.GetHeaders"; $curl) ]
                        • Set Field [ CURL Test::debug; MBS("CURL.GetDebugMessages"; $curl) ]
                        • Set Variable [ $text; Value:MBS("CURL.GetResultAsText"; $curl) ]
                        • Set Field [ CURL Test::Text; $text ]
                        • #Cleanup
                        • Set Variable [ $result; Value:MBS("CURL.Release"; $curl) ]
                        • #Look for Sent folder
                        • Set Variable [ $count; Value:ValueCount($text) ]
                        • Set Variable [ $i; Value:1 ]
                        • Loop [ Flush: Always ]
                        • Set Variable [ $line; Value:GetValue($text; $i) ]
                        • If [ Position ( $line ; "\Sent" ; 1 ; 1 ) > 0 ]
                        • Set Variable [ $name; Value:RightWords ( $line ; 1 ) ]
                        • Show Custom Dialog [ Title: "Found sent folder."; Message: "Folder named: " & $name; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                        • End If
                        • #next
                        • Set Variable [ $i; Value:$i + 1 ]
                        • Exit Loop If [ $i > $count ]
                        • End Loop
                        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: [Query Folder List]
                                Script Name Clear
                                Run script with full access privileges Off
                                Siri Shortcut Visible Off
                                Include In Menu Yes
                                Layouts that use this script
                                  Scripts that use this script
                                    Script Definition
                                    Script Steps
                                    • Set Field [ CURL Test::Result; "" ]
                                    • Set Field [ CURL Test::Text; "" ]
                                    • Set Field [ CURL Test::header; "" ]
                                    • Set Field [ CURL Test::debug; "" ]
                                    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: List IMAP folders

                                            Used functions: