Monkeybread Software - MBS FileMaker Plugin: ISO20022 QR v2.3

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

ISO20022 QR v2.3

All examples are included with download of MBS FileMaker Plugin.

ISO20022 QR v2.3.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	5
Value Lists	1
Custom Functions	7
Custom Menus	24

File Options
Default custom menu set	[Standard FileMaker Menus]
Default theme	Apex Blue
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Show Sign-in fields	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Script: Resize
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
OnWindowTransaction	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

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

Fields

Table Name: EZ_QR - 27 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
IBAN	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
ZE_Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
ZE_Strasse	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
ZE_Hausnummer	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
ZE_PLZ	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
ZE_Ort	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZE_Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZE_Strasse	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZE_Hausnummer	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZE_PLZ	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZE_Ort	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZP_Name	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZP_Strasse	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZP_Hausnummer	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZP_PLZ	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
EZP_Ort	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
zahlbar	Normal, Date	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
Betrag	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
Ref_Nummer	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode
f_QR	Calculated, Text	Calculation: Context table: EZ_QR // CF SPC_QRR Substitute ( If ( EZ_QR::Type = "S" ; 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 ; ¶ ) ; 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 ; ¶ ) ) ; Char (10) ; "") Auto-Enter: Always evaluate Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200
f_QR_Resume	Calculated, Text	Calculation: Context table: EZ_QR // f_QR_Resume SPC_QRR_Resume ( 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 & "Z" ; EZ_QR::Betrag ; EZ_QR::zahlbar ; 8 ; 11 ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200
f_Empfangsschein	Calculated, Text	Calculation: Context table: EZ_QR SPC_QRR_Empfangsschein ( 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 ; 8 ; 11 ) Auto-Enter: Always evaluate Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200
QR_Code	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		EZ_QR_200		Make_QRCode
Dev_Notes	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		EZ_QR_200
Zoom	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German				Zoom_In_Out
empty	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200
Type	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		EZ_QR_200		Make_QRCode

Layout Objects: EZ_QR_200

Regular Fields

Field Name: EZ_QR::ZE_Hausnummer

Layout Name:

EZ_QR_200

Hide Condition:

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

Hide Condition:

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

Layout Name:

EZ_QR_200

Hide Condition:

EZ_QR::Type = "K"

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

Hide Condition:

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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

Hide Condition:

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

Layout Name:

EZ_QR_200

Hide Condition:

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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

Hide Condition:

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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

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

Layout Name:

EZ_QR_200

Hide Condition:

EZ_QR::Type = "K"

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 Formatting	Condition	Format
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

Layout Name:

EZ_QR_200

Hide Condition:

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

Layout Name:

EZ_QR_200

OnObjectValidate

Script: Make_QRCode
Modes: Browse

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

Layout Name:

EZ_QR_200

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

Layout Name:

EZ_QR_200

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

Field Name: EZ_QR::Dev_Notes

Layout Name:

EZ_QR_200

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

Field Name: EZ_QR::f_QR_Resume

Layout Name:

EZ_QR_200

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

Layout Name:

EZ_QR_200

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

Field Name: EZ_QR::Betrag

Layout Name:

EZ_QR_200

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

Layout Name:

EZ_QR_200

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

Layout Name:

EZ_QR_200

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

Text:

{{RecordNumber}} /

Layout Name:

EZ_QR_200

Top: 911 pt
Left: 203 pt
Bottom: 948 pt
Right: 427 pt

Anchoring: Left, Bottom

Type:

Layout Name:

EZ_QR_200

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 Properties

Coordinates

Layout Name:

EZ_QR_200

Orientation:

horizontal

Top: 915 pt
Left: 0 pt
Bottom: 945 pt
Right: 593 pt

Anchoring: Left, Bottom

Type:

Text:

Layout Name:

EZ_QR_200

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 Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

EZ_QR_200

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:

Make_QRCode

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

EZ_QR_200

Label Calculations:

"new Record"

Additional Properties:

Change to hand cursor over button

Top: 915 pt
Left: 356 pt
Bottom: 945 pt
Right: 474 pt

Type:

Text:

Layout Name:

EZ_QR_200

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 Properties

Coordinates

Layout Name:

EZ_QR_200

Hide Condition:

Orientation:

horizontal

Top: 950 pt
Left: 0 pt
Bottom: 965 pt
Right: 153 pt

Anchoring: Left, Top

