MBS FileMaker Plugin Example Databases

Certificate Info

All examples are included with download of MBS FileMaker Plugin.

Certificate Info.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts3
Value Lists0
Custom Functions0
Custom Menus0
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
Zertifikat
6 fields defined, 1 record
Zertifikat

Fields

Table Name: Zertifikat - 6 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
Certificate TextNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      DescriptionNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          SerialNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              NameNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  IssuerNameNormal, TextAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      SubjectNameNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German

                          Layout Objects: Zertifikat

                          Regular Fields

                          Field Name: Zertifikat::Certificate Text
                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                          • Top: 66 pt
                          • Left: 132 pt
                          • Bottom: 186 pt
                          • Right: 688 pt
                          • Anchoring: Left, Top
                          Field Format:
                          • Edit Box
                          Field Behavior:
                          • Allow field to be entered: In Find mode, In Browse mode
                          • Touch keyboard type: Default for Data Type
                          • Go to next field using: Tab key
                          Yes

                          Field Name: Zertifikat::Description
                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                          • Top: 193 pt
                          • Left: 132 pt
                          • Bottom: 338 pt
                          • Right: 688 pt
                          • Anchoring: Left, Top
                          Field Format:
                          • Edit Box
                          Field Behavior:
                          • Allow field to be entered: In Find mode, In Browse mode
                          • Touch keyboard type: Default for Data Type
                          • Go to next field using: Tab key
                          Yes

                          Field Name: Zertifikat::Serial
                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                          • Top: 345 pt
                          • Left: 134 pt
                          • Bottom: 366 pt
                          • Right: 688 pt
                          • Anchoring: Left, Top
                          Field Format:
                          • Edit Box
                          Field Behavior:
                          • Allow field to be entered: In Find mode, In Browse mode
                          • Touch keyboard type: Default for Data Type
                          • Go to next field using: Tab key
                          Yes

                          Field Name: Zertifikat::Name
                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                          • Top: 373 pt
                          • Left: 132 pt
                          • Bottom: 394 pt
                          • Right: 686 pt
                          • Anchoring: Left, Top
                          Field Format:
                          • Edit Box
                          Field Behavior:
                          • Allow field to be entered: In Find mode, In Browse mode
                          • Touch keyboard type: Default for Data Type
                          • Go to next field using: Tab key
                          Yes

                          Field Name: Zertifikat::IssuerName
                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                          • Top: 401 pt
                          • Left: 134 pt
                          • Bottom: 457 pt
                          • Right: 688 pt
                          • Anchoring: Left, Top
                          Field Format:
                          • Edit Box
                          Field Behavior:
                          • Allow field to be entered: In Find mode, In Browse mode
                          • Touch keyboard type: Default for Data Type
                          • Go to next field using: Tab key
                          Yes

                          Field Name: Zertifikat::SubjectName
                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                          • Top: 459 pt
                          • Left: 134 pt
                          • Bottom: 523 pt
                          • Right: 688 pt
                          • Anchoring: Left, Top
                          Field Format:
                          • Edit Box
                          Field Behavior:
                          • Allow field to be entered: In Find mode, In Browse mode
                          • Touch keyboard type: Default for Data Type
                          • Go to next field using: Tab key
                          Yes

                          Buttons

                          Button PropertiesCoordinatesScript/Script Step
                            Type:
                          • Text: Show Infos
                          • Top: 73 pt
                          • Left: 731 pt
                          • Bottom: 107 pt
                          • Right: 889 pt
                          • Anchoring: Left, Top
                          Perform Script [ “Show Infos Text” ]

                          Scripts:


                          Script Hierarchy

                          Show Infos Text
                          Clear
                          Convert Hex to Base64

                          Next Script: [Clear]
                          Script NameShow Infos Text
                          Run script with full access privilegesOff
                          Include In MenuYes
                          Layouts that use this script
                          Scripts that use this script
                            Script Definition
                            Script Steps
                            • Set Variable [ $cert; Value:MBS( "X509.Read"; Zertifikat::Certificate Text ) ]
                            • Set Variable [ $serial; Value:MBS( "X509.SerialNumber"; $cert ) ]
                            • Set Field [ Zertifikat::Serial; $serial ]
                            • Set Variable [ $desc; Value:MBS( "X509.Description"; $cert ) ]
                            • Set Field [ Zertifikat::Description; $desc ]
                            • Set Variable [ $name; Value:MBS( "X509.Name"; $cert ) ]
                            • Set Field [ Zertifikat::Name; $name ]
                            • Set Variable [ $issuer; Value:MBS( "X509.IssuerName"; $cert ) ]
                            • Set Field [ Zertifikat::IssuerName; $issuer ]
                            • Set Variable [ $subject; Value:MBS( "X509.SubjectName"; $cert ) ]
                            • Set Field [ Zertifikat::SubjectName; $subject ]
                            • Set Variable [ $r; Value:MBS( "X509.Release"; $cert) ]
                            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: [Show Infos Text]Next Script: [Convert Hex to Base64]
                                    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
                                        • Set Field [ Zertifikat::Description; "" ]
                                        • Set Field [ Zertifikat::Serial; "" ]
                                        • Set Field [ Zertifikat::Name; "" ]
                                        • Set Field [ Zertifikat::IssuerName; "" ]
                                        • Set Field [ Zertifikat::SubjectName; "" ]
                                        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: [Clear]
                                                Script NameConvert Hex to Base64
                                                Run script with full access privilegesOff
                                                Include In MenuYes
                                                Layouts that use this script
                                                  Scripts that use this script
                                                    Script Definition
                                                    Script Steps
                                                    • Set Field [ Zertifikat::Certificate Text; "-----BEGIN CERTIFICATE-----¶" & MBS("Text.EncodeHexToBase64"; Zertifikat::Certificate Text) & "¶-----END CERTIFICATE-----¶" ]
                                                    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: Certificate Info

                                                            Used functions:




                                                            Links
                                                            MBS Xojo PDF Plugins