Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
MBS FileMaker Plugin Example Databases
MongoDB Test
All examples are included with download of MBS FileMaker Plugin.
Overview | |
Tables | 1 |
Relationships | 0 |
Layouts | 1 |
Scripts | 15 |
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 |
Table Name |
Statistics
| Occurrences in Relationship Graph |
test |
9 fields defined, 1 record
| test |
Table Name: test - 9 Fields | ||||||||
Field Name | Type | Options | Comments | On Layouts | In Relationships | In Scripts | In Value Lists | |
PrimaryKey | Normal, Text | Auto-Enter:
| Unique identifier of each record in this table |
|
|
|
|
|
CreationTimestamp | Normal, Timestamp | Auto-Enter:
| Date and time each record was created |
|
|
|
|
|
CreatedBy | Normal, Text | Auto-Enter:
| Account name of the user who created each record |
|
|
|
|
|
ModificationTimestamp | Normal, Timestamp | Auto-Enter:
| Date and time each record was last modified |
|
|
|
|
|
ModifiedBy | Normal, Text | Auto-Enter:
| Account name of the user who last modified each record |
|
|
|
|
|
MongoDB URL | Normal, Text | Auto-Enter:
|
|
|
||||
Database Name | Normal, Text | Auto-Enter:
|
|
|
||||
Collection Name | Normal, Text | Auto-Enter:
|
|
|
||||
Insert JSON | Normal, Text | Auto-Enter:
|
|
|
Layout Objects: test
Field Name: test::MongoDB URL | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: test::Database Name | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: test::Collection Name | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Field Name: test::Insert JSON | |||||
Field Properties | Coordinates | Field Format | Field Behavior | Quick Find | |
|
| Field Format:
| Field Behavior:
| Yes |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Query database names” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Query collection names” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Insert” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Find Collections” ] Scripts: |
Button Properties | Coordinates | Script/Script Step | ||||
|
| Perform Script [ “Find Databases” ] Scripts: |
Next Script: [Query database names] |
Script Name | Connect |
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 |
|
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: [Connect] | Next Script: [Query collection names] |
Script Name | Query database names |
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 |
|
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: [Query database names] | Next Script: [Find Collections] |
Script Name | Query collection names |
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 |
|
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: [Query collection names] | Next Script: [Find Databases] |
Script Name | Find Collections |
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 |
|
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: [Find Collections] | Next Script: [Find] |
Script Name | Find Databases |
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 |
|
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: [Find Databases] | Next Script: [Insert] |
Script Name | Find |
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 |
|
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: [Find] | Next Script: [Update one] |
Script Name | Insert |
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 |
|
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: [Insert] | Next Script: [Update many] |
Script Name | Update one |
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 |
|
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: [Update one] | Next Script: [Replace one] |
Script Name | Update many |
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 |
|
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: [Update many] | Next Script: [List Keys in Collection] |
Script Name | Replace one |
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 |
|
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: [Replace one] | Next Script: [Insert with transaction] |
Script Name | List Keys in Collection |
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 |
|
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: [List Keys in Collection] | Next Script: [List Local Sessions] |
Script Name | Insert with transaction |
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 |
|
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: [Insert with transaction] | Next Script: [Run Hello Command] |
Script Name | List Local Sessions |
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 |
|
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: [List Local Sessions] | Next Script: [On Window Transaction] |
Script Name | Run Hello Command |
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 |
|
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: [Run Hello Command] |
Script Name | On Window Transaction |
Run script with full access privileges | Off |
Include In Menu | No |
Layouts that use this script |
|
Scripts that use this script |
|
Script Definition | |
Script Steps |
|
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 |
|
Download example: MongoDB Test
Used functions:- JSON.Colorize
- MongoDB.AbortTransaction
- MongoDB.AggregateDatabase
- MongoDB.CollectionNames
- MongoDB.Command
- MongoDB.Connect
- MongoDB.CursorNext
- MongoDB.DatabasesNames
- MongoDB.EstimatedDocumentCount
- MongoDB.Find
- MongoDB.FindCollections
- MongoDB.FindDatabases
- MongoDB.InsertOne
- MongoDB.Keys
- MongoDB.New
- MongoDB.OpenCollection
- MongoDB.OpenDatabase
- MongoDB.Release
- MongoDB.ReplaceOne
- MongoDB.SetURI
- MongoDB.StartTransaction
- MongoDB.UpdateMany
- MongoDB.UpdateOne
