Monkeybread Software - MBS FileMaker Plugin: System Font Info

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

MBS FileMaker Plugin Example Databases

System Font Info

All examples are included with download of MBS FileMaker Plugin.

System Font Info.fmp12

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

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
System Font Info	12 fields defined, 0 record	System Font Info

Fields

Table Name: System Font Info - 12 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
BaseType	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
FamilyName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
FilePath	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
FileSize	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
Embeddable	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
Editable	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
FullName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
PostScriptName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
Index	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
IsFixedPitch	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
Style	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		System Font Info		Run
JSON	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		System Font Info		Run Clear

Layout Objects: System Font Info

Regular Fields

Field Name: System Font Info::BaseType

Layout Name:

System Font Info

Top: 66 pt
Left: 103 pt
Bottom: 85 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::FamilyName

Layout Name:

System Font Info

Top: 89 pt
Left: 103 pt
Bottom: 108 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::FilePath

Layout Name:

System Font Info

Top: 112 pt
Left: 103 pt
Bottom: 131 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::FileSize

Layout Name:

System Font Info

Top: 135 pt
Left: 103 pt
Bottom: 154 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::Embeddable

Layout Name:

System Font Info

Top: 158 pt
Left: 103 pt
Bottom: 177 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::Editable

Layout Name:

System Font Info

Top: 181 pt
Left: 103 pt
Bottom: 200 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::FullName

Layout Name:

System Font Info

Top: 204 pt
Left: 103 pt
Bottom: 223 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::PostScriptName

Layout Name:

System Font Info

Top: 227 pt
Left: 103 pt
Bottom: 246 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::Index

Layout Name:

System Font Info

Top: 250 pt
Left: 103 pt
Bottom: 269 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::IsFixedPitch

Layout Name:

System Font Info

Top: 273 pt
Left: 103 pt
Bottom: 292 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::Style

Layout Name:

System Font Info

Top: 296 pt
Left: 103 pt
Bottom: 315 pt
Right: 548 pt

Anchoring: Left and Right, 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: System Font Info::JSON

Layout Name:

System Font Info

Top: 336 pt
Left: 103 pt
Bottom: 412 pt
Right: 548 pt

Anchoring: Left and Right, Top and Bottom

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

Type:

Text: Query System Font List

Layout Name:

System Font Info

Top: 9 pt
Left: 15 pt
Bottom: 44 pt
Right: 217 pt

Anchoring: Left, Top

Perform Script [ “Run” ]

Scripts:

Script Name	InitDynaPDF
Run script with full access privileges	Off
Include In Menu	No
Layouts that use this script
Scripts that use this script	Run
Script Definition
Script Steps	#Locate DynaPDF library #you can have libraries in container and export at runtime to folder of your choice. #Or install library somewhere and pass path. #If library is in same folder as plugin, you can only pass only file name. If [ MBS("IsServer") ] #Put the path you use for your server here: If [ Get(SystemPlatform) = -2 ] #Server on Windows Set Variable [ $path; Value:"C:\Programs\FileMaker Server\dynapdf.dll" ] Else If [ MBS("IsLinux") ] #Server on Linux for FileMaker Cloud Set Variable [ $path; Value:"/opt/FileMaker/FileMaker Server/dynapdf.linux.so" ] Else #Server on Mac Set Variable [ $path; Value: "/Library/FileMaker Server/dynapdf.dylib" ] End If Else #For desktop and our examples we look in same folder as database: Set Variable [ $databasePath; Value:Get(FilePath) ] Set Variable [ $databasePath; Value:MBS("Path.FilemakerPathToNativePath"; $databasePath) ] Set Variable [ $databasePath; Value:Substitute ( $databasePath ; ".fp7" ; ".fmp12") ] Set Variable [ $databaseName; Value:Get(FileName) & ".fmp12" ] If [ Get(SystemPlatform) = -2 ] Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dll" ) ] #plugin will look for dynapdf.dll and if not found also for dynapdf.dll (64-bit) and dynapdf32.dll (32-bit). Else Set Variable [ $path; Value:Substitute ( $databasePath ; $databaseName ; "dynapdf.dylib" ) ] #Mac dylib is usually 32 and 64 bit together. End If End If #You can test for free. #If you like to get a dynapdf license, please follow links on our pricing page: #https://www.monkeybreadsoftware.de/filemaker/pricing.shtml Set Variable [ $LicenseKey; Value:"" // put your key here or leave empty for demo. // Use e.g. "Lite", "Pro" or "Starter" to use demo mode for just that mode. ] Set Variable [ $r; Value:MBS( "DynaPDF.Initialize"; $path; $LicenseKey) ] If [ $r ≠ "OK" ] Show Custom Dialog [ Title: "Error"; Message: $r; Default Button: “OK”, Commit: “No”; Button 2: “Cancel”, Commit: “No” ] Halt Script 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: [InitDynaPDF]

Next Script: [Clear]

Script Name	Run
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	System Font Info
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("Trace"; "/tmp/trace.txt") ] #Initialize DynaPDF if needed If [ MBS("DynaPDF.IsInitialized") ≠ 1 ] Perform Script [ “InitDynaPDF” ] End If Delete All Records [ No dialog ] #new document Set Variable [ $pdf; Value:MBS("DynaPDF.New") ] #you can query all as JSON in one call Set Field [ System Font Info::JSON; MBS( "DynaPDF.SysFontInfoAsJSON"; $pdf ) ] #List fonts Set Variable [ $Handle; Value:0 ] Loop #Get values Set Variable [ $NextHandle; Value:MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "Result") ] Exit Loop If [ MBS("IsError") ] New Record/Request Set Field [ System Font Info::BaseType; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "BaseType") ] Set Field [ System Font Info::FamilyName; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "FamilyName") ] Set Field [ System Font Info::FilePath; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "FilePath") ] Set Field [ System Font Info::FileSize; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "FileSize") ] Set Field [ System Font Info::Embeddable; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "Embeddable") ] Set Field [ System Font Info::Editable; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "Editable") ] Set Field [ System Font Info::FullName; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "FullName") ] Set Field [ System Font Info::PostScriptName; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "PostScriptName") ] Set Field [ System Font Info::Index; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "Index") ] Set Field [ System Font Info::IsFixedPitch; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "IsFixedPitch") ] Set Field [ System Font Info::Style; MBS("DynaPDF.SysFontInfo"; $pdf; $Handle; "Style") ] Commit Records/Requests [ Skip data entry validation; No dialog ] Exit Loop If [ $NextHandle = 0 ] #Next Set Variable [ $Handle; Value:$NextHandle ] End Loop #Release memory Set Variable [ $r; Value:MBS("DynaPDF.Release"; $pdf) ] #Done
Fields used in this script	System Font Info::JSON System Font Info::BaseType System Font Info::FamilyName System Font Info::FilePath System Font Info::FileSize System Font Info::Embeddable System Font Info::Editable System Font Info::FullName System Font Info::PostScriptName System Font Info::Index System Font Info::IsFixedPitch System Font Info::Style
Scripts used in this script	InitDynaPDF
Layouts used in this script
Tables used in this script	System Font Info
Table occurrences used by this script	System Font Info
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Run]

Script Name	Clear
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	Delete All Records [ No dialog ] Set Field [ System Font Info::JSON; "" ]
Fields used in this script	System Font Info::JSON
Scripts used in this script
Layouts used in this script
Tables used in this script	System Font Info
Table occurrences used by this script	System Font Info
Custom Functions used by this script
Custom menu set used by this script

Download example: System Font Info

Used functions: