Monkeybread Software - MBS FileMaker Plugin: Tapi

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

MBS FileMaker Plugin Example Databases

Tapi

All examples are included with download of MBS FileMaker Plugin.

Tapi.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	5
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
Tapi	3 fields defined, 0 record	Tapi

Fields

Table Name: Tapi - 3 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
ID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tapi		ShowCallInfo ShowAddresses
Key	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tapi		ShowCallInfo ShowAddresses
Value	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Tapi		ShowCallInfo ShowAddresses

Layout Objects: Tapi

Regular Fields

Field Name: Tapi::Key

Layout Name:

Tapi

Top: 66 pt
Left: 264 pt
Bottom: 83 pt
Right: 517 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: Tapi::Value

Layout Name:

Tapi

Top: 66 pt
Left: 522 pt
Bottom: 83 pt
Right: 775 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: Tapi::ID

Layout Name:

Tapi

Top: 66 pt
Left: 6 pt
Bottom: 83 pt
Right: 259 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: Initialize

Layout Name:

Tapi

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 6 pt
Left: 6 pt
Bottom: 31 pt
Right: 103 pt

Anchoring: Left, Top

Perform Script [ “Init” ]

Scripts:

Init

Button Properties

Coordinates

Script/Script Step

Type:

Text: Show Addresses

Layout Name:

Tapi

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 6 pt
Left: 108 pt
Bottom: 31 pt
Right: 217 pt

Anchoring: Left, Top

Perform Script [ “ShowAddresses” ]

Scripts:

ShowAddresses

Next Script: [NewCallScript]

Script Name	CallStateChanged
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	Set Variable [ $ID; Value:Get(ScriptParameter) ] #Log details Perform Script [ “ShowCallInfo”; Parameter: $ID ] #show dialog Set Variable [ $State; Value:MBS( "TAPI.CallInfo"; $ID; "State" ) ] Show Custom Dialog [ Title: "Call State Changed"; Message: "Call " & $ID & " changed state to " & $State; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
Fields used in this script
Scripts used in this script	ShowCallInfo
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: [CallStateChanged]

Next Script: [ShowCallInfo]

Script Name	NewCallScript
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	Set Variable [ $ID; Value:Get(ScriptParameter) ] #Log details Perform Script [ “ShowCallInfo”; Parameter: $ID ] #show dialog Set Variable [ $CallerIdNumber; Value:MBS( "TAPI.CallInfo"; $ID; "CallerIdNumber" ) ] Show Custom Dialog [ Title: "New Call"; Message: "Call " & $ID & " from " & $CallerIdNumber; Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
Fields used in this script
Scripts used in this script	ShowCallInfo
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: [NewCallScript]

Next Script: [Init]

Script Name	ShowCallInfo
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	CallStateChanged NewCallScript
Script Definition
Script Steps	Set Variable [ $ID; Value:Get(ScriptParameter) ] Set Variable [ $c; Value:"Call " & $ID ] #Log details #Caller Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLERIDNAME") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Caller ID Name" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLERIDNUMBER") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Caller ID Number" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Called Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLEDIDNAME") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Called ID Name" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLEDIDNUMBER") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Called ID Number" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Connected Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CONNECTEDIDNAME") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Connected ID Name" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CONNECTEDIDNUMBER") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Connected ID Number" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Redirection Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "REDIRECTIONIDNAME") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Redirection ID Name" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "REDIRECTIONIDNUMBER") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Redirection ID Number" ] Set Field [ Tapi::Value; $Value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Redirecting Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "REDIRECTINGIDNAME") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Redirecting ID Name" ] Set Field [ Tapi::Value; $Value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "REDIRECTINGIDNUMBER") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Redirecting ID Number" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Called Party Friendly Name Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLEDPARTYFRIENDLYNAME") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Called Party Friendly Name" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Comment Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "COMMENT") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Comment" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Displayable Address Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "DISPLAYABLEADDRESS") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Displayable Address" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Calling Party ID Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLINGPARTYID") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Calling Party ID" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #country code Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "COUNTRYCODE") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Country Code" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Call ID Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "CALLID") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Call ID" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #State Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "State") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "State" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Privilege Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "Privilege") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Privilege" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Origin Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "Origin") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Origin" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Reason Set Variable [ $value; Value:MBS("TAPI.CallInfo"; $ID; "Reason") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $c ] Set Field [ Tapi::Key; "Reason" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #show dialog Show Custom Dialog [ Title: "Call State Changed"; Message: Get ( ScriptParameter); Default Button: “OK”, Commit: “Yes”; Button 2: “Abbrechen”, Commit: “No” ]
Fields used in this script	Tapi::ID Tapi::Key Tapi::Value
Scripts used in this script
Layouts used in this script
Tables used in this script	Tapi
Table occurrences used by this script	Tapi
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [ShowCallInfo]

Next Script: [ShowAddresses]

Script Name	Init
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Tapi
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $r; Value:MBS("Trace") ] Set Variable [ $r; Value:MBS("TAPI.Initialize") ] Set Variable [ $r; Value:MBS("TAPI.ListenOnAllAddresses") ] Set Variable [ $r; Value:MBS("TAPI.SetNewCallScript"; Get(FileName); "NewCallScript") ] Set Variable [ $r; Value:MBS("TAPI.SetCallStateScript"; Get(FileName); "CallStateChanged") ]
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: [Init]

Script Name	ShowAddresses
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Tapi
Scripts that use this script
Script Definition
Script Steps	Delete All Records [ No dialog ] Set Variable [ $count; Value:MBS("TAPI.AddressCount") ] If [ $count > 0 ] Set Variable [ $index; Value:0 ] Loop Set Variable [ $address; Value:"Address " & ($index+1) & "/" & $count ] #Address Name Set Variable [ $value; Value:MBS("TAPI.AddressValue"; $index; "AddressName") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $address ] Set Field [ Tapi::Key; "AddressName" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Dialable Address Set Variable [ $value; Value:MBS("TAPI.AddressValue"; $index; "DialableAddress") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $address ] Set Field [ Tapi::Key; "DialableAddress" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #ServiceProviderName Set Variable [ $value; Value:MBS("TAPI.AddressValue"; $index; "ServiceProviderName") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $address ] Set Field [ Tapi::Key; "ServiceProviderName" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #State Set Variable [ $value; Value:MBS("TAPI.AddressValue"; $index; "State") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $address ] Set Field [ Tapi::Key; "State" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #DoNotDisturb Set Variable [ $value; Value:MBS("TAPI.AddressValue"; $index; "DoNotDisturb") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $address ] Set Field [ Tapi::Key; "DoNotDisturb" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #MessageWaiting Set Variable [ $value; Value:MBS("TAPI.AddressValue"; $index; "MessageWaiting") ] If [ MBS("IsError") = 0 ] New Record/Request Set Field [ Tapi::ID; $address ] Set Field [ Tapi::Key; "MessageWaiting" ] Set Field [ Tapi::Value; $value ] Commit Records/Requests [ Skip data entry validation; No dialog ] End If #Next Set Variable [ $index; Value:$index + 1 ] Exit Loop If [ $index = $count ] End Loop End If
Fields used in this script	Tapi::ID Tapi::Key Tapi::Value
Scripts used in this script
Layouts used in this script
Tables used in this script	Tapi
Table occurrences used by this script	Tapi
Custom Functions used by this script
Custom menu set used by this script

Download example: Tapi

Used functions: