Monkeybread Software - MBS FileMaker Plugin: EPC-QR-Code

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

MBS FileMaker Plugin Example Databases

EPC-QR-Code

All examples are included with download of MBS FileMaker Plugin.

EPC-QR-Code.fmp12

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

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

Tables

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

Fields

Table Name: Tabelle - 11 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
BIC	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
Version	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
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		Tabelle		Generate EPC
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		Tabelle		Generate EPC
Amount	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
Intention	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
Reference1	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
Reference2	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
Note	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC
Barcode	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		Tabelle		Generate EPC
Code	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tabelle		Generate EPC

Layout Objects: Tabelle

Regular Fields

Field Name: Tabelle::BIC

Layout Name:

Tabelle

Top: 52 pt
Left: 138 pt
Bottom: 73 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Version

Layout Name:

Tabelle

Top: 75 pt
Left: 138 pt
Bottom: 96 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Name

Layout Name:

Tabelle

Top: 98 pt
Left: 138 pt
Bottom: 119 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::IBAN

Layout Name:

Tabelle

Top: 121 pt
Left: 138 pt
Bottom: 142 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Amount

Layout Name:

Tabelle

Top: 144 pt
Left: 138 pt
Bottom: 165 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Intention

Layout Name:

Tabelle

Top: 167 pt
Left: 138 pt
Bottom: 188 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Reference1

Layout Name:

Tabelle

Top: 190 pt
Left: 138 pt
Bottom: 211 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Reference2

Layout Name:

Tabelle

Top: 213 pt
Left: 138 pt
Bottom: 234 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Note

Layout Name:

Tabelle

Top: 236 pt
Left: 138 pt
Bottom: 257 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Field Name: Tabelle::Barcode

Layout Name:

Tabelle

Top: 259 pt
Left: 138 pt
Bottom: 507 pt
Right: 455 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Field Name: Tabelle::Code

Layout Name:

Tabelle

Top: 260 pt
Left: 530 pt
Bottom: 507 pt
Right: 847 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: Default for Data Type
Go to next field using: Tab key

Yes

Script Hierarchy

Generate EPC

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

Download example: EPC-QR-Code

Used functions: