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

MBS FileMaker Plugin Example Databases

Change Letter Case

All examples are included with download of MBS FileMaker Plugin.

Change Letter Case.fmp12

Overview
Tables 1
Relationships 0
Layouts 1
Scripts 1
Value Lists 0
Custom Functions 0
Custom Menus 33
File Options
Default custom menu set [Standard FileMaker Menus]
Default theme Minimalistisch
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
Change Letter Case
8 fields defined, 1 record
 Change Letter Case

Fields

Table Name: Change Letter Case - 8 Fields
Field Name Type Options Comments On Layouts In Relationships In Scripts In Value Lists
Input Normal, Text Auto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
        LowerCase Plugin Normal, Text Auto-Enter: Validation:
        • Only during data entry
        Storage:
        • Repetitions: 1
        • Indexing: None
        • Automatically create indexes as needed
        • Index Language: German
              LowerCase FileMaker Normal, Text Auto-Enter: Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                    UpperCase Plugin Normal, Text Auto-Enter: Validation:
                    • Only during data entry
                    Storage:
                    • Repetitions: 1
                    • Indexing: None
                    • Automatically create indexes as needed
                    • Index Language: German
                          UpperCase FileMaker Normal, Text Auto-Enter: Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                                CapitalCase Plugin Normal, Text Auto-Enter: Validation:
                                • Only during data entry
                                Storage:
                                • Repetitions: 1
                                • Indexing: None
                                • Automatically create indexes as needed
                                • Index Language: German
                                      Remove Accents Normal, Text Auto-Enter: Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                            Remove Accents Case Insenstive Normal, Text Auto-Enter: Validation:
                                            • Only during data entry
                                            Storage:
                                            • Repetitions: 1
                                            • Indexing: None
                                            • Automatically create indexes as needed
                                            • Index Language: German

                                                  Layout Objects: Change Letter Case

                                                  Regular Fields

                                                  Field Name: Change Letter Case::Input
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 60 pt
                                                  • Left: 227 pt
                                                  • Bottom: 79 pt
                                                  • Right: 480 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: Change Letter Case::LowerCase Plugin
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 83 pt
                                                  • Left: 227 pt
                                                  • Bottom: 102 pt
                                                  • Right: 480 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: Change Letter Case::LowerCase FileMaker
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 106 pt
                                                  • Left: 227 pt
                                                  • Bottom: 125 pt
                                                  • Right: 480 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: Change Letter Case::UpperCase Plugin
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 129 pt
                                                  • Left: 227 pt
                                                  • Bottom: 148 pt
                                                  • Right: 480 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: Change Letter Case::UpperCase FileMaker
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 152 pt
                                                  • Left: 227 pt
                                                  • Bottom: 171 pt
                                                  • Right: 480 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: Change Letter Case::CapitalCase Plugin
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 175 pt
                                                  • Left: 227 pt
                                                  • Bottom: 194 pt
                                                  • Right: 480 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: Change Letter Case::Remove Accents
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 198 pt
                                                  • Left: 227 pt
                                                  • Bottom: 217 pt
                                                  • Right: 480 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: Change Letter Case::Remove Accents Case Insenstive
                                                  Field Properties Coordinates Field Format Field Behavior Quick Find
                                                  • Top: 221 pt
                                                  • Left: 227 pt
                                                  • Bottom: 240 pt
                                                  • Right: 480 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

                                                  Script Hierarchy

                                                  Trace

                                                  Script Name Trace
                                                  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 Variable [ $r; Value:MBS("Trace") ]
                                                      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: Change Letter Case

                                                                    Used functions: