Monkeybread Software - MBS FileMaker Plugin: FontWidth

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

MBS FileMaker Plugin Example Databases

FontWidth

All examples are included with download of MBS FileMaker Plugin.

FontWidth.fmp12

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

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
FontWidth	8 fields defined, 3 records	FontWidth

Fields

Table Name: FontWidth - 8 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
TextField	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		Recalc ALL CalcTextWidth Recalc Output A Recalc Output B
FieldLength	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		CalcTextWidth
TextRecalc A	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		Recalc Output A
TextRecalc B	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		Recalc Output B
FontName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		Recalc ALL
FontSize	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		Recalc ALL CalcTextWidth Recalc Output A Recalc Output B
FontStyle	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		FontWidth		Recalc ALL
FontNameWithStyle	Calculated, Text	Calculation: Context table: FontWidth If(IsEmpty(FontWidth::FontStyle); FontWidth::FontName; FontWidth::FontName & " " & FontWidth::FontStyle) Auto-Enter: Always evaluate Storage: Repetitions: 1 Do not store calculation results Index Language: German		FontWidth		CalcTextWidth Recalc Output A Recalc Output B

Layout Objects: FontWidth

Regular Fields

Field Name: FontWidth::TextField

Layout Name:

FontWidth

OnObjectModify

Script: CalcTextWidth
Modes: Browse

Top: 287 pt
Left: 266 pt
Bottom: 312 pt
Right: 516 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: FontWidth::FieldLength

Layout Name:

FontWidth

Top: 397 pt
Left: 266 pt
Bottom: 418 pt
Right: 373 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: FontWidth::TextRecalc A

Layout Name:

FontWidth

Top: 538 pt
Left: 266 pt
Bottom: 561 pt
Right: 366 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: FontWidth::FontName

Layout Name:

FontWidth

Top: 95 pt
Left: 266 pt
Bottom: 116 pt
Right: 519 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: FontName
Include "Edit..." item to allow editing of value list
Auto-complete using value list
Include arrow to show and hide list

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: FontWidth::FontSize

Layout Name:

FontWidth

Top: 118 pt
Left: 266 pt
Bottom: 139 pt
Right: 345 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: Size
Include "Edit..." item to allow editing of value list
Include arrow to show and hide list

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: FontWidth::FontStyle

Layout Name:

FontWidth

Top: 141 pt
Left: 266 pt
Bottom: 162 pt
Right: 519 pt

Anchoring: Left, Top

Field Format:

Drop-down List
Display values from: Style
Include "Edit..." item to allow editing of value list
Auto-complete using value list
Include arrow to show and hide list

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: FontWidth::TextField

Layout Name:

FontWidth

OnObjectModify

Script: CalcTextWidth
Modes: Browse

Top: 324 pt
Left: 266 pt
Bottom: 346 pt
Right: 366 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: FontWidth::FontNameWithStyle

Layout Name:

FontWidth

Top: 168 pt
Left: 266 pt
Bottom: 189 pt
Right: 519 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: FontWidth::TextField

Layout Name:

FontWidth

OnObjectModify

Script: CalcTextWidth
Modes: Browse

Top: 251 pt
Left: 266 pt
Bottom: 275 pt
Right: 766 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: FontWidth::TextRecalc B

Layout Name:

FontWidth

Top: 565 pt
Left: 266 pt
Bottom: 588 pt
Right: 366 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: FontWidth::TextField

Layout Name:

FontWidth

OnObjectModify

Script: CalcTextWidth
Modes: Browse

Top: 509 pt
Left: 266 pt
Bottom: 532 pt
Right: 366 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.	Formula: FontWidth::FieldLength + 5 + 5 >100	self:normal .self { background-color: rgba(0%,72.9412%,98.4314%,1); } self:normal .icon { -fm-icon-color: rgba(0%,0%,0%,0); }

Type:

Text: recalc

Layout Name:

FontWidth

Top: 109 pt
Left: 26 pt
Bottom: 141 pt
Right: 133 pt

Anchoring: Left, Top

Perform Script [ “Recalc ALL” ]

Scripts:

Recalc ALL

Button Properties

Coordinates

Script/Script Step

Type:

Text: recalc

Layout Name:

FontWidth

Top: 258 pt
Left: 26 pt
Bottom: 290 pt
Right: 133 pt

Anchoring: Left, Top

Perform Script [ “Recalc ALL” ]

Scripts:

Recalc ALL

Popover Buttons

Popover Button Properties		Coordinates
Type: Text: Info Layout Name: FontWidth		Top: 90 pt Left: 838 pt Bottom: 122 pt Right: 929 pt Anchoring: Left, Top
Popover Properties		Coordinates
Show Title Bar: Yes Title: "Info" Position: Left		Top: 5 pt Left: 209 pt Bottom: 359 pt Right: 827 pt Anchoring: Left, Top
Popover Content
Tab Controls	Slide Controls	Fields	Buttons	Portals	Web Viewer Controls	Charts

Value Lists

Value List Name	Source	Values	On Layouts
Size	Custom	8, 9, 10, 11, 12, 13, 14, 16, 18, 20, 24	FontWidth
Style	Custom	, bold, italic, underline	FontWidth
FontName	Custom	Arial, Times, Verdana	FontWidth

Next Script: [CalcTextWidth]

Script Name	Recalc ALL
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	FontWidth
Scripts that use this script
Script Definition
Script Steps	Set Field [ FontWidth::TextField; TextFont ( FontWidth::TextField ; FontWidth::FontName ) ] Set Field [ FontWidth::TextField; TextSize ( FontWidth::TextField ; FontWidth::FontSize ) ] Set Field [ FontWidth::TextField; TextStyleAdd ( FontWidth::TextField ; Evaluate(FontWidth::FontStyle) ) ] Perform Script [ “CalcTextWidth” ] Perform Script [ “Recalc Output A” ] Perform Script [ “Recalc Output B” ]
Fields used in this script	FontWidth::TextField FontWidth::FontName FontWidth::FontSize FontWidth::FontStyle
Scripts used in this script	CalcTextWidth Recalc Output A Recalc Output B
Layouts used in this script
Tables used in this script	FontWidth
Table occurrences used by this script	FontWidth
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Recalc ALL]

Next Script: [Recalc Output A]

Script Name	CalcTextWidth
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Recalc ALL
Script Definition
Script Steps	Set Variable [ $FieldLength; Value:MBS( "Font.CalculateTextWidth"; FontWidth::TextField; FontWidth::FontNameWithStyle; FontWidth::FontSize ) ] Set Field [ FontWidth::FieldLength; $FieldLength ]
Fields used in this script	FontWidth::TextField FontWidth::FontNameWithStyle FontWidth::FontSize FontWidth::FieldLength
Scripts used in this script
Layouts used in this script
Tables used in this script	FontWidth
Table occurrences used by this script	FontWidth
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [CalcTextWidth]

Next Script: [Recalc Output B]

Script Name	Recalc Output A
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Recalc ALL
Script Definition
Script Steps	Set Field [ FontWidth::TextRecalc A; FontWidth::TextField ] Loop Exit Loop If [ MBS( "Font.CalculateTextWidth"; FontWidth::TextRecalc A; FontWidth::FontNameWithStyle; FontWidth::FontSize ) + 5 + 5 <= 100 ] Set Variable [ $len; Value:Length ( FontWidth::TextRecalc A ) ] Set Field [ FontWidth::TextRecalc A; Left(FontWidth::TextRecalc A; Int($len / 2)-3) & " .. " & Right(FontWidth::TextRecalc A; Int($len / 2)-3) ] End Loop
Fields used in this script	FontWidth::TextField FontWidth::TextRecalc A FontWidth::FontNameWithStyle FontWidth::FontSize
Scripts used in this script
Layouts used in this script
Tables used in this script	FontWidth
Table occurrences used by this script	FontWidth
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Recalc Output A]

Script Name	Recalc Output B
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Recalc ALL
Script Definition
Script Steps	Set Field [ FontWidth::TextRecalc B; FontWidth::TextField ] Loop Exit Loop If [ MBS( "Font.CalculateTextWidth"; FontWidth::TextRecalc B; FontWidth::FontNameWithStyle; FontWidth::FontSize ) + 5 + 5 <= 100 ] Set Variable [ $len; Value:Length ( FontWidth::TextRecalc B ) ] Set Field [ FontWidth::TextRecalc B; Left(FontWidth::TextRecalc B ; $len -3) & " ~" ] End Loop
Fields used in this script	FontWidth::TextField FontWidth::TextRecalc B FontWidth::FontNameWithStyle FontWidth::FontSize
Scripts used in this script
Layouts used in this script
Tables used in this script	FontWidth
Table occurrences used by this script	FontWidth
Custom Functions used by this script
Custom menu set used by this script

Download example: FontWidth

Used functions:

Font.CalculateTextWidth