Type:

Text:

Layout Name:

EZ_QR_200

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:

Zoom_In_Out

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

EZ_QR_200

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:

Zoom_In_Out

Button Properties

Coordinates

Script/Script Step

Type:

Text:

Layout Name:

EZ_QR_200

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:

close_PC

Button Bar Properties

Coordinates

Layout Name:

EZ_QR_200

Orientation:

horizontal

Top: 876 pt
Left: 161 pt
Bottom: 901 pt
Right: 186 pt

Anchoring: Left, Top

Button Bar Properties

Coordinates

Layout Name:

EZ_QR_200

Orientation:

horizontal

Top: 605 pt
Left: 552 pt
Bottom: 620 pt
Right: 582 pt

Anchoring: Left, Top

Tab Controls

Tab Control Properties				Coordinates
Layout Name: EZ_QR_200 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 Properties	Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts
Tab 0: "QR-Code"			Field Objects EZ_QR::ZE_Hausnummer at (153, 256, 174, 307) EZ_QR::EZE_Hausnummer at (248, 250, 269, 309) EZ_QR::EZP_Hausnummer at (343, 274, 364, 307) EZ_QR::ZE_Ort at (176, 151, 197, 308) EZ_QR::EZE_Ort at (271, 146, 292, 309) EZ_QR::EZP_Ort at (366, 146, 387, 309) EZ_QR::EZE_Name at (225, 101, 246, 309) EZ_QR::EZE_Strasse at (248, 101, 269, 275) EZ_QR::IBAN at (107, 100, 128, 308) EZ_QR::ZE_Name at (130, 100, 151, 308) EZ_QR::ZE_Strasse at (153, 100, 174, 274) EZ_QR::ZE_PLZ at (176, 100, 197, 151) EZ_QR::EZE_PLZ at (271, 100, 292, 146) EZ_QR::EZP_Name at (320, 100, 341, 308) EZ_QR::EZP_Strasse at (343, 100, 364, 272) EZ_QR::EZP_PLZ at (366, 100, 387, 146) EZ_QR::zahlbar at (413, 100, 434, 221) EZ_QR::Betrag at (436, 100, 457, 221) EZ_QR::Ref_Nummer at (459, 100, 480, 311) EZ_QR::empty at (481, 100, 502, 311) EZ_QR::ZE_Hausnummer at (153, 274, 174, 309) EZ_QR::EZE_Hausnummer at (248, 272, 269, 307) EZ_QR::Type at (86, 401, 102, 468) EZ_QR::f_QR at (122, 349, 433, 582)

Tab 1: "Output"			Field Objects EZ_QR::QR_Code at (82, 37, 607, 562)

Tab 2: "Notes"			Field Objects EZ_QR::Dev_Notes at (84, 11, 590, 586)

Graphic Objects

Graphic Object Properties

Coordinates

Type:

Rectangle

Layout Name:

EZ_QR_200

Hide Condition:

Top: 220 pt
Left: 10 pt
Bottom: 297 pt
Right: 324 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Text: EZE_Name

Layout Name:

EZ_QR_200

Hide Condition:

Top: 227 pt
Left: 37 pt
Bottom: 244 pt
Right: 92 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Text: EZE_Strasse

Layout Name:

EZ_QR_200

Hide Condition:

Top: 251 pt
Left: 16 pt
Bottom: 267 pt
Right: 92 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Text: EZE_PLZ_Ort

Layout Name:

EZ_QR_200

Hide Condition:

Top: 274 pt
Left: 13 pt
Bottom: 292 pt
Right: 92 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Text: Endgültiger Zahlungsempfänger - EZE (fakultativ)

Layout Name:

EZ_QR_200

Hide Condition:

Top: 205 pt
Left: 10 pt
Bottom: 220 pt
Right: 324 pt

Anchoring: Left, Top

Graphic Object Properties

Coordinates

Type:

Rectangle

Layout Name:

EZ_QR_200

Tooltip:

"Toggle Toolbars"

Top: 0 pt
Left: 0 pt
Bottom: 42 pt
Right: 180 pt

Anchoring: Left, Top

Value Lists

Value List Name	Source	Values	On Layouts
Type	Custom	K, S	EZ_QR_200

Script Hierarchy

Make_QRCode

showMenu_OR_FullAccess

Zoom_In_Out

Resize

close_PC

Next Script: [showMenu_OR_FullAccess]

