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

MBS FileMaker Plugin Example Databases

Word Count functions

All examples are included with download of MBS FileMaker Plugin.

Word Count functions.fmp12

Overview
Tables1
Relationships1
Layouts1
Scripts0
Value Lists1
Custom Functions0
Custom Menus24
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
MBA Functions
5 fields defined, 3 records
MBA Functions 2, MBA Functions

Fields

Table Name: MBA Functions - 5 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
TextNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: All
  • Index Language: English
      ResultCountWordsCalculated, TextCalculation: Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: English
            ResultListWordsCalculated, TextCalculation: Storage:
            • Repetitions: 1
            • Indexing: Minimal
            • Automatically create indexes as needed
            • Index Language: English
                ResultCountValuesCalculated, TextCalculation: Storage:
                • Repetitions: 1
                • Indexing: None
                • Automatically create indexes as needed
                • Index Language: English
                      ResultAllCalculated, TextCalculation: Storage:
                      • Repetitions: 1
                      • Do not store calculation results
                      • Index Language: English

                            Layout Objects: MBA Functions

                            Regular Fields

                            Field Name: MBA Functions::Text
                            Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                            • Top: 29 pt
                            • Left: 57 pt
                            • Bottom: 433 pt
                            • Right: 358 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: MBA Functions::ResultCountWords
                            Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                            • Top: 315 pt
                            • Left: 482 pt
                            • Bottom: 542 pt
                            • Right: 735 pt
                            • Anchoring: Left, Top
                            		Field Format:
                            • Edit Box
                            • Include vertical scrollbar
                            		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: MBA Functions::ResultListWords
                            Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                            • Top: 29 pt
                            • Left: 482 pt
                            • Bottom: 164 pt
                            • Right: 735 pt
                            • Anchoring: Left, Top
                            		Field Format:
                            • Edit Box
                            • Include vertical scrollbar
                            		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: MBA Functions::ResultCountValues
                            Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                            • Top: 172 pt
                            • Left: 482 pt
                            • Bottom: 307 pt
                            • Right: 735 pt
                            • Anchoring: Left, Top
                            		Field Format:
                            • Edit Box
                            • Include vertical scrollbar
                            		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: MBA Functions::ResultAll
                            Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                            • Top: 33 pt
                            • Left: 746 pt
                            • Bottom: 538 pt
                            • Right: 999 pt
                            • Anchoring: Left, Top
                            		Field Format:
                            • Edit Box
                            • Include vertical scrollbar
                            		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

                            Value Lists

                            Value List NameSourceValuesOn Layouts
                            RelatedField

                              Download example: Word Count functions

                              Used functions: