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


Creates a new dictionary.

Component Version macOS Windows Linux Server iOS SDK
Dictionary 5.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Dictionary.Create" { ; Key; Value... } )   More


Parameter Description Example Flags
Key Optional, a key. Optional
Value... Optional, a value. Optional


Returns dictionary reference number or error.


Creates a new dictionary.
Dictionaries are hash maps, so lookup is very fast (often faster than search in your FileMaker database). You can use them for storing parameters or lookup tables.
Optionally you can pass keys and values as parameters to this function.

If you looked for associative arrays, you are right here.

Dictionaries can have multiple million of entries without problems. Just be aware of FileMaker's standard loop/recursion limit of 50000, which can be raised with SetRecursion function.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Value parameter as often as you need.


Build a dictionary in a calculation:

Let ( [
Create new Dictionary
    param = MBS( "Dictionary.Create" );

    Fill in parameters
    r1 = MBS( "Dictionary.SetValueForKey"; param; "text"; Pass Parameters with Dictionary::TextField );
    r2 = MBS( "Dictionary.SetValueForKey"; param; "number"; Pass Parameters with Dictionary::NumberField);
    r3 = MBS( "Dictionary.SetValueForKey"; param; "date"; Pass Parameters with Dictionary::DateField);
    r4 = MBS( "Dictionary.SetValueForKey"; param; "time"; Pass Parameters with Dictionary::TimeField);
    r5 = MBS( "Dictionary.SetValueForKey"; param; "timestamp"; Pass Parameters with Dictionary::TimeStampField);
    r6 = MBS( "Dictionary.SetValueForKey"; param; "container"; Pass Parameters with Dictionary::ContainerField)
    return dictionary
  ] ; param )

Build a dictionary with given Keys and Values:

MBS("Dictionary.Create"; "FirstName"; $FirstName; "LastName"; $LastName; "City"; $City; "Phone"; $Phone; "Email"; $Email)

Test script to look for duplicate UUIDs:

Set Variable [ $dic ; Value: MBS( "Dictionary.Create") ]
    Set Variable [ $uuid ; Value: Get(UUID) ]
    If [ MBS("Dictionary.HasKey"; $dic; $uuid) ]
        Show Custom Dialog [ "Duplicate!" ; $uuid ]
        Exit Loop If [ 1 ]
    End If
    Set Variable [ $r ; Value: MBS( "Dictionary.SetValueForKey"; $dic; $uuid; $uuid ) ]
End Loop
Set Field [ test::test ; MBS( "Dictionary.Keys"; $dic ) ]
Set Variable [ $r ; Value: MBS( "Dictionary.Release"; $dic ) ]

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 12nd December 2014, last changed 2nd November 2021

Dictionary.Count - Dictionary.CreateNamed