Script Name	Make_QRCode
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
Layouts that use this script	EZ_QR_200
Scripts that use this script
Script Definition
Script Steps	# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # purpose: # description: # dependencies: # used in Layout/Script: # comments: # Author: EfficientBizz GmbH - Benjamin Fehr # Revision: 25.11.2025: Alexis Gehrt - QR Invoice Version 2.3 the Adresse Format "K" is no longer allowed for AdrTp. Only S - Structured adresses are allowed # Revision: 25.11.2025: Alexis Gehrt: Added Barcode_SetOptions 2 as the Swiss Post Reading / Payment Terminal strictly adhere to the QR Standard which requires Error correction "middle" # Revisioon: If your customer continues to store Street and House Number in the same field which ist more convinient anyway. You may use this custom Fuction to separate the Adresse Line into the street and number component # https://www.briandunning.com/cf/2713 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # // Beep Set Variable [ $image; Value:MBS( "Barcode.SetOptions" ; 2; 0; 0) ] If [ EZ_QR::Type = "S" ] Set Variable [ $o; Value:MBS("Barcode.SetOptions"; 2) // ECC Level with values from 1 = low, 2 = middle, 3 = better, 4 high. ] 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 [ ] Show Custom Dialog [ Title: "Note"; Message: "November 2025 QR Revision 2.3: The format \"K\" (freeform adddess) is not longer allowed in the Swiss QR Invoice."; Default Button: “OK”, Commit: “Yes” ] Set Variable [ $o; Value:MBS("Barcode.SetOptions"; 2) // ECC Level with values from 1 = low, 2 = middle, 3 = better, 4 high. ] 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	EZ_QR::Type 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 EZ_QR::QR_Code
Scripts used in this script
Layouts used in this script
Tables used in this script	EZ_QR
Table occurrences used by this script	EZ_QR
Custom Functions used by this script	SPC_QRR200_S SPC_QRR200_K
Custom menu set used by this script

Previous Script: [Make_QRCode]

Next Script: [Zoom_In_Out]

Script Name	showMenu_OR_FullAccess
Run script with full access privileges	On
Siri Shortcut Visible	Off
Include In Menu	No
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 Name	Zoom_In_Out
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	EZ_QR_200
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	EZ_QR::Zoom
Scripts used in this script
Layouts used in this script
Tables used in this script	EZ_QR
Table occurrences used by this script	EZ_QR
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Zoom_In_Out]

Next Script: [close_PC]

