MBS FileMaker Plugin Example Databases

EPC-QR-Code

All examples are included with download of MBS FileMaker Plugin.

EPC-QR-Code.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts1
Value Lists0
Custom Functions0
Custom Menus24
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
Tabelle
11 fields defined, 1 record
Tabelle

Fields

Table Name: Tabelle - 11 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
BICNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      VersionNormal, 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
              IBANNormal, TextAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  AmountNormal, NumberAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      IntentionNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          Reference1Normal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              Reference2Normal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  NoteNormal, TextAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      BarcodeNormal, BinaryAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                          CodeNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German

                                              Layout Objects: Tabelle

                                              Regular Fields

                                              Field Name: Tabelle::BIC
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 52 pt
                                              • Left: 138 pt
                                              • Bottom: 73 pt
                                              • Right: 455 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: Tabelle::Version
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 75 pt
                                              • Left: 138 pt
                                              • Bottom: 96 pt
                                              • Right: 455 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: Tabelle::Name
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 98 pt
                                              • Left: 138 pt
                                              • Bottom: 119 pt
                                              • Right: 455 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: Tabelle::IBAN
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 121 pt
                                              • Left: 138 pt
                                              • Bottom: 142 pt
                                              • Right: 455 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: Tabelle::Amount
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 144 pt
                                              • Left: 138 pt
                                              • Bottom: 165 pt
                                              • Right: 455 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: Tabelle::Intention
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 167 pt
                                              • Left: 138 pt
                                              • Bottom: 188 pt
                                              • Right: 455 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: Tabelle::Reference1
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 190 pt
                                              • Left: 138 pt
                                              • Bottom: 211 pt
                                              • Right: 455 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: Tabelle::Reference2
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 213 pt
                                              • Left: 138 pt
                                              • Bottom: 234 pt
                                              • Right: 455 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: Tabelle::Note
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 236 pt
                                              • Left: 138 pt
                                              • Bottom: 257 pt
                                              • Right: 455 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: Tabelle::Barcode
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 259 pt
                                              • Left: 138 pt
                                              • Bottom: 507 pt
                                              • Right: 455 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
                                              No

                                              Field Name: Tabelle::Code
                                              Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                              • Top: 260 pt
                                              • Left: 530 pt
                                              • Bottom: 507 pt
                                              • Right: 847 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

                                              Script Hierarchy

                                              Generate EPC

                                              Script NameGenerate EPC
                                              Run script with full access privilegesOff
                                              Include In MenuYes
                                              Layouts that use this script
                                                Scripts that use this script
                                                  Script Definition
                                                  Script Steps
                                                  • #EPC-QR-Code generation
                                                  • Go to Layout [ “Tabelle” ]
                                                  • #Sample data for QR-Code. May need adjustment to final standard
                                                  • Set Variable [ $text; Value:// Service Tag "BCD" & ¶ & // Version (001 oder 002) Right( Tabelle::Version ; 4 ) & ¶ & // Character set: 1 = UTF-8 "1" & ¶ & // Identification: SEPA Credit Transfer "SCT" & ¶ & // BIC of receiver. optional for EEA Tabelle::BIC & ¶ & // Name of receiver Left(Tabelle::Name; 70) & ¶ & // IBAN of receiver Tabelle::IBAN & ¶ & // Amount. We replace comma with dot for German amounts "EUR" & Substitute(Tabelle::Amount; ","; ".") & ¶ & // Zweck, 4 letter code, optional Left(Tabelle::Intention; 4) & ¶ & // Reference 35-Character-Code, see ISO 11649 RF Creditor Reference Left(Tabelle::Reference1; 35) & ¶ & // Reference Left(Tabelle::Reference2; 140) & ¶ & // Note to user Tabelle::Note ]
                                                  • #Barcode options. We use high level as we draw over barcode.
                                                  • Set Variable [ $o; Value:MBS("Barcode.SetOptions"; 4) // ECC Level with values from 1 = low, 2 = middle, 3 = better, 4 high. ]
                                                  • Set Field [ Tabelle::Code; TextFormatRemove ( $text ) ]
                                                  • #CRLF line endings needed
                                                  • Set Variable [ $text; Value:MBS( "Text.ReplaceNewline"; $text; 3 ) ]
                                                  • #We render barcode at 4x size for better drawing later
                                                  • Set Variable [ $img; Value:MBS("Barcode.Generate";"QRCODE"; $text; 0; 0; 0; 4; 0; 1; "UTF-8") ]
                                                  • If [ MBS("IsError") = 0 ]
                                                  • #Save to field
                                                  • Set Field [ Tabelle::Barcode; MBS( "GMImage.WriteToPNGContainer"; $img; "barcode.png" ) ]
                                                  • #Clean up
                                                  • Set Variable [ $r; Value:MBS( "GMImage.Destroy"; $img) ]
                                                  • 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

                                                        Download example: EPC-QR-Code

                                                        Used functions:




                                                        Links
                                                        MBS Xojo Plugins

                                                        Start Chat