MBS FileMaker Plugin Example Databases

ISO20022 QR v2.0

All examples are included with download of MBS FileMaker Plugin.

ISO20022 QR v2.0.fmp12

Overview
Tables1
Relationships0
Layouts1
Scripts5
Value Lists1
Custom Functions6
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
OnFirstWindowOpenScript: Resize
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
EZ_QR
27 fields defined, 5 records
EZ_QR

Fields

Table Name: EZ_QR - 27 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
IBANNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German
      ZE_NameNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
          ZE_StrasseNormal, TextAuto-Enter:
          • Allow editing
          Validation:
          • Only during data entry
          Storage:
          • Repetitions: 1
          • Indexing: None
          • Automatically create indexes as needed
          • Index Language: German
              ZE_HausnummerNormal, NumberAuto-Enter:
              • Allow editing
              Validation:
              • Only during data entry
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                  ZE_PLZNormal, NumberAuto-Enter:
                  • Allow editing
                  Validation:
                  • Only during data entry
                  Storage:
                  • Repetitions: 1
                  • Indexing: None
                  • Automatically create indexes as needed
                  • Index Language: German
                      ZE_OrtNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                          EZE_NameNormal, TextAuto-Enter:
                          • Allow editing
                          Validation:
                          • Only during data entry
                          Storage:
                          • Repetitions: 1
                          • Indexing: None
                          • Automatically create indexes as needed
                          • Index Language: German
                              EZE_StrasseNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                  EZE_HausnummerNormal, NumberAuto-Enter:
                                  • Allow editing
                                  Validation:
                                  • Only during data entry
                                  Storage:
                                  • Repetitions: 1
                                  • Indexing: None
                                  • Automatically create indexes as needed
                                  • Index Language: German
                                      EZE_PLZNormal, NumberAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German
                                          EZE_OrtNormal, TextAuto-Enter:
                                          • Allow editing
                                          Validation:
                                          • Only during data entry
                                          Storage:
                                          • Repetitions: 1
                                          • Indexing: None
                                          • Automatically create indexes as needed
                                          • Index Language: German
                                              EZP_NameNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                                  EZP_StrasseNormal, TextAuto-Enter:
                                                  • Allow editing
                                                  Validation:
                                                  • Only during data entry
                                                  Storage:
                                                  • Repetitions: 1
                                                  • Indexing: None
                                                  • Automatically create indexes as needed
                                                  • Index Language: German
                                                      EZP_HausnummerNormal, NumberAuto-Enter:
                                                      • Allow editing
                                                      Validation:
                                                      • Only during data entry
                                                      Storage:
                                                      • Repetitions: 1
                                                      • Indexing: None
                                                      • Automatically create indexes as needed
                                                      • Index Language: German
                                                          EZP_PLZNormal, NumberAuto-Enter:
                                                          • Allow editing
                                                          Validation:
                                                          • Only during data entry
                                                          Storage:
                                                          • Repetitions: 1
                                                          • Indexing: None
                                                          • Automatically create indexes as needed
                                                          • Index Language: German
                                                              EZP_OrtNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: None
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                  zahlbarNormal, DateAuto-Enter:
                                                                  • Allow editing
                                                                  Validation:
                                                                  • Only during data entry
                                                                  Storage:
                                                                  • Repetitions: 1
                                                                  • Indexing: None
                                                                  • Automatically create indexes as needed
                                                                  • Index Language: German
                                                                      BetragNormal, NumberAuto-Enter:
                                                                      • Allow editing
                                                                      Validation:
                                                                      • Only during data entry
                                                                      Storage:
                                                                      • Repetitions: 1
                                                                      • Indexing: None
                                                                      • Automatically create indexes as needed
                                                                      • Index Language: German
                                                                          Ref_NummerNormal, NumberAuto-Enter:
                                                                          • Allow editing
                                                                          Validation:
                                                                          • Only during data entry
                                                                          Storage:
                                                                          • Repetitions: 1
                                                                          • Indexing: None
                                                                          • Automatically create indexes as needed
                                                                          • Index Language: German
                                                                              f_QRCalculated, TextCalculation: Auto-Enter:
                                                                              • Always evaluate
                                                                              Storage:
                                                                              • Repetitions: 1
                                                                              • Indexing: None
                                                                              • Automatically create indexes as needed
                                                                              • Index Language: German
                                                                                    f_QR_ResumeCalculated, TextCalculation: Auto-Enter:
                                                                                    • Always evaluate
                                                                                    Storage:
                                                                                    • Repetitions: 1
                                                                                    • Indexing: None
                                                                                    • Automatically create indexes as needed
                                                                                    • Index Language: German
                                                                                          f_EmpfangsscheinCalculated, TextCalculation: Auto-Enter:
                                                                                          • Always evaluate
                                                                                          Storage:
                                                                                          • Repetitions: 1
                                                                                          • Indexing: None
                                                                                          • Automatically create indexes as needed
                                                                                          • Index Language: German
                                                                                                QR_CodeNormal, BinaryAuto-Enter:
                                                                                                • Allow editing
                                                                                                Validation:
                                                                                                • Only during data entry
                                                                                                Storage:
                                                                                                • Repetitions: 1
                                                                                                    Dev_NotesNormal, TextAuto-Enter:
                                                                                                    • Allow editing
                                                                                                    Validation:
                                                                                                    • Only during data entry
                                                                                                    Storage:
                                                                                                    • Global
                                                                                                    • Repetitions: 1
                                                                                                    • Index Language: German
                                                                                                          ZoomNormal, NumberAuto-Enter:
                                                                                                          • Allow editing
                                                                                                          Validation:
                                                                                                          • Only during data entry
                                                                                                          Storage:
                                                                                                          • Global
                                                                                                          • Repetitions: 1
                                                                                                          • Index Language: German
                                                                                                                emptyNormal, TextAuto-Enter:
                                                                                                                • Allow editing
                                                                                                                Validation:
                                                                                                                • Only during data entry
                                                                                                                Storage:
                                                                                                                • Repetitions: 1
                                                                                                                • Indexing: None
                                                                                                                • Automatically create indexes as needed
                                                                                                                • Index Language: German
                                                                                                                      TypeNormal, TextAuto-Enter:
                                                                                                                      • Allow editing
                                                                                                                      Validation:
                                                                                                                      • Only during data entry
                                                                                                                      Storage:
                                                                                                                      • Repetitions: 1
                                                                                                                      • Indexing: None
                                                                                                                      • Automatically create indexes as needed
                                                                                                                      • Index Language: German

                                                                                                                          Layout Objects: EZ_QR_200

                                                                                                                          Regular Fields

                                                                                                                          Field Name: EZ_QR::ZE_Hausnummer
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 153 pt
                                                                                                                          • Left: 256 pt
                                                                                                                          • Bottom: 174 pt
                                                                                                                          • Right: 307 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZE_Hausnummer
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 248 pt
                                                                                                                          • Left: 250 pt
                                                                                                                          • Bottom: 269 pt
                                                                                                                          • Right: 309 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: EZ_QR::EZP_Hausnummer
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 343 pt
                                                                                                                          • Left: 274 pt
                                                                                                                          • Bottom: 364 pt
                                                                                                                          • Right: 307 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::ZE_Ort
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 176 pt
                                                                                                                          • Left: 151 pt
                                                                                                                          • Bottom: 197 pt
                                                                                                                          • Right: 308 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZE_Ort
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 271 pt
                                                                                                                          • Left: 146 pt
                                                                                                                          • Bottom: 292 pt
                                                                                                                          • Right: 309 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: EZ_QR::EZP_Ort
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 366 pt
                                                                                                                          • Left: 146 pt
                                                                                                                          • Bottom: 387 pt
                                                                                                                          • Right: 309 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZE_Name
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 225 pt
                                                                                                                          • Left: 101 pt
                                                                                                                          • Bottom: 246 pt
                                                                                                                          • Right: 309 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: EZ_QR::EZE_Strasse
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 248 pt
                                                                                                                          • Left: 101 pt
                                                                                                                          • Bottom: 269 pt
                                                                                                                          • Right: 275 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: EZ_QR::IBAN
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 107 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 128 pt
                                                                                                                          • Right: 308 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::ZE_Name
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 130 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 151 pt
                                                                                                                          • Right: 308 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::ZE_Strasse
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 153 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 174 pt
                                                                                                                          • Right: 274 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::ZE_PLZ
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 176 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 197 pt
                                                                                                                          • Right: 151 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZE_PLZ
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 271 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 292 pt
                                                                                                                          • Right: 146 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: EZ_QR::EZP_Name
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 320 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 341 pt
                                                                                                                          • Right: 308 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZP_Strasse
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 343 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 364 pt
                                                                                                                          • Right: 272 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZP_PLZ
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 366 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 387 pt
                                                                                                                          • Right: 146 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::zahlbar
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 413 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 434 pt
                                                                                                                          • Right: 221 pt
                                                                                                                          • Anchoring: Left, Top
                                                                                                                          Field Format:
                                                                                                                          • Drop-down Calendar
                                                                                                                          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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::Betrag
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 436 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 457 pt
                                                                                                                          • Right: 221 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::Ref_Nummer
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 459 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 480 pt
                                                                                                                          • Right: 311 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::empty
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 481 pt
                                                                                                                          • Left: 100 pt
                                                                                                                          • Bottom: 502 pt
                                                                                                                          • Right: 311 pt
                                                                                                                          • Anchoring: Left, Top
                                                                                                                          Field Format:
                                                                                                                          • Edit Box
                                                                                                                          Field Behavior:
                                                                                                                          • Touch keyboard type: Default for Data Type
                                                                                                                          • Go to next field using: Tab key
                                                                                                                          Yes

                                                                                                                          Field Name: EZ_QR::ZE_Hausnummer
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 153 pt
                                                                                                                          • Left: 274 pt
                                                                                                                          • Bottom: 174 pt
                                                                                                                          • Right: 309 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
                                                                                                                          Conditional FormattingConditionFormat
                                                                                                                          1.
                                                                                                                          • Value is empty
                                                                                                                          • Formula: IsEmpty(Self)

                                                                                                                            self:normal .self
                                                                                                                            {
                                                                                                                            background-color: rgba(98.8235%,95.2941%,1.96078%,1);
                                                                                                                            }

                                                                                                                          Field Name: EZ_QR::EZE_Hausnummer
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                            Hide Condition:
                                                                                                                          • 1
                                                                                                                          • Top: 248 pt
                                                                                                                          • Left: 272 pt
                                                                                                                          • Bottom: 269 pt
                                                                                                                          • Right: 307 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: EZ_QR::Type
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 86 pt
                                                                                                                          • Left: 401 pt
                                                                                                                          • Bottom: 102 pt
                                                                                                                          • Right: 468 pt
                                                                                                                          • Anchoring: Left, Top
                                                                                                                          Field Format:
                                                                                                                          • Radio Button Set
                                                                                                                          • Display values from: Type
                                                                                                                          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: EZ_QR::f_QR
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 122 pt
                                                                                                                          • Left: 349 pt
                                                                                                                          • Bottom: 433 pt
                                                                                                                          • Right: 582 pt
                                                                                                                          • Anchoring: Left, Top
                                                                                                                          Field Format:
                                                                                                                          • Edit Box
                                                                                                                          • Include vertical scrollbar
                                                                                                                          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: EZ_QR::QR_Code
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 82 pt
                                                                                                                          • Left: 37 pt
                                                                                                                          • Bottom: 607 pt
                                                                                                                          • Right: 562 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

                                                                                                                          Field Name: EZ_QR::Dev_Notes
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 84 pt
                                                                                                                          • Left: 11 pt
                                                                                                                          • Bottom: 590 pt
                                                                                                                          • Right: 586 pt
                                                                                                                          • Anchoring: Left, Top
                                                                                                                          Field Format:
                                                                                                                          • Edit Box
                                                                                                                          Field Behavior:
                                                                                                                          • Touch keyboard type: Default for Data Type
                                                                                                                          • Go to next field using: Tab key
                                                                                                                          No

                                                                                                                          Field Name: EZ_QR::f_QR_Resume
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 631 pt
                                                                                                                          • Left: 342 pt
                                                                                                                          • Bottom: 852 pt
                                                                                                                          • Right: 572 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: EZ_QR::QR_Code
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 657 pt
                                                                                                                          • Left: 188 pt
                                                                                                                          • Bottom: 797 pt
                                                                                                                          • Right: 328 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

                                                                                                                          Field Name: EZ_QR::Betrag
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 824 pt
                                                                                                                          • Left: 261 pt
                                                                                                                          • Bottom: 836 pt
                                                                                                                          • Right: 331 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: EZ_QR::Betrag
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 824 pt
                                                                                                                          • Left: 80 pt
                                                                                                                          • Bottom: 836 pt
                                                                                                                          • Right: 150 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: EZ_QR::f_Empfangsschein
                                                                                                                          Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                                                          • Top: 654 pt
                                                                                                                          • Left: 15 pt
                                                                                                                          • Bottom: 794 pt
                                                                                                                          • Right: 160 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

                                                                                                                          Merge Fields

                                                                                                                          Field PropertiesCoordinatesFieldsQuick Find
                                                                                                                            Text:
                                                                                                                          • {{RecordNumber}} /
                                                                                                                          • Top: 911 pt
                                                                                                                          • Left: 203 pt
                                                                                                                          • Bottom: 948 pt
                                                                                                                          • Right: 427 pt
                                                                                                                          • Anchoring: Left, Bottom
                                                                                                                            No

                                                                                                                            Group Buttons

                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 0 pt
                                                                                                                            • Left: 13 pt
                                                                                                                            • Bottom: 34 pt
                                                                                                                            • Right: 155 pt
                                                                                                                            • Anchoring: Left, Top
                                                                                                                            Show/Hide Toolbars [ Toggle ]

                                                                                                                            Button Bars

                                                                                                                            Button Bar PropertiesCoordinates
                                                                                                                              Orientation:
                                                                                                                            • horizontal
                                                                                                                            • Top: 915 pt
                                                                                                                            • Left: 0 pt
                                                                                                                            • Bottom: 945 pt
                                                                                                                            • Right: 593 pt
                                                                                                                            • Anchoring: Left, Bottom
                                                                                                                            Button Segments
                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Tooltip:
                                                                                                                            • "previous Record"
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 915 pt
                                                                                                                            • Left: 0 pt
                                                                                                                            • Bottom: 945 pt
                                                                                                                            • Right: 119 pt
                                                                                                                            Go to Record/Request/Page [ Previous ]
                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Tooltip:
                                                                                                                            • "create QR-Code"
                                                                                                                              Label Calculations:
                                                                                                                            • "create QR-Code"
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 915 pt
                                                                                                                            • Left: 119 pt
                                                                                                                            • Bottom: 945 pt
                                                                                                                            • Right: 237 pt
                                                                                                                            Perform Script [ “Make_QRCode” ]

                                                                                                                            Scripts:

                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Label Calculations:
                                                                                                                            • "new Record"
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 915 pt
                                                                                                                            • Left: 356 pt
                                                                                                                            • Bottom: 945 pt
                                                                                                                            • Right: 474 pt
                                                                                                                            New Record/Request
                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Tooltip:
                                                                                                                            • "next Record"
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 915 pt
                                                                                                                            • Left: 474 pt
                                                                                                                            • Bottom: 945 pt
                                                                                                                            • Right: 593 pt
                                                                                                                            Go to Record/Request/Page [ Next ]

                                                                                                                            Button Bar PropertiesCoordinates
                                                                                                                              Hide Condition:
                                                                                                                              Orientation:
                                                                                                                            • horizontal
                                                                                                                            • Top: 950 pt
                                                                                                                            • Left: 0 pt
                                                                                                                            • Bottom: 965 pt
                                                                                                                            • Right: 153 pt
                                                                                                                            • Anchoring: Left, Top
                                                                                                                            Button Segments
                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Label Calculations:
                                                                                                                            • " - "
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 951 pt
                                                                                                                            • Left: 38 pt
                                                                                                                            • Bottom: 965 pt
                                                                                                                            • Right: 76 pt
                                                                                                                            Perform Script [ “Zoom_In_Out”; Parameter: "Out" ]

                                                                                                                            Scripts:

                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Label Calculations:
                                                                                                                            • " + "
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 951 pt
                                                                                                                            • Left: 76 pt
                                                                                                                            • Bottom: 965 pt
                                                                                                                            • Right: 114 pt
                                                                                                                            Perform Script [ “Zoom_In_Out”; Parameter: "In" ]

                                                                                                                            Scripts:

                                                                                                                            Button PropertiesCoordinatesScript/Script Step
                                                                                                                              Type:
                                                                                                                            • Text:
                                                                                                                              Label Calculations:
                                                                                                                            • "Quit"
                                                                                                                              Additional Properties:
                                                                                                                            • Change to hand cursor over button
                                                                                                                            • Top: 951 pt
                                                                                                                            • Left: 114 pt
                                                                                                                            • Bottom: 965 pt
                                                                                                                            • Right: 152 pt
                                                                                                                            Perform Script [ “close_PC” ]

                                                                                                                            Scripts:


                                                                                                                            Button Bar PropertiesCoordinates
                                                                                                                              Orientation:
                                                                                                                            • horizontal
                                                                                                                            • Top: 876 pt
                                                                                                                            • Left: 161 pt
                                                                                                                            • Bottom: 901 pt
                                                                                                                            • Right: 186 pt
                                                                                                                            • Anchoring: Left, Top

                                                                                                                            Button Bar PropertiesCoordinates
                                                                                                                              Orientation:
                                                                                                                            • horizontal
                                                                                                                            • Top: 605 pt
                                                                                                                            • Left: 552 pt
                                                                                                                            • Bottom: 620 pt
                                                                                                                            • Right: 582 pt
                                                                                                                            • Anchoring: Left, Top

                                                                                                                            Tab Controls

                                                                                                                            Tab Control PropertiesCoordinates
                                                                                                                              Justification:
                                                                                                                            • Left
                                                                                                                              Tab Width:
                                                                                                                              Default Front Tab:
                                                                                                                            • Tab 0
                                                                                                                            • Top: 50 pt
                                                                                                                            • Left: 0 pt
                                                                                                                            • Bottom: 601 pt
                                                                                                                            • Right: 593 pt
                                                                                                                            • Anchoring: Left, Top
                                                                                                                            Tabs
                                                                                                                            Tab PropertiesTab ControlsSlide ControlsFieldsButtonsPortalsWeb Viewer ControlsCharts
                                                                                                                              Tab 0:
                                                                                                                            • "QR-Code"
                                                                                                                                Field Objects
                                                                                                                                  Tab 1:
                                                                                                                                • "Output"
                                                                                                                                    Field Objects
                                                                                                                                      Tab 2:
                                                                                                                                    • "Notes"
                                                                                                                                        Field Objects

                                                                                                                                        Graphic Objects

                                                                                                                                        Graphic Object PropertiesCoordinates
                                                                                                                                          Type:
                                                                                                                                        • Rectangle
                                                                                                                                          Hide Condition:
                                                                                                                                        • 1
                                                                                                                                        • Top: 220 pt
                                                                                                                                        • Left: 10 pt
                                                                                                                                        • Bottom: 297 pt
                                                                                                                                        • Right: 324 pt
                                                                                                                                        • Anchoring: Left, Top

                                                                                                                                        Graphic Object PropertiesCoordinates
                                                                                                                                          Type:
                                                                                                                                        • Text: EZE_Name
                                                                                                                                          Hide Condition:
                                                                                                                                        • 1
                                                                                                                                        • Top: 227 pt
                                                                                                                                        • Left: 37 pt
                                                                                                                                        • Bottom: 244 pt
                                                                                                                                        • Right: 92 pt
                                                                                                                                        • Anchoring: Left, Top

                                                                                                                                        Graphic Object PropertiesCoordinates
                                                                                                                                          Type:
                                                                                                                                        • Text: EZE_Strasse
                                                                                                                                          Hide Condition:
                                                                                                                                        • 1
                                                                                                                                        • Top: 251 pt
                                                                                                                                        • Left: 16 pt
                                                                                                                                        • Bottom: 267 pt
                                                                                                                                        • Right: 92 pt
                                                                                                                                        • Anchoring: Left, Top

                                                                                                                                        Graphic Object PropertiesCoordinates
                                                                                                                                          Type:
                                                                                                                                        • Text: EZE_PLZ_Ort
                                                                                                                                          Hide Condition:
                                                                                                                                        • 1
                                                                                                                                        • Top: 274 pt
                                                                                                                                        • Left: 13 pt
                                                                                                                                        • Bottom: 292 pt
                                                                                                                                        • Right: 92 pt
                                                                                                                                        • Anchoring: Left, Top

                                                                                                                                        Graphic Object PropertiesCoordinates
                                                                                                                                          Type:
                                                                                                                                        • Text: Endgültiger Zahlungsempfänger - EZE (fakultativ)
                                                                                                                                          Hide Condition:
                                                                                                                                        • 1
                                                                                                                                        • Top: 205 pt
                                                                                                                                        • Left: 10 pt
                                                                                                                                        • Bottom: 220 pt
                                                                                                                                        • Right: 324 pt
                                                                                                                                        • Anchoring: Left, Top

                                                                                                                                        Graphic Object PropertiesCoordinates
                                                                                                                                          Type:
                                                                                                                                        • Rectangle
                                                                                                                                          Tooltip:
                                                                                                                                        • "Toggle Toolbars"
                                                                                                                                        • Top: 0 pt
                                                                                                                                        • Left: 0 pt
                                                                                                                                        • Bottom: 42 pt
                                                                                                                                        • Right: 180 pt
                                                                                                                                        • Anchoring: Left, Top

                                                                                                                                        Value Lists

                                                                                                                                        Value List NameSourceValuesOn Layouts
                                                                                                                                        TypeCustom
                                                                                                                                        • K, S

                                                                                                                                        Script Hierarchy

                                                                                                                                        Make_QRCode
                                                                                                                                        showMenu_OR_FullAccess
                                                                                                                                        Zoom_In_Out
                                                                                                                                        Resize
                                                                                                                                        close_PC

                                                                                                                                        Next Script: [showMenu_OR_FullAccess]
                                                                                                                                        Script NameMake_QRCode
                                                                                                                                        Run script with full access privilegesOff
                                                                                                                                        Include In MenuYes
                                                                                                                                        Layouts that use this script
                                                                                                                                        Scripts that use this script
                                                                                                                                          Script Definition
                                                                                                                                          Script Steps
                                                                                                                                          • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                          • # purpose:
                                                                                                                                          • # description:
                                                                                                                                          • # dependencies:
                                                                                                                                          • # used in Layout/Script:
                                                                                                                                          • # comments:
                                                                                                                                          • # Author: EfficientBizz GmbH - Benjamin Fehr
                                                                                                                                          • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                          • // Beep
                                                                                                                                          • Set Variable [ $image; Value:MBS( "Barcode.SetOptions" ; 2; 0; 0) ]
                                                                                                                                          • If [ EZ_QR::Type = "S" ]
                                                                                                                                          • Set Variable [ $image; Value:MBS( "Barcode.Generate" ; "QRCODE" ; SPC_QRR200_S ( EZ_QR::ZE_Name ; EZ_QR::ZE_Strasse ; EZ_QR::ZE_Hausnummer ; EZ_QR::ZE_PLZ ; EZ_QR::ZE_Ort ; EZ_QR::EZE_Name ; EZ_QR::EZE_Strasse ; EZ_QR::EZE_Hausnummer ; EZ_QR::EZE_PLZ ; EZ_QR::EZE_Ort ; EZ_QR::EZP_Name ; EZ_QR::EZP_Strasse ; EZ_QR::EZP_Hausnummer ; EZ_QR::EZP_PLZ ; EZ_QR::EZP_Ort ; EZ_QR::IBAN ; EZ_QR::Ref_Nummer ; EZ_QR::Betrag ; EZ_QR::zahlbar ; " " ) ; 0; 0; 0; 4 /* Scale */ ) ]
                                                                                                                                          • Else
                                                                                                                                          • Set Variable [ $image; Value:MBS( "Barcode.Generate" ; "QRCODE" ; SPC_QRR200_K ( EZ_QR::ZE_Name ; EZ_QR::ZE_Strasse ; EZ_QR::ZE_PLZ ; EZ_QR::ZE_Ort ; EZ_QR::EZE_Name ; EZ_QR::EZE_Strasse ; EZ_QR::EZE_PLZ ; EZ_QR::EZE_Ort ; EZ_QR::EZP_Name ; EZ_QR::EZP_Strasse ; EZ_QR::EZP_PLZ ; EZ_QR::EZP_Ort ; EZ_QR::IBAN ; EZ_QR::Ref_Nummer ; EZ_QR::Betrag ; EZ_QR::zahlbar ; " " ) ; 0; 0; 0; 4 /* Scale */ ) ]
                                                                                                                                          • End If
                                                                                                                                          • If [ MBS("Iserror") = 0 ]
                                                                                                                                          • Set Field [ EZ_QR::QR_Code; MBS("GMImage.WriteToPNGContainer" ; $image ; "barcode.png") ]
                                                                                                                                          • Set Variable [ $r; Value:MBS("GMImage.Destroy"; $image) ]
                                                                                                                                          • Else
                                                                                                                                          • Set Field [ EZ_QR::QR_Code; "" ]
                                                                                                                                          • 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: [Make_QRCode]Next Script: [Zoom_In_Out]
                                                                                                                                                Script NameshowMenu_OR_FullAccess
                                                                                                                                                Run script with full access privilegesOn
                                                                                                                                                Include In MenuNo
                                                                                                                                                Layouts that use this script
                                                                                                                                                  Scripts that use this script
                                                                                                                                                    Script Definition
                                                                                                                                                    Script Steps
                                                                                                                                                    • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                                    • # purpose:
                                                                                                                                                    • # description:
                                                                                                                                                    • # dependencies:
                                                                                                                                                    • # used in Layout/Script:
                                                                                                                                                    • # comments:
                                                                                                                                                    • # Author: EfficientBizz GmbH - Benjamin Fehr
                                                                                                                                                    • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                                    • Refresh Window
                                                                                                                                                    • Show/Hide Toolbars [ Toggle ]
                                                                                                                                                    • Adjust Window [ Resize to Fit ]
                                                                                                                                                    • If [ Abs(Get(SystemPlatform))=2 ]
                                                                                                                                                    • Show/Hide Menubar [ Toggle ]
                                                                                                                                                    • Adjust Window [ Resize to Fit ]
                                                                                                                                                    • 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: [showMenu_OR_FullAccess]Next Script: [Resize]
                                                                                                                                                                  Script NameZoom_In_Out
                                                                                                                                                                  Run script with full access privilegesOff
                                                                                                                                                                  Include In MenuNo
                                                                                                                                                                  Layouts that use this script
                                                                                                                                                                  Scripts that use this script
                                                                                                                                                                    Script Definition
                                                                                                                                                                    Script Steps
                                                                                                                                                                    • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                                                    • # purpose:
                                                                                                                                                                    • # description:
                                                                                                                                                                    • # dependencies:
                                                                                                                                                                    • # used in Layout/Script:
                                                                                                                                                                    • # comments:
                                                                                                                                                                    • # Author: EfficientBizz GmbH - Benjamin Fehr
                                                                                                                                                                    • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                                                    • // Show Custom Dialog [ Title: "choose"; Default Button: “Hello”, Commit: “Yes”; Button 2: “Goodby”, Commit: “Yes” ]
                                                                                                                                                                    • // Set Variable [ $$Error; Value:0 ]
                                                                                                                                                                    • // Set Variable [ $$Error; Value:Get (LastError) ]
                                                                                                                                                                    • // Set Variable [ $$start; Value:Get (CurrentTimeUTCMilliseconds) ]
                                                                                                                                                                    • // Set Variable [ $$dauer; Value:Get (CurrentTimeUTCMilliseconds) - $$start ]
                                                                                                                                                                    • // Set Variable [ $PanelSum; Value:Get ( ScriptParameter ) ]
                                                                                                                                                                    • Set Variable [ $Zoom; Value:Get ( ScriptParameter ) ]
                                                                                                                                                                    • // Commit Records/Requests [ No dialog ]
                                                                                                                                                                    • // Freeze Window
                                                                                                                                                                    • // Show Custom Dialog [ Message: Get ( LastMessageChoice ); Default Button: “OK”, Commit: “Yes” ]
                                                                                                                                                                    • // Commit Records/Requests
                                                                                                                                                                    • If [ $Zoom = "In" ]
                                                                                                                                                                    • Set Zoom Level [ Zoom In ]
                                                                                                                                                                    • Commit Records/Requests [ No dialog ]
                                                                                                                                                                    • Else If [ $Zoom = "Out" ]
                                                                                                                                                                    • Set Zoom Level [ Zoom Out ]
                                                                                                                                                                    • Commit Records/Requests [ No dialog ]
                                                                                                                                                                    • End If
                                                                                                                                                                    • Set Field [ EZ_QR::Zoom; Get(WindowZoomLevel) & "%" //$$zoom ]
                                                                                                                                                                    • Commit Records/Requests [ No dialog ]
                                                                                                                                                                    • Adjust Window [ Resize to Fit ]
                                                                                                                                                                    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: [Zoom_In_Out]Next Script: [close_PC]
                                                                                                                                                                            Script NameResize
                                                                                                                                                                            Run script with full access privilegesOff
                                                                                                                                                                            Include In MenuYes
                                                                                                                                                                            Layouts that use this script
                                                                                                                                                                              Scripts that use this script
                                                                                                                                                                                Script Definition
                                                                                                                                                                                Script Steps
                                                                                                                                                                                • Adjust Window [ Resize to Fit ]
                                                                                                                                                                                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: [Resize]
                                                                                                                                                                                              Script Nameclose_PC
                                                                                                                                                                                              Run script with full access privilegesOff
                                                                                                                                                                                              Include In MenuNo
                                                                                                                                                                                              Layouts that use this script
                                                                                                                                                                                              Scripts that use this script
                                                                                                                                                                                                Script Definition
                                                                                                                                                                                                Script Steps
                                                                                                                                                                                                • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                                                                                • # purpose:
                                                                                                                                                                                                • # description:
                                                                                                                                                                                                • # dependencies:
                                                                                                                                                                                                • # used in Layout/Script:
                                                                                                                                                                                                • # comments:
                                                                                                                                                                                                • # Author: EfficientBizz GmbH - Benjamin Fehr
                                                                                                                                                                                                • # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
                                                                                                                                                                                                • // Show Custom Dialog [ Title: Get ( StatusAreaState ); Message: " | "& Get ( StatusAreaState ) & ¶ & Get ( WindowHeight ) & " x " & Get ( WindowVisible ); Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ]
                                                                                                                                                                                                • If [ Get ( StatusAreaState ) = 1 ]
                                                                                                                                                                                                • Show/Hide Toolbars [ Hide ]
                                                                                                                                                                                                • Adjust Window [ Resize to Fit ]
                                                                                                                                                                                                • Else
                                                                                                                                                                                                • // Close File [ Current File ]
                                                                                                                                                                                                • Exit Application
                                                                                                                                                                                                • 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

                                                                                                                                                                                                              Custom Functions

                                                                                                                                                                                                              Function NameParametersAvailabilityDefinitionIn Field DefinitionsIn Scripts
                                                                                                                                                                                                              SPC_QRR200_SZE_Name;ZE_Strasse;ZE_Hausnummer;ZE_PLZ;ZE_Ort;EZE_Name;EZE_Strasse;EZE_Hausnummer;EZE_PLZ;EZE_Ort;EZP_Name;EZP_Strasse;EZP_Hausnummer;EZP_PLZ;EZP_Ort;IBAN;Ref_Nummer;Betrag;zahlbar;CRAll accounts/* QR-Code Data Set für Swiss QR Code gem. ISO-18004 SPC - SwissPaymentCode QRR - QR Referenz (SCOR [ISO 11649], NON [ohne Referenz] nicht unterstützt) © Copyright 2017 - SIX Interbank Clearing AG, Version 1.0 vom 27.4.2017 MBS Text.ReplaceNewline = 3 für geforderter Zeilenumbruch CR UND LF (CarriageReturn UND LineFeed) Benjamin Fehr, EfficientBizz GmbH http://www.efficientbizz.com */ MBS( "Text.ReplaceNewline"; Let ( [ $CR = ¶ ; // Zahlungsempfänger - ZE $ZE = ZE_Name & $CR & ZE_Strasse & $CR & ZE_Hausnummer & $CR & ZE_PLZ & $CR & ZE_Ort & $CR & "CH" & $CR ; // Endgültiger Zahlungsempfänger - EZE $EZE = EZE_Name & $CR & EZE_Strasse & $CR & EZE_Hausnummer & $CR & EZE_PLZ & $CR & EZE_Ort & $CR & If ( not IsEmpty(EZE_Name);"CH" ) & $CR ; // Endgültiger Zahlungspflichtiger - EZP $EZP = EZP_Name & $CR & EZP_Strasse & $CR & EZP_Hausnummer & $CR & EZP_PLZ & $CR & EZP_Ort & $CR & If ( not IsEmpty(EZP_Name);"CH" ) & $CR ; // Betrag $Amount = Truncate ( Betrag;0 ) & "." & Right ( GetAsText((Betrag * 100)) ; 2 ) ; $paydate = ISO_Date ( zahlbar) ]; // QR Type "SPC" & $CR & // Version "0200" & $CR & // Coding "1" & $CR & // IBAN Substitute ( IBAN ; " " ; "" ) & $CR & // S - strukturiert, K - kombiniert "S" & $CR & // Biller $ZE & // $CR & // $EZE & for future use $CR & $CR & $CR & $CR & $CR & $CR & // $CR & // Betrag $Amount & $CR & "CHF" & $CR & $paydate & $CR & // Zahlungspflichtiger $EZP & // Referenztyp "QRR" & $CR & // 27-stellige Ref_N° Substitute ( Ref_Nummer ; " " ; "" ) & $CR & // $paydate "zahlbar bis: " & $paydate & $CR & // End-of-Payment "EPD" ) ; 3 )
                                                                                                                                                                                                              ISO_DateinputAll accounts//ISO_Date Let ( [ yyyy = Year ( input ) ; mm = Right ( "0" & Month ( input ) ; 2) ; dd = Right ( "0" & Day ( input ) ; 2); sep = "-" ] ; yyyy & sep & mm & sep & dd )
                                                                                                                                                                                                                SPC_QRR_ResumeZE_Name;ZE_Strasse;ZE_Hausnummer;ZE_PLZ;ZE_Ort;EZE_Name;EZE_Strasse;EZE_Hausnummer;EZE_PLZ;EZE_Ort;EZP_Name;EZP_Strasse;EZP_Hausnummer;EZP_PLZ;EZP_Ort;IBAN;Ref_Nummer;Betrag;zahlbar;LegSize;TxtSizeAll accounts/* Zahlteil QR_Rechnung ergänzend zu QRR - QR Referenz (SCOR [ISO 11649], NON [ohne Referenz] nicht unterstützt) © Copyright 2017 - SIX Interbank Clearing AG, Version 1.0 vom 27.4.2017 Benjamin Fehr, EfficientBizz GmbH http://www.efficientbizz.com */ Let ( [ // $CR = Char(10) ; // $CR = ¶ ; // $CR = "</BR>"; // Zahlungsempfänger - ZE $ZE = ZE_Name & ¶ & ZE_Strasse & " " & ZE_Hausnummer & ¶ & "CH-" & ZE_PLZ & " " & ZE_Ort ; // Endgültiger Zahlungsempfänger - EZE $EZE = EZE_Name & ¶ & EZE_Strasse & " " & EZE_Hausnummer & ¶ & "CH-" & EZE_PLZ & " " & EZE_Ort ; // Endgültiger Zahlungspflichtiger - EZP $EZP = EZP_Name & ¶ & EZP_Strasse & " " & EZP_Hausnummer & ¶& "CH-" & EZP_PLZ & " " & EZP_Ort ; // Betrag $Amount = Betrag ; $paydate = ISO_Date ( zahlbar) ]; // IBAN TextSize ("Konto / Zahlbar an" ; LegSize) & ¶ & TextSize ( Substitute ( IBAN ; " " ; "" ) ; TxtSize) & ¶ & // Biller // TextSize ( "Zahlungsempfänger" ; LegSize) & ¶ & TextSize ($ZE ; TxtSize) & ¶ & ¶ & // Infos TextSize ( "Zusätzliche Informationen" ; LegSize) & ¶ & TextSize ("Rechnung-Nr. " & GetAsNumber ( Middle ( Substitute ( Ref_Nummer ; " " ; "" ) ; 17 ; 9 ) ); TxtSize) & ¶ & ¶ & // Zahlungspflichtiger TextSize ( "Zahlbar durch" ; LegSize) & ¶ & TextSize ($EZP ; TxtSize) & ¶ ) & ¶ & /* If (not IsEmpty(EZE_Name); TextSize ( "Endgültiger Zahlungspflichtiger" ; LegSize) & ¶ & TextSize ($EZE ; TxtSize) & ¶ ) & ¶ & */ TextSize ( "Zahlbar bis" ; LegSize) & ¶ & TextSize (zahlbar ; TxtSize)
                                                                                                                                                                                                                Modulo10rekursivSeedNumberAll accounts// Name : Modulo10rekursiv // Creator : Daniel Wilhelm (wilhelm@datasol.ch , http://www.datasol.ch ) // Company : Datasol Wilhelm // Date : 15. Mai 2007 // Purpose : Used to return the checksum of a number // Parameters : SeedNumber - The number of witch you want to calculate the checksum // Uses : to calculate the checksums needed for the swiss ESR / BESR post payment order (Einzahlungsschein) // Info : It might not be the most elegant way, but it works. If you have any suggestions to make this simpler, please contact me Let([ $Startlength = Length ( SeedNumber ) ; $Restlength = Length ( $Rest) ] ;"")& If( $Startlength > $Restlength ; Let ([ $ZeileS = "0123456789" ; $Zeile0 = "094682713500" ; $Zeile1 = "946827135019" ; $Zeile2 = "468271350928" ; $Zeile3 = "682713509437" ; $Zeile4 = "827135094646" ; $Zeile5 = "271350946855" ; $Zeile6 = "713509468264" ; $Zeile7 = "135094682773" ; $Zeile8 = "350946827182" ; $Zeile9 = "509468271391" ; $rest = GetAsText(SeedNumber) ; $kb = "0" ; $P = "0"; $nächstezeile = Evaluate ( "$Zeile"&$kb ) ; $kb = Middle ( $nächstezeile ; Position ( $ZeileS ; Left ( $rest ; 1); 1; 1) ; 1) ; $P = Middle ( $nächstezeile; 12; 1) ; $nächstezeile = Case( Length ( $rest ) > 1 ;Evaluate ( "$Zeile"&$kb ) ; $nächstezeile ) ; $rest = Middle ( $rest ; 2; 1000) ; $nächstezeile = Evaluate ( "$Zeile"&$kb ) ]; Case( Length ( $rest ) > 0 ;Modulo10rekursiv ( $rest ) ; $P )) ; /*ELSE*/ Let ([ $kb = Middle ( $nächstezeile ; Position ( $ZeileS ; Left ( $rest ; 1); 1; 1) ; 1) ; $nächstezeile = Case( Length ( $rest ) > 0 ;Evaluate ( "$Zeile"&$kb ) ; $nächstezeile ) ; $P = Middle ( $nächstezeile; 12; 1) ; $rest = Middle ( $rest ; 2; 1000) ]; Case( Length ( $rest ) > 0 ;Modulo10rekursiv ( $rest ) ; $P )) )
                                                                                                                                                                                                                  SPC_QRR_EmpfangsscheinZE_Name;ZE_Strasse;ZE_Hausnummer;ZE_PLZ;ZE_Ort;EZE_Name;EZE_Strasse;EZE_Hausnummer;EZE_PLZ;EZE_Ort;EZP_Name;EZP_Strasse;EZP_Hausnummer;EZP_PLZ;EZP_Ort;IBAN;Ref_Nummer;Betrag;zahlbar;LegSize;TxtSizeAll accounts/* Zahlteil QR_Rechnung ergänzend zu QRR - QR Referenz (SCOR [ISO 11649], NON [ohne Referenz] nicht unterstützt) © Copyright 2017 - SIX Interbank Clearing AG, Version 1.0 vom 27.4.2017 Benjamin Fehr, EfficientBizz GmbH http://www.efficientbizz.com */ Let ( [ // $CR = Char(10) ; // $CR = ¶ ; // $CR = "</BR>"; // Zahlungsempfänger - ZE $ZE = ZE_Name & ¶ & ZE_Strasse & " " & ZE_Hausnummer & ¶ & "CH-" & ZE_PLZ & " " & ZE_Ort ; // Endgültiger Zahlungsempfänger - EZE $EZE = EZE_Name & ¶ & EZE_Strasse & " " & EZE_Hausnummer & ¶ & "CH-" & EZE_PLZ & " " & EZE_Ort ; // Endgültiger Zahlungspflichtiger - EZP $EZP = EZP_Name & ¶ & EZP_Strasse & " " & EZP_Hausnummer & ¶& "CH-" & EZP_PLZ & " " & EZP_Ort ; // Betrag $Amount = Betrag ; $paydate = ISO_Date ( zahlbar) ]; // IBAN TextSize ("Konto / Zahlbar an" ; LegSize) & ¶ & TextSize ( Substitute ( IBAN ; " " ; "" ) ; TxtSize) & ¶ & // Biller // TextSize ( "Zahlungsempfänger" ; LegSize) & ¶ & TextSize ($ZE ; TxtSize) & ¶ & ¶ & // Zahlungspflichtiger TextSize ( "Zahlbar durch" ; LegSize) & ¶ & TextSize ($EZP ; TxtSize) )
                                                                                                                                                                                                                  SPC_QRR200_KZE_Name;ZE_Strasse;ZE_PLZ;ZE_Ort;EZE_Name;EZE_Strasse;EZE_PLZ;EZE_Ort;EZP_Name;EZP_Strasse;EZP_PLZ;EZP_Ort;IBAN;Ref_Nummer;Betrag;zahlbar;CRAll accounts/* QR-Code Data Set für Swiss QR Code gem. ISO-18004 SPC - SwissPaymentCode QRR - QR Referenz (SCOR [ISO 11649], NON [ohne Referenz] nicht unterstützt) © Copyright 2017 - SIX Interbank Clearing AG, Version 1.0 vom 27.4.2017 MBS Text.ReplaceNewline = 3 für geforderter Zeilenumbruch CR UND LF (CarriageReturn UND LineFeed) Benjamin Fehr, EfficientBizz GmbH http://www.efficientbizz.com */ MBS( "Text.ReplaceNewline"; Let ( [ $CR = ¶ ; // Zahlungsempfänger - ZE $ZE = ZE_Name & $CR & ZE_Strasse & $CR & // ZE_Hausnummer & ZE_PLZ & " " & ZE_Ort & $CR & $CR & $CR & "CH" & $CR ; // Endgültiger Zahlungsempfänger - EZE $EZE = EZE_Name & $CR & EZE_Strasse & $CR & // EZE_Hausnummer & $CR & EZE_PLZ & " " & EZE_Ort & $CR & $CR & If ( not IsEmpty(EZE_Name);"CH" ) & $CR ; // Endgültiger Zahlungspflichtiger - EZP $EZP = EZP_Name & $CR & EZP_Strasse & $CR & // EZP_Hausnummer & EZP_PLZ & " " & EZP_Ort & $CR & $CR & $CR & If ( not IsEmpty(EZP_Name);"CH" ) & $CR ; // Betrag $Amount = Truncate ( Betrag;0 ) & "." & Right ( GetAsText((Betrag * 100)) ; 2 ) ; $paydate = GetAsDate (zahlbar) ]; // QR Type "SPC" & $CR & // Version "0200" & $CR & // Coding "1" & $CR & // IBAN Substitute ( IBAN ; " " ; "" ) & $CR & // S - strukturiert, K - kombiniert // Biller "K" & $CR & $ZE & // $CR & // $EZE & for future use $CR & $CR & $CR & $CR & $CR & $CR & $CR & // $CR & // Betrag $Amount & $CR & "CHF" & $CR & // & $paydate & $CR & // Zahlungspflichtiger "K" & $CR & $EZP & // Referenztyp "QRR" & $CR & // 27-stellige Ref_N° Substitute ( Ref_Nummer ; " " ; "" ) & $CR & // $paydate "zahlbar bis: " & $paydate & $CR & // End-of-Payment "EPD" ) ; 3 )

                                                                                                                                                                                                                  Custom Menu Sets

                                                                                                                                                                                                                  Menu SetsMenusIn ScriptsIn LayoutsComments
                                                                                                                                                                                                                  [Standard FileMaker Menus]
                                                                                                                                                                                                                  • All Standard Menus

                                                                                                                                                                                                                  Download example: ISO20022 QR v2.0

                                                                                                                                                                                                                  Used functions:




                                                                                                                                                                                                                  Links
                                                                                                                                                                                                                  MBS Xojo Plugins

                                                                                                                                                                                                                  Start Chat