Script Name	Resize
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	Yes
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 Name	close_PC
Run script with full access privileges	Off
Siri Shortcut Visible	Off
Include In Menu	No
Layouts that use this script	EZ_QR_200
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 Name	Parameters	Availability	Definition	In Field Definitions	In Scripts
SPC_QRR200_S	ZE_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;CR	All 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 & "S" & $CR & // Zahlungspflichtiger $EZP & // Referenztyp "QRR" & $CR & // 27-stellige Ref_N° Substitute ( Ref_Nummer ; " " ; "" ) & $CR & // $paydate "zahlbar bis: " & $paydate & $CR & // End-of-Payment "EPD" ) ; 3 )	EZ_QR::f_QR	Make_QRCode
ISO_Date	input	All 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_Resume	ZE_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;TxtSize	All 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)	EZ_QR::f_QR_Resume
Modulo10rekursiv	SeedNumber	All 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_Empfangsschein	ZE_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;TxtSize	All 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) )	EZ_QR::f_Empfangsschein
SPC_QRR200_K	ZE_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;CR	All 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 )	EZ_QR::f_QR	Make_QRCode
SplitAddresslineHousenumber_cf	AddressLineWithNumber;ResultStreetNumberFormat	All accounts	// Custom Function: SplitAddresslineHousenumber_CF // Parameters: AddressLineWithNumber (text) // The address line with or without the house number. The house number may be at the end or the beginning or may be completely missing // ResultStreetNumberFormat // Pass one of the following parameters "Street", "Number", "Pipe" (\| Char), List (¶ Char) separated or "Debug" - if left empty, the original Input String is returned // Description: Separates the street from the house number in the given address // Author: Alexis Gehrt alexis@database-designs.ch // Notes: Well, if you find smarter options, you're welcome ;-) // Version: Dec 28, 2023 - First Release 1.0 // Version: Oct 22, 2025 - Improved Header Description // Sample Streets: Bahnhofstrasse 1 // Hans Musterstr. 14c // 1024, Oakwood Avenue // 20, Rue Des Corbieres // Sil Platz // Via Pianazzo, 5 Let ([ // Trick: RightWords removes all unwatend Characters such as Carriage Return // Usually the german street abbreviation is cleaned - however, double ss is a Swiss form of writing ~addressPreClened = Trim(RightWords( Substitute (AddressLineWithNumber ; "str." ; "strasse") ; 999)); // Find the position of a numeric first digit in the address Character 0123456789 ~ValidNummberDigits = "0123456789"; // There are adresses that do not have any numbers at all. ~HasNumberChars = If (not IsEmpty(Filter ( ~addressPreClened ; ~ValidNummberDigits )) ; 1 ; 0 ); ~firstNumberChar = If (~HasNumberChars = 1 ; Left(Filter ( ~addressPreClened ; ~ValidNummberDigits );1);""); ~firstNumberPosition = Position (~addressPreClened ; ~firstNumberChar ; 1 ; 1 ); // Determine the Position of any Space or Comma after the first digit. This will solve "25a, Rue de la Nation" in France // Note the SortValue by -2 (negative) will sort Numeric descending i.e. if there ist comma, space.. The last Position is used ~firstSpaceOrCommaAfterDigit = GetValue ( SortValues ( UniqueValues( Position (~addressPreClened ; " " ; ~firstNumberPosition ; 1 ) & "¶" & Position (~addressPreClened ; "," ; ~firstNumberPosition ; 1 ) ; 2 ) ; -2) ;1) ; // Find the first Position of any of the Characters in the Alphabet… // Might need to be Extended by more Umlaut Characters as you wish ~ValidAlphaDigits = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZöäüéàèëçÖÄÜÇ" ; ~HasAlphaChars = If (not IsEmpty(Filter ( ~addressPreClened ; ~ValidAlphaDigits )) ; 1 ; 0 ); ~firstAlphaChar = If (~HasAlphaChars = 1 ; Left(Filter ( ~addressPreClened ; ~ValidAlphaDigits );1);""); ~firstAlphaPosition = Position ( Upper(~addressPreClened) ; ~firstAlphaChar ; 1 ; 1 ) ; // Check if the first numeric digit is prior to any alpha digit ~isHouseNumberAtBeginning = (~firstNumberPosition > 0) and (~firstNumberPosition < ~firstAlphaPosition) ; // Extract the house number and street based on the position of the digits ~houseNumberAllCharacters = If (~HasNumberChars = 0 ; "" ; If (~isHouseNumberAtBeginning; Middle (~addressPreClened ; ~firstNumberPosition ; ~firstSpaceOrCommaAfterDigit - ~firstNumberPosition ); Middle (~addressPreClened; ~firstNumberPosition; 9999 )) ); // Trim it to eliminate any remaining garbage ~houseNumberCleaned = Trim( If ( Right(Trim(~houseNumberAllCharacters); 1) = ","; Left(Trim(~houseNumberAllCharacters); Length(Trim(~houseNumberAllCharacters))-1) ; ~houseNumberAllCharacters )) ; // The street is everything else, so just substitute the extracted housenumber (pre-garbage cleaned) ~street = Trim(Substitute (~addressPreClened ; ~houseNumberAllCharacters ; "" )); // More Clening Options ~streetCleaned = Case( Right ( ~street ; 1 ) = "," ; Left (~street; Length(~street) -1) ; ~street) ]; // End of Let Return the house number and street as a list Case( ResultStreetNumberFormat = "Street" ; ~streetCleaned ; ResultStreetNumberFormat = "Number" ; ~houseNumberCleaned; ResultStreetNumberFormat = "Pipe" ; ~streetCleaned & "\|" & ~houseNumberCleaned; ResultStreetNumberFormat = "List" ; ~streetCleaned & "¶" & ~houseNumberCleaned; ResultStreetNumberFormat = "Debug" ; TextColor ( ~streetCleaned ; RGB ( 40 ; 140 ; 40 ) ) & " " & TextColor ( ~houseNumberCleaned ; RGB ( 255 ; 0 ; 0 ) ) ; AddressLineWithNumber ) )

Custom Menu Sets

Menu Sets	Menus	In Scripts	In Layouts	Comments
[Standard FileMaker Menus]	All Standard Menus

Download example: ISO20022 QR v2.3

Used functions: