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

MBS FileMaker Plugin Example Databases

Evaluate

All examples are included with download of MBS FileMaker Plugin.

Evaluate.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts4
Value Lists0
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
EvaluateTest
3 fields defined, 1 record
EvaluateTest

Fields

Table Name: EvaluateTest - 3 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
ExpressionNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      ErrorNormal, NumberAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          ErrorTextNormal, TextAuto-Enter: Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German

                Layout Objects: EvaluateTest

                Regular Fields

                Field Name: EvaluateTest::Expression
                Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                • Top: 52 pt
                • Left: 138 pt
                • Bottom: 480 pt
                • Right: 842 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: EvaluateTest::Error
                Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                • Top: 488 pt
                • Left: 138 pt
                • Bottom: 509 pt
                • Right: 289 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: EvaluateTest::ErrorText
                Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                • Top: 488 pt
                • Left: 300 pt
                • Bottom: 509 pt
                • Right: 842 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: Format
                  Hide Condition:
                • MBS( "IsMacOS" ) ≠ 1
                • Top: 56 pt
                • Left: 852 pt
                • Bottom: 96 pt
                • Right: 1018 pt
                • Anchoring: Left, Top
                Perform Script [ “Format” ]

                Scripts:


                Button PropertiesCoordinatesScript/Script Step
                  Type:
                • Text: Error Check
                • Top: 109 pt
                • Left: 853 pt
                • Bottom: 149 pt
                • Right: 1019 pt
                • Anchoring: Left, Top
                Perform Script [ “CheckError” ]

                Scripts:


                Button PropertiesCoordinatesScript/Script Step
                  Type:
                • Text: Evaluate
                • Top: 162 pt
                • Left: 853 pt
                • Bottom: 202 pt
                • Right: 1019 pt
                • Anchoring: Left, Top
                Perform Script [ “Evaluate” ]

                Scripts:


                Button PropertiesCoordinatesScript/Script Step
                  Type:
                • Text: Format Calculation
                  Hide Condition:
                • MBS( "IsMacOS" ) ≠ 1
                • Top: 215 pt
                • Left: 853 pt
                • Bottom: 255 pt
                • Right: 1019 pt
                • Anchoring: Left, Top
                Perform Script [ “FormatCalculation” ]

                Scripts:


                Script Hierarchy

                Format
                FormatCalculation
                CheckError
                Evaluate

                Next Script: [FormatCalculation]
                Script NameFormat
                Run script with full access privilegesOff
                Siri Shortcut VisibleOff
                Include In MenuNo
                Layouts that use this script
                Scripts that use this script
                  Script Definition
                  Script Steps
                  • If [ MBS( "IsMacOS" ) = 1 ]
                  • Set Variable [ $r; Value:MBS( "SyntaxColoring.Format"; EvaluateTest::Expression; 0 ) ]
                  • Set Field [ EvaluateTest::Expression; $r ]
                  • End If
                  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: [Format]Next Script: [CheckError]
                          Script NameFormatCalculation
                          Run script with full access privilegesOff
                          Siri Shortcut VisibleOff
                          Include In MenuNo
                          Layouts that use this script
                          Scripts that use this script
                            Script Definition
                            Script Steps
                            • Set Variable [ $r; Value:MBS("SyntaxColoring.FormatCalculation"; EvaluateTest::Expression) ]
                            • If [ MBS("IsError") ]
                            • Show Custom Dialog [ Title: "Failed to format"; Message: $r; Default Button: “OK”, Commit: “Yes” ]
                            • Else
                            • #add colors
                            • Set Variable [ $f; Value:MBS("SyntaxColoring.Format"; $r) ]
                            • If [ MBS("IsError") ]
                            • Set Field [ EvaluateTest::Expression; $r ]
                            • Else
                            • Set Field [ EvaluateTest::Expression; TextSize ( $f ; 16 ) ]
                            • End If
                            • End If
                            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: [FormatCalculation]Next Script: [Evaluate]
                                    Script NameCheckError
                                    Run script with full access privilegesOff
                                    Siri Shortcut VisibleOff
                                    Include In MenuYes
                                    Layouts that use this script
                                    Scripts that use this script
                                      Script Definition
                                      Script Steps
                                      • Set Error Capture [ On ]
                                      • Set Variable [ $expression; Value:"If(false; Let(r=" & EvaluateTest::Expression & "¶;0))" ]
                                      • Set Variable [ $e; Value:EvaluationError(Evaluate($expression)) ]
                                      • Set Field [ EvaluateTest::Error; $e ]
                                      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: [CheckError]
                                              Script NameEvaluate
                                              Run script with full access privilegesOff
                                              Siri Shortcut VisibleOff
                                              Include In MenuNo
                                              Layouts that use this script
                                              Scripts that use this script
                                                Script Definition
                                                Script Steps
                                                • Set Error Capture [ On ]
                                                • Set Variable [ $expression; Value:EvaluateTest::Expression ]
                                                • Set Variable [ $e; Value:Evaluate($expression) ]
                                                • Show Custom Dialog [ Title: "Result"; Message: $e; Default Button: “OK”, Commit: “Yes” ]
                                                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: Evaluate

                                                        Used functions: