Monkeybread Software - MBS FileMaker Plugin: Network Interfaces

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

MBS FileMaker Plugin Example Databases

Network Interfaces

All examples are included with download of MBS FileMaker Plugin.

Network Interfaces.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	1
Value Lists	0
Custom Functions	1
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
Network Interfaces	18 fields defined, 8 records	Network Interfaces

Fields

Table Name: Network Interfaces - 18 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
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		Network Interfaces		Update
IPv4	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
IPv6	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
MAC	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Destination	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Broadcast	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Netmask IPv4	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Netmask IPv6	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
InterfaceIndex	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Multicast	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
HasBroadcast	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
HasDestination	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Up	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
Loopback	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
IPv4s	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
IPv6s	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
IPv4 Count	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update
IPv6 Count	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Network Interfaces		Update

Layout Objects: Network Interfaces

Regular Fields

Field Name: Network Interfaces::Name

Layout Name:

Network Interfaces

Top: 48 pt
Left: 138 pt
Bottom: 62 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::IPv4

Layout Name:

Network Interfaces

Top: 66 pt
Left: 138 pt
Bottom: 80 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::IPv6

Layout Name:

Network Interfaces

Top: 84 pt
Left: 138 pt
Bottom: 98 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::MAC

Layout Name:

Network Interfaces

Top: 102 pt
Left: 138 pt
Bottom: 116 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Destination

Layout Name:

Network Interfaces

Top: 120 pt
Left: 138 pt
Bottom: 134 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Broadcast

Layout Name:

Network Interfaces

Top: 138 pt
Left: 138 pt
Bottom: 152 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Netmask IPv4

Layout Name:

Network Interfaces

Top: 156 pt
Left: 138 pt
Bottom: 170 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Netmask IPv6

Layout Name:

Network Interfaces

Top: 174 pt
Left: 138 pt
Bottom: 188 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::InterfaceIndex

Layout Name:

Network Interfaces

Top: 192 pt
Left: 138 pt
Bottom: 206 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Multicast

Layout Name:

Network Interfaces

Top: 48 pt
Left: 486 pt
Bottom: 62 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::HasBroadcast

Layout Name:

Network Interfaces

Top: 66 pt
Left: 486 pt
Bottom: 80 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::HasDestination

Layout Name:

Network Interfaces

Top: 84 pt
Left: 486 pt
Bottom: 98 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Up

Layout Name:

Network Interfaces

Top: 102 pt
Left: 486 pt
Bottom: 116 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::Loopback

Layout Name:

Network Interfaces

Top: 120 pt
Left: 486 pt
Bottom: 134 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::IPv4s

Layout Name:

Network Interfaces

Top: 138 pt
Left: 486 pt
Bottom: 152 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::IPv6s

Layout Name:

Network Interfaces

Top: 156 pt
Left: 486 pt
Bottom: 170 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::IPv4 Count

Layout Name:

Network Interfaces

Top: 174 pt
Left: 486 pt
Bottom: 188 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Yes

Field Name: Network Interfaces::IPv6 Count

Layout Name:

Network Interfaces

Top: 192 pt
Left: 486 pt
Bottom: 206 pt
Right: 739 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

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

Type:

Text: Update List

Layout Name:

Network Interfaces

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 6 pt
Left: 18 pt
Bottom: 31 pt
Right: 151 pt

Anchoring: Left, Top

Perform Script [ “Update” ]

Scripts:

Update

Script Hierarchy

Update

Script Name	Update
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Network Interfaces
Scripts that use this script
Script Definition
Script Steps	#Query interfaces and the number of interfaces we found Delete All Records [ No dialog ] Set Variable [ $r; Value:MBS("NetworkInterfaces.Update") ] Set Variable [ $c; Value:MBS("NetworkInterfaces.Count") ] #Now start loop Set Variable [ $i; Value:0 ] Loop New Record/Request Set Field [ Network Interfaces::Name; MBS("NetworkInterfaces.Value"; $i; "Name") ] Set Field [ Network Interfaces::IPv4; MBS("NetworkInterfaces.Value"; $i; "IPv4") ] Set Field [ Network Interfaces::IPv6; MBS("NetworkInterfaces.Value"; $i; "IPv6") ] Set Field [ Network Interfaces::MAC; MBS("NetworkInterfaces.Value"; $i; "MAC") ] Set Field [ Network Interfaces::Destination; MBS("NetworkInterfaces.Value"; $i; "Destination") ] Set Field [ Network Interfaces::Broadcast; MBS("NetworkInterfaces.Value"; $i; "Broadcast") ] Set Field [ Network Interfaces::Netmask IPv4; MBS("NetworkInterfaces.Value"; $i; "NetmaskIPv4") ] Set Field [ Network Interfaces::Netmask IPv6; MBS("NetworkInterfaces.Value"; $i; "NetmaskIPv6") ] Set Field [ Network Interfaces::InterfaceIndex; MBS("NetworkInterfaces.Value"; $i; "interfaceindex") ] Set Field [ Network Interfaces::Multicast; YesNo(MBS("NetworkInterfaces.Value"; $i; "Multicast")) ] Set Field [ Network Interfaces::HasBroadcast; YesNo(MBS("NetworkInterfaces.Value"; $i; "HasBroadcast")) ] Set Field [ Network Interfaces::HasDestination; YesNo(MBS("NetworkInterfaces.Value"; $i; "HasDestination")) ] Set Field [ Network Interfaces::Up; YesNo(MBS("NetworkInterfaces.Value"; $i; "Up")) ] Set Field [ Network Interfaces::Loopback; YesNo(MBS("NetworkInterfaces.Value"; $i; "Loopback")) ] Set Field [ Network Interfaces::IPv4s; MBS("NetworkInterfaces.Value"; $i; "IPv4s") ] Set Field [ Network Interfaces::IPv6s; MBS("NetworkInterfaces.Value"; $i; "IPv6s") ] Set Field [ Network Interfaces::IPv4 Count; MBS("NetworkInterfaces.Value"; $i; "IPv4Count") ] Set Field [ Network Interfaces::IPv6 Count; MBS("NetworkInterfaces.Value"; $i; "IPv6Count") ] Commit Records/Requests [ Skip data entry validation; No dialog ] #Next loop Set Variable [ $i; Value:$i + 1 ] Exit Loop If [ $i = $c ] End Loop
Fields used in this script	Network Interfaces::Name Network Interfaces::IPv4 Network Interfaces::IPv6 Network Interfaces::MAC Network Interfaces::Destination Network Interfaces::Broadcast Network Interfaces::Netmask IPv4 Network Interfaces::Netmask IPv6 Network Interfaces::InterfaceIndex Network Interfaces::Multicast Network Interfaces::HasBroadcast Network Interfaces::HasDestination Network Interfaces::Up Network Interfaces::Loopback Network Interfaces::IPv4s Network Interfaces::IPv6s Network Interfaces::IPv4 Count Network Interfaces::IPv6 Count
Scripts used in this script
Layouts used in this script
Tables used in this script	Network Interfaces
Table occurrences used by this script	Network Interfaces
Custom Functions used by this script	YesNo
Custom menu set used by this script

Custom Functions

Function Name	Parameters	Availability	Definition	In Field Definitions	In Scripts
YesNo	x	All accounts	If ( x ; "yes" ; "no" )		Update

Custom Menu Sets

Menu Sets	Menus	In Scripts	In Layouts	Comments
[Standard FileMaker Menus]	All Standard Menus
Custom Menu Set 1	FileMaker Pro Copy File Copy Edit Copy View Copy Insert Copy [Format] Requests Copy Records Copy [Scripts] [Window] Help Copy

Download example: Network Interfaces

Used functions: