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

MBS FileMaker Plugin Example Databases

All Get Functions

All examples are included with download of MBS FileMaker Plugin.

All Get Functions.fmp12

Overview
Tables 1
Relationships 0
Layouts 1
Scripts 2
Value Lists 0
Custom Functions 0
Custom Menus 24
File Options
Default custom menu set [Standard FileMaker Menus]
Default theme Apex Blue
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 On
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
All Get Functions
6 fields defined, 140 records
 All Get Functions

Fields

Table Name: All Get Functions - 6 Fields
Field Name Type Options Comments On Layouts In Relationships In Scripts In Value Lists
PrimaryKey Normal, Text Auto-Enter: Validation:
  • Only during data entry
  • Not empty
  • Unique
  • Strict validation
Storage:
  • Repetitions: 1
  • Indexing: Minimal
  • Automatically create indexes as needed
  • Index Language: Unicode Raw
 Unique identifier of each record in this table
          ID Normal, Number Auto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              Name Normal, Text Auto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                    Value Calculated, Text Calculation: Storage:
                    • Repetitions: 1
                    • Do not store calculation results
                    • Index Language: German
                        Description Normal, Text Auto-Enter:
                        • Allow editing
                        Validation:
                        • Only during data entry
                        Storage:
                        • Repetitions: 1
                        • Indexing: None
                        • Automatically create indexes as needed
                        • Index Language: German
                              Version 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: All Get Functions

                                    Regular Fields

                                    Field Name: All Get Functions::ID
                                    Field Properties Coordinates Field Format Field Behavior Quick Find
                                    • Top: 114 pt
                                    • Left: 5 pt
                                    • Bottom: 145 pt
                                    • Right: 106 pt
                                    • Anchoring: Left, Top
                                    		 Field Format:
                                    • Edit Box
                                    		 Field Behavior:
                                    • Allow field to be entered: In Find mode, In Browse mode
                                    • Disable visual spell-checking
                                    • Touch keyboard type: Default for Data Type
                                    • Go to next field using: Tab key
                                    		 Yes

                                    Field Name: All Get Functions::Name
                                    Field Properties Coordinates Field Format Field Behavior Quick Find
                                    • Top: 114 pt
                                    • Left: 113 pt
                                    • Bottom: 145 pt
                                    • Right: 366 pt
                                    • Anchoring: Left, Top
                                    		 Field Format:
                                    • Edit Box
                                    		 Field Behavior:
                                    • Allow field to be entered: In Find mode, In Browse mode
                                    • Disable visual spell-checking
                                    • Touch keyboard type: Default for Data Type
                                    • Go to next field using: Tab key
                                    		 Yes

                                    Field Name: All Get Functions::Value
                                    Field Properties Coordinates Field Format Field Behavior Quick Find
                                    • Top: 114 pt
                                    • Left: 373 pt
                                    • Bottom: 145 pt
                                    • Right: 626 pt
                                    • Anchoring: Left, Top
                                    		 Field Format:
                                    • Edit Box
                                    		 Field Behavior:
                                    • Allow field to be entered: In Browse mode
                                    • Touch keyboard type: Default for Data Type
                                    • Go to next field using: Tab key
                                    		 Yes

                                    Field Name: All Get Functions::Description
                                    Field Properties Coordinates Field Format Field Behavior Quick Find
                                    • Top: 114 pt
                                    • Left: 633 pt
                                    • Bottom: 145 pt
                                    • Right: 985 pt
                                    • Anchoring: Left and Right, 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: All Get Functions::Version
                                    Field Properties Coordinates Field Format Field Behavior Quick Find
                                    • Top: 114 pt
                                    • Left: 991 pt
                                    • Bottom: 145 pt
                                    • Right: 1070 pt
                                    • Anchoring: Right, 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

                                    Refresh
                                    Clear

                                    Next Script: [Clear]
                                    Script Name Refresh
                                    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
                                        • Replace Field Contents [ All Get Functions::ID; Replace with calculation: All Get Functions::ID ] [ No dialog ]
                                        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: [Refresh]
                                                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
                                                    • Replace Field Contents [ All Get Functions::Value; Replace with calculation: "" ] [ No dialog ]
                                                    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: All Get Functions

                                                            Used functions: