MBS FileMaker Plugin Example Databases

FileMaker Snippet Storage

All examples are included with download of MBS FileMaker Plugin.

FileMaker Snippet Storage.fmp12

Overview
Tables1
Relationships1
Layouts1
Scripts11
Value Lists2
Custom Functions59
Custom Menus33
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
OnWindowOpenScript: AutoStart
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
SnippetStorageDB
16 fields defined, 0 record
PORT_SnippetStorageDB, SnippetStorageDB

Fields

Table Name: SnippetStorageDB - 16 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
f004t_SnippetNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      f001t_DescriptionNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
            f003t_TypeNormal, TextAuto-Enter:
            • Allow editing
            Validation:
            • Only during data entry
            Storage:
            • Repetitions: 1
            • Indexing: All
            • Index Language: German
              s001b_OneNormal, NumberAuto-Enter:
              • Constant data: 1
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: All
              • Index Language: German
                      a001t_GUIDNormal, TextAuto-Enter: Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: Minimal
                      • Automatically create indexes as needed
                      • Index Language: German
                            a_---------------------Normal, TextAuto-Enter:
                            • Allow editing
                            Validation:
                            • Only during data entry
                            Storage:
                            • Repetitions: 1
                            • Indexing: None
                            • Automatically create indexes as needed
                            • Index Language: German
                                    f_---------------------Normal, TextAuto-Enter:
                                    • Allow editing
                                    Validation:
                                    • Only during data entry
                                    Storage:
                                    • Repetitions: 1
                                    • Indexing: None
                                    • Automatically create indexes as needed
                                    • Index Language: German
                                            fs-----------------------Normal, TextAuto-Enter:
                                            • Allow editing
                                            Validation:
                                            • Only during data entry
                                            Storage:
                                            • Global
                                            • Repetitions: 1
                                            • Index Language: German
                                                    n_---------------------Normal, TextAuto-Enter:
                                                    • Allow editing
                                                    Validation:
                                                    • Only during data entry
                                                    Storage:
                                                    • Repetitions: 1
                                                    • Indexing: None
                                                    • Automatically create indexes as needed
                                                    • Index Language: German
                                                            s_---------------------Normal, TextAuto-Enter:
                                                            • Allow editing
                                                            Validation:
                                                            • Only during data entry
                                                            Storage:
                                                            • Repetitions: 1
                                                            • Indexing: None
                                                            • Automatically create indexes as needed
                                                            • Index Language: German
                                                                    sv_---------------------Normal, TextAuto-Enter:
                                                                    • Allow editing
                                                                    Validation:
                                                                    • Only during data entry
                                                                    Storage:
                                                                    • Repetitions: 1
                                                                    • Indexing: None
                                                                    • Automatically create indexes as needed
                                                                    • Index Language: German
                                                                            f002t_PluginNormal, TextAuto-Enter:
                                                                            • Allow editing
                                                                            Validation:
                                                                            • Only during data entry
                                                                            Storage:
                                                                            • Repetitions: 1
                                                                            • Indexing: None
                                                                            • Automatically create indexes as needed
                                                                            • Index Language: German
                                                                                    v_---------------------Normal, TextAuto-Enter:
                                                                                    • Allow editing
                                                                                    Validation:
                                                                                    • Only during data entry
                                                                                    Storage:
                                                                                    • Repetitions: 1
                                                                                    • Indexing: None
                                                                                    • Automatically create indexes as needed
                                                                                    • Index Language: German
                                                                                            v001t_REL_PORT_SnippetNormal, TextAuto-Enter:
                                                                                            • Allow editing
                                                                                            Validation:
                                                                                            • Only during data entry
                                                                                            Storage:
                                                                                            • Global
                                                                                            • Repetitions: 1
                                                                                            • Index Language: German
                                                                                              f005n_SortIDNormal, NumberAuto-Enter:
                                                                                              • Allow editing
                                                                                              Validation:
                                                                                              • Only during data entry
                                                                                              Storage:
                                                                                              • Repetitions: 1
                                                                                              • Indexing: All
                                                                                              • Index Language: German
                                                                                                    v002t_GUID_SnippetNormal, TextAuto-Enter:
                                                                                                    • Allow editing
                                                                                                    Validation:
                                                                                                    • Only during data entry
                                                                                                    Storage:
                                                                                                    • Global
                                                                                                    • Repetitions: 1
                                                                                                    • Index Language: German

                                                                                                          Layout Objects: SnippetStorageDB

                                                                                                          Regular Fields

                                                                                                          Field Name: SnippetStorageDB::f004t_Snippet
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • Top: 74 pt
                                                                                                          • Left: 620 pt
                                                                                                          • Bottom: 766 pt
                                                                                                          • Right: 1390 pt
                                                                                                          • Anchoring: Left and Right, Top and Bottom
                                                                                                          Field Format:
                                                                                                          • Edit Box
                                                                                                          • Include vertical scrollbar
                                                                                                          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: PORT_SnippetStorageDB::f005n_SortID
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • Top: 98 pt
                                                                                                          • Left: 1 pt
                                                                                                          • Bottom: 119 pt
                                                                                                          • Right: 31 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                          Field Format:
                                                                                                          • Edit Box
                                                                                                          Field Behavior:
                                                                                                          • Allow field to be entered: In Browse mode
                                                                                                          • Select entire contents of field on entry
                                                                                                          • Touch keyboard type: Default for Data Type
                                                                                                          No

                                                                                                          Field Name: PORT_SnippetStorageDB::f001t_Description
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • Top: 98 pt
                                                                                                          • Left: 32 pt
                                                                                                          • Bottom: 119 pt
                                                                                                          • Right: 564 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                          Field Format:
                                                                                                          • Edit Box
                                                                                                          No

                                                                                                          Field Name: SnippetStorageDB::f001t_Description
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                            Tooltip:
                                                                                                          • "Description"
                                                                                                          • Top: 43 pt
                                                                                                          • Left: 620 pt
                                                                                                          • Bottom: 71 pt
                                                                                                          • Right: 1120 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
                                                                                                          No

                                                                                                          Field Name: SnippetStorageDB::f003t_Type
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                            Tooltip:
                                                                                                          • "Type of snippet"
                                                                                                          • Top: 43 pt
                                                                                                          • Left: 1132 pt
                                                                                                          • Bottom: 71 pt
                                                                                                          • Right: 1282 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                          Field Format: Field Behavior:
                                                                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                                                                          • Touch keyboard type: Default for Data Type
                                                                                                          No

                                                                                                          Field Name: SnippetStorageDB::f005n_SortID
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                            Tooltip:
                                                                                                          • "Sorting"
                                                                                                          • Top: 43 pt
                                                                                                          • Left: 1291 pt
                                                                                                          • Bottom: 71 pt
                                                                                                          • Right: 1351 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                          Field Format:
                                                                                                          • Pop-up Menu
                                                                                                          • Display values from: SortID
                                                                                                          Field Behavior:
                                                                                                          • Allow field to be entered: In Find mode, In Browse mode
                                                                                                          • Touch keyboard type: Default for Data Type
                                                                                                          No

                                                                                                          Field Name: SnippetStorageDB::a001t_GUID
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • Top: 24 pt
                                                                                                          • Left: 630 pt
                                                                                                          • Bottom: 45 pt
                                                                                                          • Right: 750 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
                                                                                                          No
                                                                                                          Conditional FormattingConditionFormat
                                                                                                          1.

                                                                                                            self:normal .self
                                                                                                            {
                                                                                                            background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                            }
                                                                                                            self:normal .icon
                                                                                                            {
                                                                                                            -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                            }

                                                                                                          Field Name: PORT_SnippetStorageDB::a001t_GUID
                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                          • Top: 24 pt
                                                                                                          • Left: 750 pt
                                                                                                          • Bottom: 45 pt
                                                                                                          • Right: 870 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
                                                                                                          No
                                                                                                          Conditional FormattingConditionFormat
                                                                                                          1.

                                                                                                            self:normal .self
                                                                                                            {
                                                                                                            background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                            }
                                                                                                            self:normal .icon
                                                                                                            {
                                                                                                            -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                            }

                                                                                                          Merge Fields

                                                                                                          Field PropertiesCoordinatesFieldsQuick Find
                                                                                                            Text:
                                                                                                          • <<$anz>>
                                                                                                          • Top: 98 pt
                                                                                                          • Left: 0 pt
                                                                                                          • Bottom: 122 pt
                                                                                                          • Right: 594 pt
                                                                                                          • Anchoring: Left, Top
                                                                                                            No

                                                                                                            Group Buttons

                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text: <<$anz>>
                                                                                                              Additional Properties:
                                                                                                            • Rectangular
                                                                                                            • Top: 98 pt
                                                                                                            • Left: 0 pt
                                                                                                            • Bottom: 122 pt
                                                                                                            • Right: 594 pt
                                                                                                            • Anchoring: Left, Top
                                                                                                            Perform Script [ “GoTo Snippet”; Parameter: PORT_SnippetStorageDB::a001t_GUID ]

                                                                                                            Scripts:

                                                                                                            Fields:


                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text: www.clarotools.com - manual
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Rectangular
                                                                                                            • Top: 766 pt
                                                                                                            • Left: 1 pt
                                                                                                            • Bottom: 788 pt
                                                                                                            • Right: 1399 pt
                                                                                                            • Anchoring: Center, Center
                                                                                                            Open URL [ "www.clarotools.com/clarosnippedmanual.html" ] [ No dialog ]

                                                                                                            Buttons

                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 99 pt
                                                                                                            • Left: 569 pt
                                                                                                            • Bottom: 119 pt
                                                                                                            • Right: 593 pt
                                                                                                            • Anchoring: Left, Top
                                                                                                            Perform Script [ “Delete Snippet”; Parameter: PORT_SnippetStorageDB::a001t_GUID & ¶ & PORT_SnippetStorageDB::f001t_Description ]

                                                                                                            Scripts:

                                                                                                            Fields:


                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Tooltip:
                                                                                                            • "Change ONLY snippet field - Clipboard to textfield"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 43 pt
                                                                                                            • Left: 1360 pt
                                                                                                            • Bottom: 71 pt
                                                                                                            • Right: 1390 pt
                                                                                                            • Anchoring: Left and Right, Top
                                                                                                            Perform Script [ “Update ClipboardToField” ]

                                                                                                            Scripts:


                                                                                                            Button Bars

                                                                                                            Button Bar PropertiesCoordinates
                                                                                                              Tooltip:
                                                                                                            • "Copy textfield to clipboard"
                                                                                                              Orientation:
                                                                                                            • horizontal
                                                                                                            • Top: 0 pt
                                                                                                            • Left: 620 pt
                                                                                                            • Bottom: 40 pt
                                                                                                            • Right: 870 pt
                                                                                                            • Anchoring: Left, Top
                                                                                                            Button Segments
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Tooltip:
                                                                                                            • "Copy textfield to clipboard"
                                                                                                              Label Calculations:
                                                                                                            • "COPY"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 0 pt
                                                                                                            • Left: 621 pt
                                                                                                            • Bottom: 40 pt
                                                                                                            • Right: 869 pt
                                                                                                            Perform Script [ “FieldToClipboard” ]

                                                                                                            Scripts:


                                                                                                            Button Bar PropertiesCoordinates
                                                                                                              Orientation:
                                                                                                            • horizontal
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 0 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 612 pt
                                                                                                            • Anchoring: Left, Top
                                                                                                            Button Segments
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Script"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 1 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 69 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Script" ]

                                                                                                            Scripts:

                                                                                                            Conditional FormattingConditionFormat
                                                                                                            1.

                                                                                                              self:normal .self
                                                                                                              {
                                                                                                              background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                              color: rgba(100%,100%,100%,1);
                                                                                                              }
                                                                                                              self:normal .icon
                                                                                                              {
                                                                                                              -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                              }
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Script" & ¶ & "Step"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 69 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 137 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Scriptstep" ]

                                                                                                            Scripts:

                                                                                                            Conditional FormattingConditionFormat
                                                                                                            1.

                                                                                                              self:normal .self
                                                                                                              {
                                                                                                              background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                              color: rgba(100%,100%,100%,1);
                                                                                                              }
                                                                                                              self:normal .icon
                                                                                                              {
                                                                                                              -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                              }
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Custom" & ¶ & "Function"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 137 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 204 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "CustomFunction" ]

                                                                                                            Scripts:

                                                                                                            Conditional FormattingConditionFormat
                                                                                                            1.

                                                                                                              self:normal .self
                                                                                                              {
                                                                                                              background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                              color: rgba(100%,100%,100%,1);
                                                                                                              }
                                                                                                              self:normal .icon
                                                                                                              {
                                                                                                              -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                              }
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Table"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 204 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 272 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Table" ]

                                                                                                            Scripts:

                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Field"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 272 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 340 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Field" ]

                                                                                                            Scripts:

                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Layout"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 340 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 408 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Layout Layout12" ]

                                                                                                            Scripts:

                                                                                                            Conditional FormattingConditionFormat
                                                                                                            1.

                                                                                                              self:normal .self
                                                                                                              {
                                                                                                              background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                              color: rgba(100%,100%,100%,1);
                                                                                                              }
                                                                                                              self:normal .icon
                                                                                                              {
                                                                                                              -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                              }
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Layout" & ¶ & "12"
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 408 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 475 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Layout12" ]

                                                                                                            Scripts:

                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Value" & ¶ & "List"
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 475 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 543 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "ValueList" ]

                                                                                                            Scripts:

                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Label Calculations:
                                                                                                            • "Text"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 40 pt
                                                                                                            • Left: 543 pt
                                                                                                            • Bottom: 97 pt
                                                                                                            • Right: 611 pt
                                                                                                            Perform Script [ “Set PORT”; Parameter: "Text" ]

                                                                                                            Scripts:

                                                                                                            Conditional FormattingConditionFormat
                                                                                                            1.

                                                                                                              self:normal .self
                                                                                                              {
                                                                                                              background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                              color: rgba(100%,100%,100%,1);
                                                                                                              }
                                                                                                              self:normal .icon
                                                                                                              {
                                                                                                              -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                              }

                                                                                                            Button Bar PropertiesCoordinates
                                                                                                              Tooltip:
                                                                                                            • "Create new snippet - Clipboard to textfield"
                                                                                                              Orientation:
                                                                                                            • horizontal
                                                                                                            • Top: 0 pt
                                                                                                            • Left: 1150 pt
                                                                                                            • Bottom: 40 pt
                                                                                                            • Right: 1400 pt
                                                                                                            • Anchoring: Right, Top
                                                                                                            Button Segments
                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                              Type:
                                                                                                            • Text:
                                                                                                              Tooltip:
                                                                                                            • "Create new snippet - Clipboard to textfield"
                                                                                                              Label Calculations:
                                                                                                            • "NEW"
                                                                                                              Additional Properties:
                                                                                                            • Change to hand cursor over button
                                                                                                            • Top: 0 pt
                                                                                                            • Left: 1151 pt
                                                                                                            • Bottom: 40 pt
                                                                                                            • Right: 1400 pt
                                                                                                            Perform Script [ “ClipboardToField” ]

                                                                                                            Scripts:


                                                                                                            Portals

                                                                                                            Portal PropertiesCoordinatesFieldsOptions
                                                                                                            • Top: 97 pt
                                                                                                            • Left: 0 pt
                                                                                                            • Bottom: 766 pt
                                                                                                            • Right: 612 pt
                                                                                                            • Anchoring: Left, Top and Bottom
                                                                                                            Field ObjectsMerge Field Objects
                                                                                                            • Sort records: On

                                                                                                              Field: f005n_SortID

                                                                                                              • Ascending order
                                                                                                              • Reorder based on summary field: Off
                                                                                                              • Override field's language for sort: Off

                                                                                                              Field: f001t_Description

                                                                                                              • Ascending order
                                                                                                              • Reorder based on summary field: Off
                                                                                                              • Override field's language for sort: Off

                                                                                                            • Filter calculation: None
                                                                                                            • Initial Row: 1
                                                                                                            • Number of Rows: 29
                                                                                                            • Show vertical scroll bar

                                                                                                            Graphic Objects

                                                                                                            Graphic Object PropertiesCoordinates
                                                                                                              Type:
                                                                                                            • Text: <<$anz>>
                                                                                                            • Top: 98 pt
                                                                                                            • Left: 0 pt
                                                                                                            • Bottom: 122 pt
                                                                                                            • Right: 594 pt
                                                                                                            • Anchoring: Left, Top
                                                                                                            Conditional FormattingConditionFormat
                                                                                                            1.

                                                                                                              self:normal .self
                                                                                                              {
                                                                                                              background-color: rgba(39.0064%,50.3948%,60.3137%,1);
                                                                                                              }
                                                                                                              self:normal .icon
                                                                                                              {
                                                                                                              -fm-icon-color: rgba(0%,0%,0%,0);
                                                                                                              }

                                                                                                            Value Lists

                                                                                                            Value List NameSourceValuesOn Layouts
                                                                                                            SnippedTypenCustom
                                                                                                            • Script, Layout, Table, Field, ScriptStep, Text, CustomFunction, ValueList, Layout12
                                                                                                            SortIDCustom
                                                                                                            • 0, 1, 2, 3, 4, 5, 6, 7, 8, 9

                                                                                                            Script Hierarchy

                                                                                                            AutoStart
                                                                                                            -
                                                                                                            ClipboardToField
                                                                                                            Update ClipboardToField
                                                                                                            FieldToClipboard
                                                                                                            GoTo Snippet
                                                                                                            Set PORT
                                                                                                            Delete Snippet
                                                                                                            -
                                                                                                            UpdateScript
                                                                                                            -

                                                                                                            Next Script: [-]
                                                                                                            Script NameAutoStart
                                                                                                            Run script with full access privilegesOff
                                                                                                            Include In MenuNo
                                                                                                            Layouts that use this script
                                                                                                              Scripts that use this script
                                                                                                                Script Definition
                                                                                                                Script Steps
                                                                                                                • Allow User Abort [ Off ]
                                                                                                                • Set Error Capture [ On ]
                                                                                                                • Set Zoom Level [ 100% ]
                                                                                                                • Show/Hide Toolbars [ Hide ]
                                                                                                                • Show/Hide Menubar [ Hide ]
                                                                                                                • Adjust Window [ Resize to Fit ]
                                                                                                                • Move/Resize Window [ Current Window; Height: 1500; Top: 0 ]
                                                                                                                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: [AutoStart]Next Script: [ClipboardToField]
                                                                                                                              Script Name-
                                                                                                                              Run script with full access privilegesOff
                                                                                                                              Include In MenuNo
                                                                                                                              Layouts that use this script
                                                                                                                                Scripts that use this script
                                                                                                                                  Script Definition
                                                                                                                                  Script Steps
                                                                                                                                    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: [-]Next Script: [Update ClipboardToField]
                                                                                                                                                  Script NameClipboardToField
                                                                                                                                                  Run script with full access privilegesOff
                                                                                                                                                  Include In MenuNo
                                                                                                                                                  Layouts that use this script
                                                                                                                                                  Scripts that use this script
                                                                                                                                                    Script Definition
                                                                                                                                                    Script Steps
                                                                                                                                                    • Set Variable [ $dataScript; Value:MBS("Clipboard.GetFileMakerData"; "Script") ]
                                                                                                                                                    • Set Variable [ $dataScriptStep; Value:MBS("Clipboard.GetFileMakerData"; "ScriptStep") ]
                                                                                                                                                    • Set Variable [ $dataCustomFunction; Value:MBS ( "Clipboard.GetFileMakerData" ; "CustomFunction") ]
                                                                                                                                                    • Set Variable [ $dataTable; Value:MBS("Clipboard.GetFileMakerData"; "Table") ]
                                                                                                                                                    • Set Variable [ $dataField; Value:MBS("Clipboard.GetFileMakerData"; "Field") ]
                                                                                                                                                    • Set Variable [ $dataLayout; Value:MBS("Clipboard.GetFileMakerData"; "Layout") ]
                                                                                                                                                    • Set Variable [ $dataLayout12; Value:MBS("Clipboard.GetFileMakerData"; "Layout12") ]
                                                                                                                                                    • Set Variable [ $dataValueList; Value:MBS("Clipboard.GetFileMakerData"; "ValueList") ]
                                                                                                                                                    • Set Variable [ $dataText; Value:MBS ( "Clipboard.GetText" ) ]
                                                                                                                                                    • If [ Length($dataScript)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataScript ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "Script" ]
                                                                                                                                                    • Else If [ Length($dataLayout)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataLayout ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "Layout" ]
                                                                                                                                                    • Else If [ Length($dataLayout12)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataLayout12 ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "Layout12" ]
                                                                                                                                                    • Else If [ Length($dataScriptStep)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataScriptStep ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "ScriptStep" ]
                                                                                                                                                    • Else If [ Length($dataCustomFunction)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataCustomFunction ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "CustomFunction" ]
                                                                                                                                                    • Else If [ Length($dataTable)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataTable ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "Table" ]
                                                                                                                                                    • Else If [ Length($dataField)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataField ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "Field" ]
                                                                                                                                                    • Else If [ Length($dataValueList)>0 ]
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataValueList ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "ValueList" ]
                                                                                                                                                    • Else
                                                                                                                                                    • New Record/Request
                                                                                                                                                    • Set Field [ SnippetStorageDB::f004t_Snippet; $dataText ]
                                                                                                                                                    • Set Field [ SnippetStorageDB::f003t_Type; "Text" ]
                                                                                                                                                    • End If
                                                                                                                                                    • Commit Records/Requests [ 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: [ClipboardToField]Next Script: [FieldToClipboard]
                                                                                                                                                            Script NameUpdate ClipboardToField
                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                            Include In MenuNo
                                                                                                                                                            Layouts that use this script
                                                                                                                                                            Scripts that use this script
                                                                                                                                                              Script Definition
                                                                                                                                                              Script Steps
                                                                                                                                                              • Show Custom Dialog [ Title: "Change"; Message: ¶ & "Really change the text?"; Default Button: “Cancel”, Commit: “No”; Button 2: “Change”, Commit: “Yes” ]
                                                                                                                                                              • If [ Get ( LastMessageChoice ) = 2 ]
                                                                                                                                                              • Set Variable [ $dataScript; Value:MBS("Clipboard.GetFileMakerData"; "Script") ]
                                                                                                                                                              • Set Variable [ $dataScriptStep; Value:MBS("Clipboard.GetFileMakerData"; "ScriptStep") ]
                                                                                                                                                              • Set Variable [ $dataCustomFunction; Value:MBS ( "Clipboard.GetFileMakerData" ; "CustomFunction") ]
                                                                                                                                                              • Set Variable [ $dataTable; Value:MBS("Clipboard.GetFileMakerData"; "Table") ]
                                                                                                                                                              • Set Variable [ $dataField; Value:MBS("Clipboard.GetFileMakerData"; "Field") ]
                                                                                                                                                              • Set Variable [ $dataLayout; Value:MBS("Clipboard.GetFileMakerData"; "Layout") ]
                                                                                                                                                              • Set Variable [ $dataLayout12; Value:MBS("Clipboard.GetFileMakerData"; "Layout12") ]
                                                                                                                                                              • Set Variable [ $dataValueList; Value:MBS("Clipboard.GetFileMakerData"; "ValueList") ]
                                                                                                                                                              • Set Variable [ $dataText; Value:MBS ( "Clipboard.GetText" ) ]
                                                                                                                                                              • If [ Length($dataScript)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataScript ]
                                                                                                                                                              • Else If [ Length($dataLayout)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataLayout ]
                                                                                                                                                              • Else If [ Length($dataLayout12)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataLayout12 ]
                                                                                                                                                              • Else If [ Length($dataScriptStep)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataScriptStep ]
                                                                                                                                                              • Else If [ Length($dataCustomFunction)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataCustomFunction ]
                                                                                                                                                              • Else If [ Length($dataTable)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataTable ]
                                                                                                                                                              • Else If [ Length($dataField)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataField ]
                                                                                                                                                              • Else If [ Length($dataValueList)>0 ]
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataValueList ]
                                                                                                                                                              • Else
                                                                                                                                                              • Set Field [ SnippetStorageDB::f004t_Snippet; $dataText ]
                                                                                                                                                              • End If
                                                                                                                                                              • Commit Records/Requests [ No dialog ]
                                                                                                                                                              • 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: [Update ClipboardToField]Next Script: [GoTo Snippet]
                                                                                                                                                                      Script NameFieldToClipboard
                                                                                                                                                                      Run script with full access privilegesOff
                                                                                                                                                                      Include In MenuNo
                                                                                                                                                                      Layouts that use this script
                                                                                                                                                                      Scripts that use this script
                                                                                                                                                                        Script Definition
                                                                                                                                                                        Script Steps
                                                                                                                                                                        • If [ SnippetStorageDB::f003t_Type = "Layout" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "Layout"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "Layout12" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "Layout12"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "Script" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "Script"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "ScriptStep" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "ScriptStep"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "CustomFunktion" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "CustomFunktion"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "Field" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "Field"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "Table" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "Table"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "ValueList" ]
                                                                                                                                                                        • Set Variable [ $r; Value:MBS("Clipboard.SetFileMakerData"; "ValueList"; SnippetStorageDB::f004t_Snippet) ]
                                                                                                                                                                        • Else If [ SnippetStorageDB::f003t_Type = "Text" ]
                                                                                                                                                                        • Copy [ SnippetStorageDB::f004t_Snippet ] [ Select ]
                                                                                                                                                                        • Commit Records/Requests [ No dialog ]
                                                                                                                                                                        • Else
                                                                                                                                                                        • Show Custom Dialog [ Message: "Invalid Field"; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                                                                                                        • 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: [FieldToClipboard]Next Script: [Set PORT]
                                                                                                                                                                                Script NameGoTo Snippet
                                                                                                                                                                                Run script with full access privilegesOff
                                                                                                                                                                                Include In MenuNo
                                                                                                                                                                                Layouts that use this script
                                                                                                                                                                                Scripts that use this script
                                                                                                                                                                                  Script Definition
                                                                                                                                                                                  Script Steps
                                                                                                                                                                                  • Allow User Abort [ Off ]
                                                                                                                                                                                  • Set Error Capture [ On ]
                                                                                                                                                                                  • #<Scriptparameter>
                                                                                                                                                                                  • # 1: GUID
                                                                                                                                                                                  • # 2:
                                                                                                                                                                                  • # 3:
                                                                                                                                                                                  • # 4:
                                                                                                                                                                                  • #</Scriptparameter>
                                                                                                                                                                                  • Set Variable [ $pos; Value:Get ( ActivePortalRowNumber ) ]
                                                                                                                                                                                  • Set Field [ SnippetStorageDB::v002t_GUID_Snippet; __SCRIPT_Parameter ( 1 ) ]
                                                                                                                                                                                  • Show All Records
                                                                                                                                                                                  • Go to Related Record [ From table: “PORT_SnippetStorageDB”; Using layout: <Current Layout> ]
                                                                                                                                                                                  • Go to Portal Row [ $pos ] [ Select; 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: [GoTo Snippet]Next Script: [Delete Snippet]
                                                                                                                                                                                        Script NameSet PORT
                                                                                                                                                                                        Run script with full access privilegesOff
                                                                                                                                                                                        Include In MenuNo
                                                                                                                                                                                        Layouts that use this script
                                                                                                                                                                                        Scripts that use this script
                                                                                                                                                                                          Script Definition
                                                                                                                                                                                          Script Steps
                                                                                                                                                                                          • Allow User Abort [ Off ]
                                                                                                                                                                                          • Set Error Capture [ On ]
                                                                                                                                                                                          • #<Scriptparameter>
                                                                                                                                                                                          • # 1:
                                                                                                                                                                                          • # 2:
                                                                                                                                                                                          • # 3:
                                                                                                                                                                                          • # 4:
                                                                                                                                                                                          • #</Scriptparameter>
                                                                                                                                                                                          • Show All Records
                                                                                                                                                                                          • Show Omitted Only
                                                                                                                                                                                          • Set Field [ SnippetStorageDB::v001t_REL_PORT_Snippet; __SCRIPT_Parameter ( 1 ) ]
                                                                                                                                                                                          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: [Set PORT]Next Script: [-]
                                                                                                                                                                                                Script NameDelete Snippet
                                                                                                                                                                                                Run script with full access privilegesOff
                                                                                                                                                                                                Include In MenuNo
                                                                                                                                                                                                Layouts that use this script
                                                                                                                                                                                                Scripts that use this script
                                                                                                                                                                                                  Script Definition
                                                                                                                                                                                                  Script Steps
                                                                                                                                                                                                  • Allow User Abort [ Off ]
                                                                                                                                                                                                  • Set Error Capture [ On ]
                                                                                                                                                                                                  • #<Scriptparameter>
                                                                                                                                                                                                  • # 1: GUID
                                                                                                                                                                                                  • # 2:
                                                                                                                                                                                                  • # 3:
                                                                                                                                                                                                  • # 4:
                                                                                                                                                                                                  • #</Scriptparameter>
                                                                                                                                                                                                  • Set Variable [ $pos; Value:Get ( ActivePortalRowNumber ) ]
                                                                                                                                                                                                  • Set Field [ SnippetStorageDB::v002t_GUID_Snippet; __SCRIPT_Parameter ( 1 ) ]
                                                                                                                                                                                                  • Show All Records
                                                                                                                                                                                                  • Go to Related Record [ From table: “PORT_SnippetStorageDB”; Using layout: <Current Layout> ]
                                                                                                                                                                                                  • Show Custom Dialog [ Title: "Löschen"; Message: ¶ & "Wollen die den Eintrag " & " << " & __SCRIPT_Parameter ( 2 ) & " >> " & "wirklich löschen?"; Default Button: “Abbrechen”, Commit: “No”; Button 2: “Löschen”, Commit: “Yes” ]
                                                                                                                                                                                                  • If [ Get ( LastMessageChoice ) = 2 ]
                                                                                                                                                                                                  • Set Variable [ $r; Value:Let ( [ pFile = Get ( FileName ) ; pTable = "SnippetStorageDB" ; pField = "a001t_GUID" ; pGUID = "'" & __SCRIPT_Parameter ( 1 ) & "'" ] ; __MBS_FM_2_DeleteGUID ( pFile ; pTable ; pGUID ) ) ]
                                                                                                                                                                                                  • Go to Portal Row [ $pos - 1 ] [ Select; No dialog ]
                                                                                                                                                                                                  • 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: [Delete Snippet]Next Script: [UpdateScript]
                                                                                                                                                                                                        Script Name-
                                                                                                                                                                                                        Run script with full access privilegesOff
                                                                                                                                                                                                        Include In MenuNo
                                                                                                                                                                                                        Layouts that use this script
                                                                                                                                                                                                          Scripts that use this script
                                                                                                                                                                                                            Script Definition
                                                                                                                                                                                                            Script Steps
                                                                                                                                                                                                              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: [-]Next Script: [-]
                                                                                                                                                                                                                            Script NameUpdateScript
                                                                                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                                                                                            Include In MenuNo
                                                                                                                                                                                                                            Layouts that use this script
                                                                                                                                                                                                                              Scripts that use this script
                                                                                                                                                                                                                                Script Definition
                                                                                                                                                                                                                                Script Steps
                                                                                                                                                                                                                                • #Change type "custom func" to "CustomFunction"
                                                                                                                                                                                                                                • Enter Find Mode [ ]
                                                                                                                                                                                                                                • Set Field [ SnippetStorageDB::f003t_Type; "custom func" ]
                                                                                                                                                                                                                                • Perform Find [ ]
                                                                                                                                                                                                                                • Replace Field Contents [ SnippetStorageDB::f003t_Type; Replace with calculation: "CustomFunction" ] [ 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: [UpdateScript]
                                                                                                                                                                                                                                        Script Name-
                                                                                                                                                                                                                                        Run script with full access privilegesOff
                                                                                                                                                                                                                                        Include In MenuNo
                                                                                                                                                                                                                                        Layouts that use this script
                                                                                                                                                                                                                                          Scripts that use this script
                                                                                                                                                                                                                                            Script Definition
                                                                                                                                                                                                                                            Script Steps
                                                                                                                                                                                                                                              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

                                                                                                                                                                                                                                                            Custom Functions

                                                                                                                                                                                                                                                            Function NameParametersAvailabilityDefinitionIn Field DefinitionsIn Scripts
                                                                                                                                                                                                                                                            __GEN_Character_to_HTMLpStringAll accounts/*__GEN_Character_to_HTML ; pString */ Substitute ( pString ; ["\"";"&quot;"] ; ["&";"&amp;"] ; ["<";"&lt;"] ; [">";"&gt;"] ; [" ";"&nbsp;"] ; ["¡";"&iexcl;"] ; ["¢";"&cent;"] ; ["£";"&pound;"] ; ["¤";"&curren;"] ; ["¥";"&yen;"] ; ["¦";"&brvbar;"] ; ["§";"&sect;"] ; ["¨";"&uml;"] ; ["©";"&copy;"] ; ["ª";"&ordf;"] ; ["«";"&laquo;"] ; ["¬";"&not;"] ; ["­";"&shy;"] ; ["®";"&reg;"] ; ["¯";"&macr;"] ; ["°";"&deg;"] ; ["±";"&plusmn;"] ; ["²";"&sup2;"] ; ["³";"&sup3;"] ; ["´";"&acute;"] ; ["µ";"&micro;"] ; ["¶";"&para;"] ; ["·";"&middot;"] ; ["¸";"&cedil;"] ; ["¹";"&sup1;"] ; ["º";"&ordm;"] ; ["»";"&raquo;"] ; ["¼";"&frac14;"] ; ["½";"&frac12;"] ; ["¾";"&frac34;"] ; ["¿";"&iquest;"] ; ["À";"&Agrave;"] ; ["Á";"&Aacute;"] ; ["Â";"&Acirc;"] ; ["Ã";"&Atilde;"] ; ["Ä";"&Auml;"] ; ["Å";"&Aring;"] ; ["Æ";"&AElig;"] ; ["Ç";"&Ccedil;"] ; ["È";"&Egrave;"] ; ["É";"&Eacute;"] ; ["Ê";"&Ecirc;"] ; ["Ë";"&Euml;"] ; ["Ì";"&Igrave;"] ; ["Í";"&Iacute;"] ; ["Î";"&Icirc;"] ; ["Ï";"&Iuml;"] ; ["Ð";"&ETH;"] ; ["Ñ";"&Ntilde;"] ; ["Ò";"&Ograve;"] ; ["Ó";"&Oacute;"] ; ["Ô";"&Ocirc;"] ; ["Õ";"&Otilde;"] ; ["Ö";"&Ouml;"] ; ["×";"&times;"] ; ["Ø";"&Oslash;"] ; ["Ù";"&Ugrave;"] ; ["Ú";"&Uacute;"] ; ["Û";"&Ucirc;"] ; ["Ü";"&Uuml;"] ; ["Ý";"&Yacute;"] ; ["Þ";"&THORN;"] ; ["ß";"&szlig;"] ; ["à";"&agrave;"] ; ["á";"&aacute;"] ; ["â";"&acirc;"] ; ["ã";"&atilde;"] ; ["ä";"&auml;"] ; ["å";"&aring;"] ; ["æ";"&aelig;"] ; ["ç";"&ccedil;"] ; ["è";"&egrave;"] ; ["é";"&eacute;"] ; ["ê";"&ecirc;"] ; ["ë";"&euml;"] ; ["ì";"&igrave;"] ; ["í";"&iacute;"] ; ["î";"&icirc;"] ; ["ï";"&iuml;"] ; ["ð";"&eth;"] ; ["ñ";"&ntilde;"] ; ["ò";"&ograve;"] ; ["ó";"&oacute;"] ; ["ô";"&ocirc;"] ; ["õ";"&otilde;"] ; ["ö";"&ouml;"] ; ["÷";"&divide;"] ; ["ø";"&oslash;"] ; ["ù";"&ugrave;"] ; ["ú";"&uacute;"] ; ["û";"&ucirc;"] ; ["ü";"&uuml;"] ; ["ý";"&yacute;"] ; ["þ";"&thorn;"] ; ["ÿ";"&yuml;"] ; ["Α";"&Alpha;"] ; ["α";"&alpha;"] ; ["Β";"&Beta;"] ; ["β";"&beta;"] ; ["Γ";"&Gamma;"] ; ["γ";"&gamma;"] ; ["Δ";"&Delta;"] ; ["δ";"&delta;"] ; ["Ε";"&Epsilon;"] ; ["ε";"&epsilon;"] ; ["Ζ";"&Zeta;"] ; ["ζ";"&zeta;"] ; ["Η";"&Eta;"] ; ["η";"&eta;"] ; ["Θ";"&Theta;"] ; ["θ";"&theta;"] ; ["Ι";"&Iota;"] ; ["ι";"&iota;"] ; ["Κ";"&Kappa;"] ; ["κ";"&kappa;"] ; ["Λ";"&Lambda;"] ; ["λ";"&lambda;"] ; ["Μ";"&Mu;"] ; ["μ";"&mu;"] ; ["Ν";"&Nu;"] ; ["ν";"&nu;"] ; ["Ξ";"&Xi;"] ; ["ξ";"&xi;"] ; ["Ο";"&Omicron;"] ; ["ο";"&omicron;"] ; ["Π";"&Pi;"] ; ["π";"&pi;"] ; ["Ρ";"&Rho;"] ; ["ρ";"&rho;"] ; ["Σ";"&Sigma;"] ; ["ς";"&sigmaf;"] ; ["σ";"&sigma;"] ; ["Τ";"&Tau;"] ; ["τ";"&tau;"] ; ["Υ";"&Upsilon;"] ; ["υ";"&upsilon;"] ; ["Φ";"&Phi;"] ; ["φ";"&phi;"] ; ["Χ";"&Chi;"] ; ["χ";"&chi;"] ; ["Ψ";"&Psi;"] ; ["ψ";"&psi;"] ; ["Ω";"&Omega;"] ; ["ω";"&omega;"] ; ["ϑ";"&thetasym;"] ; ["ϒ";"&upsih;"] ; ["ϖ";"&piv;"] ; ["∀";"&forall;"] ; ["∂";"&part;"] ; ["∃";"&exist;"] ; ["∅";"&empty;"] ; ["∇";"&nabla;"] ; ["∈";"&isin;"] ; ["∉";"&notin;"] ; ["∋";"&ni;"] ; ["∏";"&prod;"] ; ["∑";"&sum;"] ; ["−";"&minus;"] ; ["∗";"&lowast;"] ; ["√";"&radic;"] ; ["∝";"&prop;"] ; ["∞";"&infin;"] ; ["∠";"&ang;"] ; ["∧";"&and;"] ; ["∨";"&or;"] ; ["∩";"&cap;"] ; ["∪";"&cup;"] ; ["∫";"&int;"] ; ["∴";"&there4;"] ; ["∼";"&sim;"] ; ["≅";"&cong;"] ; ["≈";"&asymp;"] ; ["≠";"&ne;"] ; ["≡";"&equiv;"] ; ["≤";"&le;"] ; ["≥";"&ge;"] ; ["⊂";"&sub;"] ; ["⊃";"&sup;"] ; ["⊄";"&nsub;"] ; ["⊆";"&sube;"] ; ["⊇";"&supe;"] ; ["⊕";"&oplus;"] ; ["⊗";"&otimes;"] ; ["⊥";"&perp;"] ; ["⋅";"&sdot;"] ; ["◊";"&loz;"] ; ["⌈";"&lceil;"] ; ["⌉";"&rceil;"] ; ["⌊";"&lfloor;"] ; ["⌋";"&rfloor;"] ; ["〈";"&lang;"] ; ["〉";"&rang;"] ; ["←";"&larr;"] ; ["↑";"&uarr;"] ; ["→";"&rarr;"] ; ["↓";"&darr;"] ; ["↔";"&harr;"] ; ["↵";"&crarr;"] ; ["⇐";"&lArr;"] ; ["⇑";"&uArr;"] ; ["⇒";"&rArr;"] ; ["⇓";"&dArr;"] ; ["⇔";"&hArr;"] ; ["•";"&bull;"] ; ["′";"&prime;"] ; ["″";"&Prime;"] ; ["‾";"&oline;"] ; ["⁄";"&frasl;"] ; ["℘";"&weierp;"] ; ["ℑ";"&image;"] ; ["ℜ";"&real;"] ; ["™";"&trade;"] ; ["€";"&euro;"] ; ["ℵ";"&alefsym;"] ; ["♠";"&spades;"] ; ["♣";"&clubs;"] ; ["♥";"&hearts;"] ; ["♦";"&diams;"] ; ["Œ";"&OElig;"] ; ["œ";"&oelig;"] ; ["Š";"&Scaron;"] ; ["š";"&scaron;"] ; ["Ÿ";"&Yuml;"] ; ["ƒ";"&fnof;"] ; [" ";"&ensp;"] ; [" ";"&emsp;"] ; ["–";"&ndash;"] ; ["—";"&mdash;"] ; ["‘";"&lsquo;"] ; ["’";"&rsquo;"] ; ["‚";"&sbquo;"] ; ["\“";"&ldquo;"] ; ["\”";"&rdquo;"] ; ["\„";"&bdquo;"] ; ["†";"&dagger;"] ; ["‡";"&Dagger;"] ; ["…";"&hellip;"] ; ["‰";"&permil;"] ; ["‹";"&lsaquo;"] ; ["›";"&rsaquo;"] ; ["ˆ";"&circ;"] ; ["˜";"&tilde;"] )
                                                                                                                                                                                                                                                              __GEN_ContainerSizepSizeAll accounts//__GEN_ContainerSize ( pSize ) //Robert Schaub //www.starrdata.com Let ( [ CTainer = pSize ; Roundit = 2 ]; Case( CTainer ≥ 1000000000;Round ( (CTainer / 1000000000); Roundit ) & " GB"; CTainer ≥ 1000000;Round ( (CTainer / 1000000); Roundit ) & " MB"; CTainer ≥ 1000;Round ( (CTainer / 1000); Roundit ) & " KB";"" ) )
                                                                                                                                                                                                                                                                __GEN_Control_ErrorIDpPosID;pLastErrorIDAll accounts/* __GEN_Control_ErrorID ( pPosID ; pLastErrorID ) */ If ( pLastErrorID > 0 ; ExecuteSQL ( "INSERT INTO S90_Errors ( f000t_GUID, f004n_ScriptPosID, f005n_ErrorID, f006t_ErrorMessage ) VALUES ( '" & "$$ContolMessageGUID" & "','" & "pPosID" & "','" & "pLastErrorID" & "')" ; "" ; "" ) ; "" )
                                                                                                                                                                                                                                                                  __GEN_CryptpString;pDirectionAll accounts/* __GEN_Crypt ( pString ; pDirection ) / en, de*/ Let ( [ Keytext = __GEN_KeyText ( "DasWirstDuNieErraten_VersucheEsDochMal" ) ] ; Case ( pDirection = "en" ; MBS ( "Encryption.Cipher" ; "encrypt" ; "AES-128-CTR" ; "Text" ; Keytext ; "UTF-8" ; "Text" ; pString ; "UTF-8" ; "Hex" ; "" ) ; pDirection = "de" ; MBS ( "Encryption.Cipher" ; "decrypt" ; "AES-128-CTR" ; "Text" ; Keytext ; "UTF-8" ; "Hex" ; pString ; "UTF-8" ; "Text" ; "" ) ; "" ) )
                                                                                                                                                                                                                                                                    __GEN_Crypt_CTspString;pDirectionAll accounts/* __GEN_Crypt_CTs ( pString ; pDirection ) / en, de*/ Let ( [ Keytext = Substitute ( __GEN_KeyText ( "EB8AF7C1-6789-45BB-9D4C-FABE3CB1272D" ) ; [ "1-" ; "FR"] ; [ "-4" ; "18697ITZ"] ) ] ; Case ( pDirection = "en" ; MBS ( "Encryption.Cipher" ; "encrypt" ; "AES-128-CTR" ; "Text" ; Keytext ; "UTF-8" ; "Text" ; pString ; "UTF-8" ; "Hex" ; "" ) ; pDirection = "de" ; MBS ( "Encryption.Cipher" ; "decrypt" ; "AES-128-CTR" ; "Text" ; Keytext ; "UTF-8" ; "Hex" ; pString ; "UTF-8" ; "Text" ; "" ) ; "" ) )
                                                                                                                                                                                                                                                                      __GEN_Crypt_FMpText;pPassphrase;pShiftAll accounts/*__GEN_Crypt_FM ( pText, pPassphrase, pShift )*/ /*Create from Christian Ullmann*/ /* pPassphrase = PasswortString*/ /*pShift nicht kleiner als 0,03*/ /*pShift mit "-" = Entschlüsseln*/ Let ( [ TextCode = Code ( Left ( pText ; 1 ) ) ; TextCodeCrypt = Right ( TextCode ; 5 ) ; TextRemaining = Char ( Left ( TextCode ; Length ( TextCode ) - 5 ) ) & Replace ( pText ; 1 ; 1 ; "" ) ; vShift = GetValue ( pShift ; 1 ) ; PassphraseRemainingLen = GetValue ( pShift ; 2 ) ; ParameterLength = Length ( vShift ) + Length ( PassphraseRemainingLen ) ; PassphraseRemaining = Left ( Replace ( pShift ; 1 ; ParameterLength + 2 ; "" ) ; PassphraseRemainingLen ) ; PassphraseRemaining = Case ( PassphraseRemaining = "" ; pPassphrase ; PassphraseRemaining ) ; Return = Replace ( pShift ; 1 ; ParameterLength + PassphraseRemainingLen + 3 ; "" ) ; PassphraseCode = Code ( Left ( PassphraseRemaining ; 1 ) ) ; PassphraseCodeCrypt = Right ( PassphraseCode ; 5 ) ; PassphraseRemaining = Char ( Left ( PassphraseCode ; Length ( PassphraseCode ) - 5 ) ) & Replace ( PassphraseRemaining ; 1 ; 1 ; "" ) ; CharCrypted = Case ( TextCode = "" ; "" ; Char ( Mod ( TextCodeCrypt + Int ( PassphraseCodeCrypt * vShift ) - 1 ; 65535 ) + 1 ) ) ; Return = Return & CharCrypted ] ; Case ( TextRemaining = "" ; Return ; __GEN_Crypt_FM ( TextRemaining ; pPassphrase ; vShift & ¶ & Length ( PassphraseRemaining ) & ¶ & PassphraseRemaining & ¶ & Return ) ) )
                                                                                                                                                                                                                                                                        __GEN_HTML_to_CharacterpStringAll accounts/*__GEN_HTML_to_Character ; pString */ Substitute ( pString ; ["&amp;";"&"] ; ["&quot;";"\""] ;["&lt;";"<"] ; ["&gt;";">"] ; ["&nbsp;";" "] ; ["&iexcl;";"¡"] ; ["&cent;";"¢"] ; ["&pound;";"£"] ; ["&curren;";"¤"] ; ["&yen;";"¥"] ; ["&brvbar;";"¦"] ; ["&sect;";"§"] ; ["&uml;";"¨"] ; ["&copy;";"©"] ; ["&ordf;";"ª"] ; ["&laquo;";"«"] ; ["&not;";"¬"] ; ["&shy;";"­"] ; ["&reg;";"®"] ; ["&macr;";"¯"] ; ["&deg;";"°"] ; ["&plusmn;";"±"] ; ["&sup2;";"²"] ; ["&sup3;";"³"] ; ["&acute;";"´"] ; ["&micro;";"µ"] ; ["&para;";"¶"] ; ["&middot;";"·"] ; ["&cedil;";"¸"] ; ["&sup1;";"¹"] ; ["&ordm;";"º"] ; ["&raquo;";"»"] ; ["&frac14;";"¼"] ; ["&frac12;";"½"] ; ["&frac34;";"¾"] ; ["&iquest;";"¿"] ; ["&Agrave;";"À"] ; ["&Aacute;";"Á"] ; ["&Acirc;";"Â"] ; ["&Atilde;";"Ã"] ; ["&Auml;";"Ä"] ; ["&Aring;";"Å"] ; ["&AElig;";"Æ"] ; ["&Ccedil;";"Ç"] ; ["&Egrave;";"È"] ; ["&Eacute;";"É"] ; ["&Ecirc;";"Ê"] ; ["&Euml;";"Ë"] ; ["&Igrave;";"Ì"] ; ["&Iacute;";"Í"] ; ["&Icirc;";"Î"] ; ["&Iuml;";"Ï"] ; ["&ETH;";"Ð"] ; ["&Ntilde;";"Ñ"] ; ["&Ograve;";"Ò"] ; ["&Oacute;";"Ó"] ; ["&Ocirc;";"Ô"] ; ["&Otilde;";"Õ"] ; ["&Ouml;";"Ö"] ; ["&times;";"×"] ; ["&Oslash;";"Ø"] ; ["&Ugrave;";"Ù"] ; ["&Uacute;";"Ú"] ; ["&Ucirc;";"Û"] ; ["&Uuml;";"Ü"] ; ["&Yacute;";"Ý"] ; ["&THORN;";"Þ"] ; ["&szlig;";"ß"] ; ["&agrave;";"à"] ; ["&aacute;";"á"] ; ["&acirc;";"â"] ; ["&atilde;";"ã"] ; ["&auml;";"ä"] ; ["&aring;";"å"] ; ["&aelig;";"æ"] ; ["&ccedil;";"ç"] ; ["&egrave;";"è"] ; ["&eacute;";"é"] ; ["&ecirc;";"ê"] ; ["&euml;";"ë"] ; ["&igrave;";"ì"] ; ["&iacute;";"í"] ; ["&icirc;";"î"] ; ["&iuml;";"ï"] ; ["&eth;";"ð"] ; ["&ntilde;";"ñ"] ; ["&ograve;";"ò"] ; ["&oacute;";"ó"] ; ["&ocirc;";"ô"] ; ["&otilde;";"õ"] ; ["&ouml;";"ö"] ; ["&divide;";"÷"] ; ["&oslash;";"ø"] ; ["&ugrave;";"ù"] ; ["&uacute;";"ú"] ; ["&ucirc;";"û"] ; ["&uuml;";"ü"] ; ["&yacute;";"ý"] ; ["&thorn;";"þ"] ; ["&yuml;";"ÿ"] ; ["&Alpha;";"Α"] ; ["&alpha;";"α"] ; ["&Beta;";"Β"] ; ["&beta;";"β"] ; ["&Gamma;";"Γ"] ; ["&gamma;";"γ"] ; ["&Delta;";"Δ"] ; ["&delta;";"δ"] ; ["&Epsilon;";"Ε"] ; ["&epsilon;";"ε"] ; ["&Zeta;";"Ζ"] ; ["&zeta;";"ζ"] ; ["&Eta;";"Η"] ; ["&eta;";"η"] ; ["&Theta;";"Θ"] ; ["&theta;";"θ"] ; ["&Iota;";"Ι"] ; ["&iota;";"ι"] ; ["&Kappa;";"Κ"] ; ["&kappa;";"κ"] ; ["&Lambda;";"Λ"] ; ["&lambda;";"λ"] ; ["&Mu;";"Μ"] ; ["&mu;";"μ"] ; ["&Nu;";"Ν"] ; ["&nu;";"ν"] ; ["&Xi;";"Ξ"] ; ["&xi;";"ξ"] ; ["&Omicron;";"Ο"] ; ["&omicron;";"ο"] ; ["&Pi;";"Π"] ; ["&pi;";"π"] ; ["&Rho;";"Ρ"] ; ["&rho;";"ρ"] ; ["&Sigma;";"Σ"] ; ["&sigmaf;";"ς"] ; ["&sigma;";"σ"] ; ["&Tau;";"Τ"] ; ["&tau;";"τ"] ; ["&Upsilon;";"Υ"] ; ["&upsilon;";"υ"] ; ["&Phi;";"Φ"] ; ["&phi;";"φ"] ; ["&Chi;";"Χ"] ; ["&chi;";"χ"] ; ["&Psi;";"Ψ"] ; ["&psi;";"ψ"] ; ["&Omega;";"Ω"] ; ["&omega;";"ω"] ; ["&thetasym;";"ϑ"] ; ["&upsih;";"ϒ"] ; ["&piv;";"ϖ"] ; ["&forall;";"∀"] ; ["&part;";"∂"] ; ["&exist;";"∃"] ; ["&empty;";"∅"] ; ["&nabla;";"∇"] ; ["&isin;";"∈"] ; ["&notin;";"∉"] ; ["&ni;";"∋"] ; ["&prod;";"∏"] ; ["&sum;";"∑"] ; ["&minus;";"−"] ; ["&lowast;";"∗"] ; ["&radic;";"√"] ; ["&prop;";"∝"] ; ["&infin;";"∞"] ; ["&ang;";"∠"] ; ["&and;";"∧"] ; ["&or;";"∨"] ; ["&cap;";"∩"] ; ["&cup;";"∪"] ; ["&int;";"∫"] ; ["&there4;";"∴"] ; ["&sim;";"∼"] ; ["&cong;";"≅"] ; ["&asymp;";"≈"] ; ["&ne;";"≠"] ; ["&equiv;";"≡"] ; ["&le;";"≤"] ; ["&ge;";"≥"] ; ["&sub;";"⊂"] ; ["&sup;";"⊃"] ; ["&nsub;";"⊄"] ; ["&sube;";"⊆"] ; ["&supe;";"⊇"] ; ["&oplus;";"⊕"] ; ["&otimes;";"⊗"] ; ["&perp;";"⊥"] ; ["&sdot;";"⋅"] ; ["&loz;";"◊"] ; ["&lceil;";"⌈"] ; ["&rceil;";"⌉"] ; ["&lfloor;";"⌊"] ; ["&rfloor;";"⌋"] ; ["&lang;";"〈"] ; ["&rang;";"〉"] ; ["&larr;";"←"] ; ["&uarr;";"↑"] ; ["&rarr;";"→"] ; ["&darr;";"↓"] ; ["&harr;";"↔"] ; ["&crarr;";"↵"] ; ["&lArr;";"⇐"] ; ["&uArr;";"⇑"] ; ["&rArr;";"⇒"] ; ["&dArr;";"⇓"] ; ["&hArr;";"⇔"] ; ["&bull;";"•"] ; ["&prime;";"′"] ; ["&Prime;";"″"] ; ["&oline;";"‾"] ; ["&frasl;";"⁄"] ; ["&weierp;";"℘"] ; ["&image;";"ℑ"] ; ["&real;";"ℜ"] ; ["&trade;";"™"] ; ["&euro;";"€"] ; ["&alefsym;";"ℵ"] ; ["&spades;";"♠"] ; ["&clubs;";"♣"] ; ["&hearts;";"♥"] ; ["&diams;";"♦"] ; ["&OElig;";"Œ"] ; ["&oelig;";"œ"] ; ["&Scaron;";"Š"] ; ["&scaron;";"š"] ; ["&Yuml;";"Ÿ"] ; ["&fnof;";"ƒ"] ; ["&ensp;";" "] ; ["&emsp;";" "] ; ["&ndash;";"–"] ; ["&mdash;";"—"] ; ["&lsquo;";"‘"] ; ["&rsquo;";"’"] ; ["&sbquo;";"‚"] ; ["&ldquo;";"\“"] ; ["&rdquo;";"\”"] ; ["&bdquo;";"\„"] ; ["&dagger;";"†"] ; ["&Dagger;";"‡"] ; ["&hellip;";"…"] ; ["&permil;";"‰"] ; ["&lsaquo;";"‹"] ; ["&rsaquo;";"›"] ; ["&circ;";"ˆ"] ; ["&tilde;";"˜"] )
                                                                                                                                                                                                                                                                          __GEN_KeyTextpStingAll accounts/* __GEN_KeyText ( pString ) */ MBS ( "Hash.Digest" ; "SHA256" ; "Text" ; Substitute ( "EB8AF7C1-6789-45BB-9D4C-FABE3CB1272D" ; [ "1-" ; "FR"] ; [ "-4" ; "18697ITZ"] ) ; "UTF-8" ; "Hex" )
                                                                                                                                                                                                                                                                            __GEN_Money_to_TextpBetragAll accounts/*__GEN_Money_to_Text ; pBetrag */ If (Round (pBetrag; 2) < 0; "-";"") & If (Length (Int (Abs (Round (pBetrag; 2)))) > 12; Right (Left (Int (Abs (Round (pBetrag; 2))); Length (Int (Abs (Round (pBetrag; 2)))) - 12);3) & ".";"") & If (Length (Int (Abs (Round (pBetrag; 2)))) > 9; Right (Left (Int (Abs (Round (pBetrag; 2))); Length (Int (Abs (Round (pBetrag; 2)))) - 9);3) & ".";"") & If (Length (Int (Abs (Round (pBetrag; 2)))) > 6; Right (Left (Int (Abs (Round (pBetrag; 2))); Length (Int (Abs (Round (pBetrag; 2)))) - 6);3) & ".";"") & If (Length (Int (Abs (Round (pBetrag; 2)))) > 3; Right (Left (Int (Abs (Round (pBetrag; 2))); Length (Int (Abs (Round (pBetrag; 2)))) - 3);3) & ".";"") & Right (If (PatternCount (Round (pBetrag; 2); ",") = 0; Abs (Round (pBetrag; 2)) & ",00"; If (Position (Abs (Round (pBetrag; 2)); ","; 1; 1) = 1;"0";"") & Left (Abs (Round (pBetrag; 2)) & "0"; Position (Abs (Round (pBetrag; 2) );",";1;1) + 2 ));6)
                                                                                                                                                                                                                                                                              __GEN_MultilineKeypField;pFoundCountAll accounts/*__GEN_MultilineKey ( pField ; pFoundCount )*/ Case ( pFoundCount > 1 ; __GEN_MultilineKey( pField; pFoundCount - 1) & ¶ & GetNthRecord( pField; pFoundCount ) ; GetNthRecord( pField; 1 ) )
                                                                                                                                                                                                                                                                                __GEN_RandomPWpAnzahlZeichen;pReturn;pMethodAll accounts/*__GEN_RandomPW ( pAnzahlZeichen ; pReturn ; pMethod ) Autorin: Therese Telepski pAnzahlZeichen = Anzahl gewünschter Zeichen pReturn = Ausgabestring, normalerweise zu Beginn leer pMethod = Wahl des zur Verfügung stehenden Zeichensatzes 1: Nur Kleinbuchstaben 2: Klein- & Großbuchstaben 3: Buchstaben und Zahlen 4: Alles inkl. etlicher Sonderzeichen */ Let ( [ // Erlaubte Zeichen Rep1 = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890ßäáàâëéèêïíìîöóòôüúùûÄÁÀÂËÉÈÊÏÍÌÎÖÓÒÔÜÚÙÛ-_.,!§$%&([{)]}}+~#@€$£" ; LR = Case ( pMethod = 1 ; 26 ; // nur Kleinbuchstaben pMethod = 2 ; 52 ; // Klein- und Großbuchstaben pMethod = 3 ; 62 ; // Klein- und Großbuchstaben sowie Zahlen pMethod = 4 ; Length ( Rep1 ) ; // Alle oben erlaubten Length ( Rep1 ) ) ; Rep2 = Left ( Rep1 ; LR ) ; // Passwort um ein Zeichen verlängern String = pReturn & Middle ( Rep2 ; Round ( Random * ( LR - 1 ) ; 0 ) +1 ; 1 ) ] ; Case ( Length ( String ) < pAnzahlZeichen ; __GEN_RandomPW ( pAnzahlZeichen ; String ; pMethod ) ; String ) )
                                                                                                                                                                                                                                                                                  __GEN_Range_IDpBeginn;pEnde;pAbstandAll accounts/*__GEN_Range_ID ( pBeginn ; pEnde ; pAbstand )*/ Let ( d = pBeginn ; Case ( d > pEnde ; "" ; IsEmpty ( pBeginn ) or IsEmpty ( pEnde ) ; "" ; d = pEnde ; d ; d & ¶ & __GEN_Range_ID ( d + pAbstand ; pEnde ; pAbstand ) ) )
                                                                                                                                                                                                                                                                                    __GEN_SpecialCharacterpStringAll accounts/*__GEN_SpecialCharacter (pString)*/ Substitute (pString ; [ "ä"; "ae" ]; [ "ö"; "oe" ]; [ "ü"; "ue" ]; [ "Ä"; "Ae" ]; [ "Ö"; "Oe" ]; [ "Ü"; "Ue" ]; [ "ß"; "ss" ]; [ "á"; "a" ]; [ "é"; "e" ]; [ "í"; "i" ]; [ "ó"; "o" ]; [ "ú"; "u" ]; [ "à"; "a" ]; [ "è"; "e" ]; [ "ì"; "i" ]; [ "ò"; "o" ]; [ "ù"; "u" ]; [ "â"; "a" ]; [ "ê"; "e" ]; [ "í"; "i" ]; [ "ô"; "o" ]; [ "û"; "u" ]; [ "Á"; "A" ]; [ "É"; "E" ]; [ "Í"; "I" ]; [ "Ó"; "O" ]; [ "Ú"; "U" ]; [ "À"; "A" ]; [ "È"; "E" ]; [ "Ì"; "I" ]; [ "Ò"; "O" ]; [ "Ù"; "U" ]; [ "Â"; "A" ]; [ "Ê"; "E" ]; [ "Î"; "I" ]; [ "Ô"; "O" ]; [ "Û"; "U" ]; [ "("; "/*" ]; [ ")"; "*/" ]; [ "["; "/*" ]; [ "]"; "*/" ]; [ "["; "/*" ]; [ "]"; "*/" ]; [ "#"; "*" ]; [ "?"; "*" ]; [ "!"; "*" ]; [ ";"; "," ]; [ ":"; "," ] )
                                                                                                                                                                                                                                                                                      __GEN_TraceAll accounts/* __GEN_Trace*/ Let ( [ TracePath = MBS ( "Path.AddPathComponent" ; MBS ( "Folders.UserDesktop" ) ; "trace.txt" ) ] ; Case ( $$Trace = 1 ; MBS ( "Trace" ; TracePath ) ) )
                                                                                                                                                                                                                                                                                        __GUIDAll accounts/*__GUID*/ Get ( UUID )
                                                                                                                                                                                                                                                                                        __MBS_FM_____All accounts
                                                                                                                                                                                                                                                                                          __MBS_FM_1_CreateIndexpFieldAll accounts/* __MBS_FM_1_CreateIndex ( pField ) */ Let ( [ $$mbs_string = "CREATE INDEX ON " & Substitute ( pField ; [ "::" ; "." ] ) ] ; MBS ( "FM.ExecuteFileSQL" ; $$mbs_string ) )
                                                                                                                                                                                                                                                                                            __MBS_FM_1_DropIndexpFieldAll accounts/* __MBS_FM_1_DropIndex ( pField ) */ Let ( [ $$mbs_string = "DROP INDEX ON " & Substitute ( pField ; [ "::" ; "." ] ) ] ; MBS ( "FM.ExecuteFileSQL" ; $$mbs_string ) )
                                                                                                                                                                                                                                                                                              __MBS_FM_2_COUNTpFile;pTableAll accounts/* __MBS_FM_2_COUNT ( pFile ; pTable ) */ Let ( [ $$mbs_string = "SELECT COUNT (*) FROM " & pTable ] ; MBS ( "FM.ExecuteFileSQL" ; pFile ; $$mbs_string ) )
                                                                                                                                                                                                                                                                                                __MBS_FM_2_COUNT_WherepFile;pTable;pWhereAll accounts/* __MBS_FM_2_COUNT_Where ( pFile ; pTable ; pWhere ) */ Let ( [ $$mbs_string = "SELECT COUNT (*) FROM " & pTable & " WHERE " & pWhere ] ; MBS ( "FM.ExecuteFileSQL" ; pFile ; $$mbs_string ) )
                                                                                                                                                                                                                                                                                                  __MBS_FM_2_DeleteALLpFile;pTableAll accounts/*__MBS_FM_2_DeleteALL ( pFile ; pTable ) */ Let ( [ $$mbs_string = "DELETE FROM " & pTable ] ; MBS ( "FM.ExecuteFileSQL" ; pFile ; $$mbs_string ) )
                                                                                                                                                                                                                                                                                                    __MBS_FM_2_DeleteGUIDpFile;pTable;pGUIDAll accounts/*__MBS_FM_2_DeleteGUID ( pFile , pTable, pGUID ) */ Let ( [ $$MBS_FMstring = "DELETE FROM " & pTable & " WHERE a001t_GUID" & " = " & pGUID ] ; MBS ( "FM.ExecuteFileSQL" ; pFile ; $$MBS_FMstring ) )
                                                                                                                                                                                                                                                                                                      __MBS_FM_2_ExecutepFile;pStatementAll accounts/* __MBS_FM_2_Execute ( pFile ; pStatement ) */ Let ( [ $$MBS_FMPstring = pStatement ] ; MBS ( "FM.ExecuteFileSQL" ; pFile ; $$MBS_FMPstring ) )
                                                                                                                                                                                                                                                                                                        __MBS_FM_3_Execute_to_FoundsetpFile;pStatementAll accounts/* __MBS_FM_3_Execute_to_Foundset ( pFile ; pStatement ) */ Let ( [ $$MBS_FMPstring = pStatement ] ; MBS ( "FM.SQL.Execute" ; pFile ; $$MBS_FMPstring ) )
                                                                                                                                                                                                                                                                                                          __MBS_FM_3_Insert_Foundset_to_SQLpSQLref;pConnect;pTable;pFieldsAll accounts/* __MBS_FM_3_Insert_Foundset_to_SQL */ Let ( [ $$MBS_FMPstring = "<" & pSQLref & "><" & pTable & "><" & pFields & ">" ] ; MBS ( "FM.SQL.InsertRecordsToSQL" ; pSQLref; pConnect; pTable; pFields ) ) //Return SQLref
                                                                                                                                                                                                                                                                                                            __MBS_FM_3_ReleaseMemorypRecordsAll accounts/* __MBS_FM_3_ReleaseMemory (pRecords)*/ MBS ( "FM.SQL.Release" ; pRecords )
                                                                                                                                                                                                                                                                                                              __MBS_SQL_____All accounts
                                                                                                                                                                                                                                                                                                                __MBS_SQL_1_DisconnectpConnectionAll accounts/*__MBS_SQL_1_Disconnect (pConnection)*/ MBS ( "SQL.Disconnect"; pConnection )
                                                                                                                                                                                                                                                                                                                  __MBS_SQL_1_FreeAllConnectionsAll accounts/*__MBS_SQL_1_FreeAllConnections*/ MBS ( "SQL.FreeAllConnections" ; $$connection )
                                                                                                                                                                                                                                                                                                                    __MBS_SQL_1_FreeConnectionpConnectionAll accounts/*__MBS_SQL_1_FreeConnection (pConnection)*/ MBS ( "SQL.FreeConnection" ; pConnection )
                                                                                                                                                                                                                                                                                                                      __MBS_SQL_1_isConnectedAll accounts/* __MBS_SQL_1_isConnected*/ MBS ( "SQL.isConnected" ; $$connection )
                                                                                                                                                                                                                                                                                                                        __MBS_SQL_1_NewConnectionAll accounts/*__MBS_SQL_1_NewConnection*/ Case ( $$SQL_Client = "MySQL" ; __MBS_SQL_1_NewConnection_MySQL ; $$SQL_Client = "SQLite" ; __MBS_SQL_1_NewConnection_SQLite )
                                                                                                                                                                                                                                                                                                                          __MBS_SQL_1_NewConnection_MySQLAll accounts/* __MBS_SQL_1_NewConnection*/ Let ( [ result1 = MBS ( "SQL.FreeConnection" ; $$Connection ) ; connection = MBS ( "SQL.NewConnection" ) ; r = MBS ( "SQL.SetClient" ; connection ; $$SQL_Client ) ; r = MBS ( "SQL.SetConnectionOption" ; connection ; "MYSQL.LIBS" ; $$SQL_Library ) ; r = MBS ( "SQL.SetConnectionOption" ; connection ; "MYSQL_SECURE_AUTH" ; "FALSE" ) ; connect = MBS ( "SQL.Connect" ; connection ; $$SQL_ServerURL & "@" & $$SQL_DB; $$SQL_User ; $$SQL_PW ; $$SQL_Client ) ; result2 = Case ( connect ≠ "OK" ; MBS ( "SQL.FreeConnection" ; connection ) ; connection ) ] ; Case ( connect ≠ "OK" ; "Error: " & connect ; connection ) )
                                                                                                                                                                                                                                                                                                                            __MBS_SQL_1_NewConnection_SQLiteAll accounts/* __MBS_SQL_1_NewConnection*/ Let ( [ result1 = MBS ( "SQL.FreeConnection" ; $$Connection ) ; connection = MBS ( "SQL.NewConnection" ) ; r = MBS ( "SQL.SetClient" ; connection ; $$SQL_Client ) ; r = MBS ( "SQL.InternalSQLiteLibrary.Activate" ) ; connect = MBS ( "SQL.Connect" ; connection ; $$SQLite_DBpath ) ; result2 = Case ( connect ≠ "OK" ; MBS ( "SQL.FreeConnection" ; connection ) ; connection ) ] ; Case ( connect ≠ "OK" ; "Error: " & connect ; connection ) )
                                                                                                                                                                                                                                                                                                                              __MBS_SQL_1_ResetConnectionAll accounts/*__MBS_SQL_1_ResetConnection*/ MBS ( "SQL.ResetConnection" ; $$connection )
                                                                                                                                                                                                                                                                                                                                __MBS_SQL_2_FreeCommandpCommandAll accounts/* __MBS_SQL_2_FreeCommand (pCommand)*/ MBS ( "SQL.FreeCommand"; pCommand )
                                                                                                                                                                                                                                                                                                                                  __MBS_SQL_2_NewCommandpConnection;pStatementAll accounts/*__MBS_SQL_2_NewCommand (pConnection, pStatement)*/ Let ( [ $$MBS_SQLstring = pStatement ] ; MBS ( "SQL.NewCommand" ; pConnection ; pStatement ) )
                                                                                                                                                                                                                                                                                                                                    __MBS_SQL_3_CommitpConnectionAll accounts/* __MBS_SQL_3_Commit (pCommand)*/ MBS ( "SQL.Commit"; pConnection )
                                                                                                                                                                                                                                                                                                                                      __MBS_SQL_3_Execute_to_FoundsetpCommandAll accounts/*__MBS_SQL_3_Execute_2_Foundset (pCommand)*/ MBS ( "SQL.Execute" ; pCommand )
                                                                                                                                                                                                                                                                                                                                        __MBS_SQL_3_FieldCountpCommandAll accounts/* __MBS_SQL_3_FieldCount (pCommand)*/ MBS ( "SQL.FieldCount" ; pCommand )
                                                                                                                                                                                                                                                                                                                                          __MBS_SQL_3_Insert_Foundset_to_FMpCommand;pFM_File;pFM_Table;pFM_FieldsAll accounts/* __MBS_SQL_3_Insert_Foundset_to_FM ( pCommand, pFM_File, pFM_Table, pFM_Fields ) */ Let ( [ $$MBS_SQLstring = "<" & pCommand & "><" & pFM_File & "><" & pFM_Table & "><" & pFM_Fields & ">" ] ; MBS ( "SQL.InsertRecords"; pCommand ; pFM_File; pFM_Table; pFM_Fields ) )
                                                                                                                                                                                                                                                                                                                                            __MBS_SQL_3_RowsAffectedpCommandAll accounts/* __MBS_SQL_3_RowsAffected (pCommand)*/ MBS ( "SQL.RowsAffected" ; pCommand )
                                                                                                                                                                                                                                                                                                                                              __SCRIPT_____All accounts
                                                                                                                                                                                                                                                                                                                                                __SCRIPT_ErgebnispZeileAll accounts/* __SCRIPT_Ergebnis*/ Substitute ( MiddleValues ( Get ( ScriptResult ) ; pZeile; 1) ; "¶" ;"")
                                                                                                                                                                                                                                                                                                                                                  __SCRIPT_ParameterpZeileAll accounts/* __SCRIPT_Parameter */ Substitute ( MiddleValues ( Get ( ScriptParameter ) ; pZeile; 1) ; "¶" ;"")
                                                                                                                                                                                                                                                                                                                                                    __SCRIPT_SQL_Value4InsertpValue;pTyp;pCommaAll accounts/* __SCRIPT_SQL_Value4Insert ( pValue ; pTyp ; pComma ) pTyp: t=Text, n=Zahl ; */ Case ( pTyp = "t" ; "'" & pValue & "'" & pComma; pTyp = "n" ; pValue & pComma )
                                                                                                                                                                                                                                                                                                                                                      __SCRIPT_SQL_Value4UpdatepField;pValue;pTypAll accounts/* __SCRIPT_SQL_Value4Update ( pField ; pValue ; pTyp ) pTyp: t=Text, n=Zahl ; */ pField & " = " & Case ( pTyp = "t" ; "'" & pValue & "'" ; pTyp = "n" ; pValue )
                                                                                                                                                                                                                                                                                                                                                        __SCRIPT_SQL_Value4WherepValue;pTypAll accounts/* __SCRIPT_SQL_Value4Where ( pValue ; pTyp ) pTyp: t=Text, n=Zahl ; */ Case ( pTyp = "t" ; "'" & pValue & "'" ; pTyp = "n" ; pValue )
                                                                                                                                                                                                                                                                                                                                                          __SCRIPT_SQL_ValueSeparatorpValue;pCommaAll accounts/* __SCRIPT_SQL_ValueSeparator ( pValue ) ; */ "'" & pValue & "'" & pComma
                                                                                                                                                                                                                                                                                                                                                            __SCRPIT_SQL_ValuepValue;pCommaAll accounts/* __SCRPIT_SQL_Value ( pValue ) */ pValue & pComma
                                                                                                                                                                                                                                                                                                                                                              __VAR_____All accounts
                                                                                                                                                                                                                                                                                                                                                                __VAR_DeletepNameAll accounts/*__Var_Delete ( pName)*/ MBS ( "FM.VariableClear"; pName )
                                                                                                                                                                                                                                                                                                                                                                  __VAR_GetpNameAll accounts/*__Var_Get ( pName)*/ MBS ( "FM.VariableGet"; pName )
                                                                                                                                                                                                                                                                                                                                                                    __VAR_ListAll accounts/*__Var_List ( )*/ MBS ( "FM.VariableList" ; "—-" )
                                                                                                                                                                                                                                                                                                                                                                      __VAR_SetpName;pValueAll accounts/*__Var_Set ( pName; pValue )*/ MBS ( "FM.VariableSet"; pName; pValue )
                                                                                                                                                                                                                                                                                                                                                                        __XML_____All accounts
                                                                                                                                                                                                                                                                                                                                                                          __XML_1ValuepXML;pValue;pFeldPosAll accounts/* __XML_1Value ; pXML ; pValue ; pFeldPos */ Let ( [ FP = pFeldPos ; L = Length ( pValue ) + 2 ; Pos1 = Position ( pXML ; "<" & pValue & ">" ;1 ; FP ) + L ; Pos2 = Position ( pXML ; "</" & pValue & ">" ; 1 ; FP ) - ( Position ( pXML ; "<" & pValue & ">" ;1 ; FP ) + L ) ] ; Middle ( pXML ; Pos1 ; Pos2 ) )
                                                                                                                                                                                                                                                                                                                                                                            __XML_2ValuespXML;pValueA;pValueB;pFieldNoAll accounts/* __XML_2Values ; pXML ; pValueA ; pValueB ; pFieldNo */ Let ( [ s = Middle ( pXML ; Position ( pXML ; pValueA ; 1 ; pFieldNo ) + Length ( pValueA ) ; 200000 ) ; p = Position ( s ; pValueB ; 1 ; 1 ) - 1 ] ; Left ( s ; p ) )
                                                                                                                                                                                                                                                                                                                                                                              __GEN_RabattpBetrag;pRabattAll accounts/*__GEN_Rabatt ; pBetrag , pRabatt */ /* Die Verwendung findet man hauptsächlich im Handwerk / Rabatt-Rabatt-Rabatt ; 10% - 5% - 3% */ Let ( [ rF = Substitute ( pRabatt ; "+" ; "¶" ) ; r1 = LeftValues ( rF ; 1) ; r2 = MiddleValues ( rF ;2; 1) ; r3 = MiddleValues ( rF ;3; 1) ; b1 = Round ( pBetrag * r1 / 100 ;2) ; b2 = If (IsEmpty ( r2 ) ; 0 ; Round ( ( pBetrag - b1 ) * r2 / 100 ; 2 ) ) ; b3 = If (IsEmpty ( r3 ) ; 0 ; Round ( ( pBetrag - b1 - b2 ) * r3 /100 ; 2 ) ) ] ; b1 + b2 + b3 )

                                                                                                                                                                                                                                                                                                                                                                                Custom Menu Sets

                                                                                                                                                                                                                                                                                                                                                                                Menu SetsMenusIn ScriptsIn LayoutsComments
                                                                                                                                                                                                                                                                                                                                                                                [Standard FileMaker Menus]
                                                                                                                                                                                                                                                                                                                                                                                • All Standard Menus
                                                                                                                                                                                                                                                                                                                                                                                Angepasstes Menüset 1

                                                                                                                                                                                                                                                                                                                                                                                Download example: FileMaker Snippet Storage

                                                                                                                                                                                                                                                                                                                                                                                Used functions:




                                                                                                                                                                                                                                                                                                                                                                                Links
                                                                                                                                                                                                                                                                                                                                                                                MBS Xojo PDF Plugins