MBS FileMaker Plugin Example Databases

Encryption Cipher

All examples are included with download of MBS FileMaker Plugin.

Encryption Cipher.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts2
Value Lists0
Custom Functions0
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
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Encryption Cipher
20 fields defined, 4 records
Encryption Cipher

Fields

Table Name: Encryption Cipher - 20 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
AlgorithmNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      KeyTypeNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          KeyEncodingNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              KeyDataNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  InputTypeNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      InputDataNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          InputEncodingNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              OutputTypeNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  OutputInfoNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      IVTypeNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                            IVDataNormal, TextAuto-Enter:
                                            • Allow editing
                                            Validation:
                                            • Only during data entry
                                            Storage:
                                            • Repetitions: 1
                                            • Indexing: None
                                            • Automatically create indexes as needed
                                            • Index Language: German
                                                  IVEncodingNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                        InputContainerNormal, BinaryAuto-Enter:
                                                        • Allow editing
                                                        Validation:
                                                        • Only during data entry
                                                        Storage:
                                                        • Repetitions: 1
                                                            OutputContainerNormal, BinaryAuto-Enter:
                                                            • Allow editing
                                                            Validation:
                                                            • Only during data entry
                                                            Storage:
                                                            • Repetitions: 1
                                                                DescriptionNormal, TextAuto-Enter:
                                                                • Allow editing
                                                                Validation:
                                                                • Only during data entry
                                                                Storage:
                                                                • Repetitions: 1
                                                                • Indexing: None
                                                                • Automatically create indexes as needed
                                                                • Index Language: German
                                                                      OutputDataNormal, TextAuto-Enter:
                                                                      • Allow editing
                                                                      Validation:
                                                                      • Only during data entry
                                                                      Storage:
                                                                      • Repetitions: 1
                                                                      • Indexing: None
                                                                      • Automatically create indexes as needed
                                                                      • Index Language: German
                                                                          DecryptedTypeNormal, TextAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                              DecryptedContainerNormal, BinaryAuto-Enter:
                                                                              • Allow editing
                                                                              Validation:
                                                                              • Only during data entry
                                                                              Storage:
                                                                              • Repetitions: 1
                                                                                  DecryptedDataNormal, TextAuto-Enter:
                                                                                  • Allow editing
                                                                                  Validation:
                                                                                  • Only during data entry
                                                                                  Storage:
                                                                                  • Repetitions: 1
                                                                                  • Indexing: None
                                                                                  • Automatically create indexes as needed
                                                                                  • Index Language: German
                                                                                      DecryptedInfoNormal, TextAuto-Enter:
                                                                                      • Allow editing
                                                                                      Validation:
                                                                                      • Only during data entry
                                                                                      Storage:
                                                                                      • Repetitions: 1
                                                                                      • Indexing: None
                                                                                      • Automatically create indexes as needed
                                                                                      • Index Language: German

                                                                                          Layout Objects: Encryption Cipher

                                                                                          Regular Fields

                                                                                          Field Name: Encryption Cipher::Algorithm
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 78 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 92 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::KeyType
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 96 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 110 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::KeyEncoding
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 132 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 146 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::KeyData
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 114 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 128 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::InputType
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 150 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 164 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::InputData
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 294 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 308 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::InputEncoding
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 312 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 326 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::OutputType
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 330 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 344 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::OutputInfo
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 348 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 362 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::IVType
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 510 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 524 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::IVData
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 528 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 542 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::IVEncoding
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 546 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 560 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::InputContainer
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 167 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 292 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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
                                                                                          No

                                                                                          Field Name: Encryption Cipher::OutputContainer
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 365 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 490 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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
                                                                                          No

                                                                                          Field Name: Encryption Cipher::Description
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 24 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 74 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::OutputData
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 492 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 506 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::DecryptedType
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 564 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 578 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::DecryptedContainer
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 582 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 707 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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
                                                                                          No

                                                                                          Field Name: Encryption Cipher::DecryptedData
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 708 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 722 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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: Encryption Cipher::DecryptedInfo
                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                          • Top: 726 pt
                                                                                          • Left: 138 pt
                                                                                          • Bottom: 740 pt
                                                                                          • Right: 391 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Field Format:
                                                                                          • Edit Box
                                                                                          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

                                                                                          Group Buttons

                                                                                          Button PropertiesCoordinatesScript/Script Step
                                                                                            Type:
                                                                                          • Text: Test
                                                                                            Additional Properties:
                                                                                          • Change to hand cursor over button
                                                                                          • Rectangular
                                                                                          • Top: 42 pt
                                                                                          • Left: 420 pt
                                                                                          • Bottom: 67 pt
                                                                                          • Right: 535 pt
                                                                                          • Anchoring: Left, Top
                                                                                          Perform Script [ “Run” ]

                                                                                          Scripts:


                                                                                          Script Hierarchy

                                                                                          Run
                                                                                          Clear

                                                                                          Next Script: [Clear]
                                                                                          Script NameRun
                                                                                          Run script with full access privilegesOff
                                                                                          Include In MenuYes
                                                                                          Layouts that use this script
                                                                                          Scripts that use this script
                                                                                            Script Definition
                                                                                            Script Steps
                                                                                            • #encrypt
                                                                                            • Set Variable [ $InputData; Value:Encryption Cipher::InputData ]
                                                                                            • If [ Length($InputData) = 0 ]
                                                                                            • Set Variable [ $InputData; Value:Encryption Cipher::InputContainer ]
                                                                                            • End If
                                                                                            • Set Variable [ $r; Value:MBS( "Encryption.Cipher"; "Encrypt"; Encryption Cipher::Algorithm; Encryption Cipher::KeyType; Encryption Cipher::KeyData; Encryption Cipher::KeyEncoding; Encryption Cipher::InputType; $InputData; Encryption Cipher::InputEncoding; Encryption Cipher::OutputType; Encryption Cipher::OutputInfo ) ]
                                                                                            • If [ MBS("IsError") ]
                                                                                            • Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                            • Else
                                                                                            • Set Field [ Encryption Cipher::OutputData; $r ]
                                                                                            • Set Field [ Encryption Cipher::OutputContainer; $r ]
                                                                                            • End If
                                                                                            • #decrypt
                                                                                            • If [ IsEmpty(Encryption Cipher::OutputContainer) ]
                                                                                            • Set Variable [ $InputData; Value:Encryption Cipher::OutputData ]
                                                                                            • Else
                                                                                            • Set Variable [ $InputData; Value:Encryption Cipher::OutputContainer ]
                                                                                            • End If
                                                                                            • Set Variable [ $r; Value:MBS( "Encryption.Cipher"; "Decrypt"; Encryption Cipher::Algorithm; Encryption Cipher::KeyType; Encryption Cipher::KeyData; Encryption Cipher::KeyEncoding; Encryption Cipher::OutputType; $InputData; Encryption Cipher::OutputInfo; Encryption Cipher::DecryptedType; Encryption Cipher::DecryptedInfo ) ]
                                                                                            • If [ MBS("IsError") ]
                                                                                            • Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Abbrechen”, Commit: “No” ]
                                                                                            • Else
                                                                                            • Set Field [ Encryption Cipher::DecryptedData; $r ]
                                                                                            • Set Field [ Encryption Cipher::DecryptedContainer; $r ]
                                                                                            • End If
                                                                                            Fields used in this script
                                                                                            Scripts used in this script
                                                                                              Layouts used in this script
                                                                                                Tables used in this script
                                                                                                Table occurrences used by this script
                                                                                                Custom Functions used by this script
                                                                                                  Custom menu set used by this script

                                                                                                    Previous Script: [Run]
                                                                                                    Script NameClear
                                                                                                    Run script with full access privilegesOff
                                                                                                    Include In MenuYes
                                                                                                    Layouts that use this script
                                                                                                      Scripts that use this script
                                                                                                        Script Definition
                                                                                                        Script Steps
                                                                                                        • Go to Record/Request/Page [ First ]
                                                                                                        • Loop
                                                                                                        • Set Field [ Encryption Cipher::OutputContainer; "" ]
                                                                                                        • Set Field [ Encryption Cipher::OutputData; "" ]
                                                                                                        • Set Field [ Encryption Cipher::DecryptedContainer; "" ]
                                                                                                        • Set Field [ Encryption Cipher::DecryptedData; "" ]
                                                                                                        • Go to Record/Request/Page [ Next; Exit after last ]
                                                                                                        • End Loop
                                                                                                        • Go to Record/Request/Page [ First ]
                                                                                                        Fields used in this script
                                                                                                        Scripts used in this script
                                                                                                          Layouts used in this script
                                                                                                            Tables used in this script
                                                                                                            Table occurrences used by this script
                                                                                                            Custom Functions used by this script
                                                                                                              Custom menu set used by this script

                                                                                                                Download example: Encryption Cipher

                                                                                                                Used functions:




                                                                                                                Links
                                                                                                                MBS FileMaker Plugins