Brian Dunning's FileMaker Custom Functions

getFunctionJson

A function that returns a Get function other than

  Be the first to rate this function Log in to vote

Teruhiro Komaki   Teruhiro Komaki - Show more from this author
frudens Inc.
https://frudens.jp

Share on Facebook Share on Twitter

  Sample input:
getFunctionJson ( )
  Sample output:
{
"Get(AccountExtendedPrivileges)": "fmapp\rfmreauthenticate10",
"Get(AccountGroupName)": "",
"Get(AccountName)": "Admin",
"Get(AccountPrivilegeSetName)": "[Full Access]",
"Get(AccountType)": "FileMaker File",
"Get(ActiveFieldContents)": "",
"Get(ActiveFieldName)": "",
"Get(ActiveFieldTableName)": "",
"Get(ActiveLayoutObjectName)": "",
"Get(ActiveModifierKeys)": "0",
"Get(ActivePortalRowNumber)": "0",
"Get(ActiveRecordNumber)": "2",
"Get(ActiveRepetitionNumber)": "0",
"Get(ActiveSelectionSize)": "",
"Get(ActiveSelectionStart)": "",
"Get(AllowAbortState)": "1",
"Get(AllowFormattingBarState)": "1",
"Get(ApplicationArchitecture)": "arm64",
"Get(ApplicationLanguage)": "Japanese",
"Get(ApplicationVersion)": "Pro 19.6.3",
"Get(CacheFileName)": "FMTEMPFM1420_172.tmp",
"Get(CacheFilePath)": "/Macintosh HD/var/folders/z9/vcnvrfcn4kn1gsvsq62p6hj00000gn/T/",
"Get(CalculationRepetitionNumber)": "1",
"Get(ConnectionAttributes)": "",
"Get(ConnectionState)": "0",
"Get(CurrentDate)": "2023/07/14",
"Get(CurrentExtendedPrivileges)": "fmapp\rfmreauthenticate10",
"Get(CurrentHostTimestamp)": "2023/07/14 14:02:14",
"Get(CurrentPrivilegeSetName)": "[Full Access]",
"Get(CurrentTime)": "14:02:14",
"Get(CurrentTimeUTCMicroseconds)": "63824907734548903",
"Get(CurrentTimeUTCMilliseconds)": "63824907734548",
"Get(CurrentTimestamp)": "2023/07/14 14:02:14",
"Get(CustomMenuSetName)": "",
"Get(DesktopPath)": "/Macintosh HD/Users/USERNAME/Desktop/",
"Get(Device)": "1",
"Get(DocumentsPath)": "/Macintosh HD/Users/USERNAME/Documents/",
"Get(EncryptionState)": "0",
"Get(ErrorCaptureState)": "0",
"Get(FileLocaleElements)": {
"APIVers": 1,
"Currency": {
"Leading": true,
"Symbol": "¥"
},
"Date": {
"DMQ": {
"1stDayOfWeek": 1,
"DaysOfWeek": {
"AbbrvList": [
"日",
"月",
"火",
"水",
"木",
"金",
"土"
],
"NameList": [
"日曜日",
"月曜日",
"火曜日",
"水曜日",
"木曜日",
"金曜日",
"土曜日"
]
},
"Months": {
"AbbrvList": [
"1月",
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月"
],
"NameList": [
"1月",
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月"
]
},
"Quarters": {
"AbbrvList": [
"Q1",
"Q2",
"Q3",
"Q4"
],
"NameList": [
"1st Quarter",
"2nd Quarter",
"3rd Quarter",
"4th Quarter"
]
}
},
"DateNums": {
"0d": true,
"0m": true,
"YYyy": false
},
"DateOrderID": 2,
"DateOrderName": "YMD",
"Sep": "/",
"YMD": {
"ElementArray": {
"NameList": [
"M#",
"D#",
"D$",
"YYYY#"
],
"SepList": [
"年",
"月",
"日 ",
""
]
},
"MustUseLocalesSep": false
}
},
"LocaleID": {
"IDNum": 31,
"IDStr": "Japanese",
"ISOLangCode": "ja",
"LID": "Japanese",
"Name": "日本語"
},
"Misc": {
"Active": false,
"Metric": true
},
"Num": {
"1000s": ",",
"Decimal": ".",
"Lead0": true
},
"Text": {
"SQuotLead": "“",
"SQuotTrail": "”",
"Sep": ","
},
"Time": {
"12h": false,
"HMS": {
"0h": false,
"24h": "",
"Seconds": false
},
"NightDay": {
"12hSuffix": true,
"amStr": " 午前",
"pmStr": " 午後"
},
"Sep": ":"
}
},
"Get(FileMakerPath)": "/Macintosh HD/Applications/",
"Get(FileName)": "function",
"Get(FilePath)": "file:/Macintosh HD/Users/USERNAME/Desktop/function.fmp12",
"Get(FileSize)": "14577664",
"Get(FoundCount)": "200",
"Get(HighContrastState)": "0",
"Get(HostApplicationVersion)": "",
"Get(HostIPAddress)": "",
"Get(HostName)": "MacBook Pro 14",
"Get(InstalledFMPlugins)": "360Works ScriptMaster;5.5;Disabled\rBaseElements;4.2.6;Enabled\rbBox;0.99.10;Disabled\rMBS Plug-In;13.1.0.07;Enabled",
"Get(InstalledFMPluginsAsJSON)": {
"APIVers": 2,
"environment": {
"architecture": "arm64",
"platform": 1,
"version": "12.6.6"
},
"plugins": [
{
"description": "Allows execution of interpreted java/groovy code. (5.5)",
"filepath": "filemac:/Macintosh HD/Users/teruhiro/Library/Application Support/FileMaker/Extensions/360Works_ScriptMaster.fmplugin/",
"id": "3BSH",
"name": "360Works ScriptMaster",
"state": "Disabled",
"version": "5.5"
},
{
"description": "Version: 4.2.6\n\nThis plug-in provides additional functionality for BaseElements from Goya.",
"filepath": "filemac:/Macintosh HD/Users/teruhiro/Library/Application Support/FileMaker/Extensions/BaseElements.fmplugin/",
"id": "GyBE",
"name": "BaseElements",
"state": "Enabled",
"version": "4.2.6"
},
{
"description": "For executing AppleScript, Python, XPath, and shell commands. From Beezwax Datatools, coding by Simon Brown. Version 0.99 Nov 2 2022",
"filepath": "filemac:/Macintosh HD/Users/teruhiro/Library/Application Support/FileMaker/Extensions/bBox.fmplugin/",
"id": "bBox",
"name": "bBox",
"state": "Disabled",
"version": "0.99.10"
},
{
"description": "The MBS Plugin extends Claris FileMaker with thousands of functions.\n\nVersion 13.1.0.07, build 6387 from Mar 6 2023.\n\nSee monkeybreadsoftware.com for more information.",
"filepath": "filemac:/Macintosh HD/Users/teruhiro/Library/Application Support/FileMaker/Extensions/MBS.fmplugin/",
"id": "MBSP",
"name": "MBS Plug-In",
"state": "Enabled",
"version": "13.1.0.07"
}
]
},
"Get(LastError)": "0",
"Get(LastErrorDetail)": "",
"Get(LastErrorLocation)": "",
"Get(LastMessageChoice)": "0",
"Get(LayoutAccess)": "2",
"Get(LayoutCount)": "7",
"Get(LayoutName)": "dummy",
"Get(LayoutNumber)": "7",
"Get(LayoutTableName)": "dummy",
"Get(LayoutViewState)": "0",
"Get(MenubarState)": "1",
"Get(ModifiedFields)": "",
"Get(MultiUserState)": "1",
"Get(NetworkProtocol)": "TCP/IP",
"Get(NetworkType)": "",
"Get(OpenDataFileInfo)": "",
"Get(PageCount)": "",
"Get(PageNumber)": "0",
"Get(PersistentID)": "AAAA1111BBBB2222",
"Get(PreferencesPath)": "/Macintosh HD/Users/USERNAME/Library/Preferences/",
"Get(PrinterName)": "EPSON EP-977A3 Series",
"Get(QuickFindText)": "",
"Get(RecordAccess)": "2",
"Get(RecordID)": "2",
"Get(RecordModificationCount)": "1",
"Get(RecordNumber)": "2",
"Get(RecordOpenCount)": "0",
"Get(RecordOpenState)": "0",
"Get(RegionMonitorEvents)": "",
"Get(RequestCount)": "0",
"Get(RequestOmitState)": "0",
"Get(ScreenDepth)": "32",
"Get(ScreenHeight)": "1890",
"Get(ScreenScaleFactor)": "2",
"Get(ScreenWidth)": "3360",
"Get(ScriptAnimationState)": "0",
"Get(ScriptName)": "",
"Get(ScriptParameter)": "",
"Get(ScriptResult)": "",
"Get(SessionIdentifier)": "",
"Get(SortState)": "0",
"Get(StatusAreaState)": "1",
"Get(SystemAppearance)": "Aqua",
"Get(SystemDrive)": "/Macintosh HD/",
"Get(SystemIPAddress)": "xxx.xxx.xx.xx",
"Get(SystemLanguage)": "Japanese",
"Get(SystemLocaleElements)": {
"APIVers": 1,
"Currency": {
"Leading": true,
"Symbol": "¥"
},
"Date": {
"DMQ": {
"1stDayOfWeek": 1,
"DaysOfWeek": {
"AbbrvList": [
"日",
"月",
"火",
"水",
"木",
"金",
"土"
],
"NameList": [
"日曜日",
"月曜日",
"火曜日",
"水曜日",
"木曜日",
"金曜日",
"土曜日"
]
},
"Months": {
"AbbrvList": [
"1月",
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月"
],
"NameList": [
"1月",
"2月",
"3月",
"4月",
"5月",
"6月",
"7月",
"8月",
"9月",
"10月",
"11月",
"12月"
]
},
"Quarters": {
"AbbrvList": [
"Q1",
"Q2",
"Q3",
"Q4"
],
"NameList": [
"1st Quarter",
"2nd Quarter",
"3rd Quarter",
"4th Quarter"
]
}
},
"DateNums": {
"0d": true,
"0m": true,
"YYyy": false
},
"DateOrderID": 2,
"DateOrderName": "YMD",
"Sep": "/",
"YMD": {
"ElementArray": {
"NameList": [
"M#",
"D#",
"D$",
"YYYY#"
],
"SepList": [
"年",
"月",
"日 ",
""
]
},
"MustUseLocalesSep": false
}
},
"LocaleID": {
"IDNum": 31,
"IDStr": "Japanese",
"ISOLangCode": "ja",
"LID": "Japanese",
"Name": "日本語"
},
"Misc": {
"Active": true,
"Metric": true
},
"Num": {
"1000s": ",",
"Decimal": ".",
"Lead0": true
},
"Text": {
"SQuotLead": "“",
"SQuotTrail": "”",
"Sep": ","
},
"Time": {
"12h": false,
"HMS": {
"0h": false,
"24h": "",
"Seconds": false
},
"NightDay": {
"12hSuffix": true,
"amStr": " 午前",
"pmStr": " 午後"
},
"Sep": ":"
}
},
"Get(SystemNICAddress)": "xx:xx:xx:xx:xx:xx",
"Get(SystemPlatform)": "1",
"Get(SystemVersion)": "12.6.6",
"Get(TemporaryPath)": "/Macintosh HD/var/folders/z9/vcnvrfcn4kn1gsvsq62p6hj00000gn/T/S11/",
"Get(TextRulerVisible)": "0",
"Get(TotalRecordCount)": "200",
"Get(TouchKeyboardState)": "0",
"Get(TransactionOpenState)": "0",
"Get(TriggerCurrentPanel)": "0\r",
"Get(TriggerExternalEvent)": "",
"Get(TriggerGestureInfo)": "",
"Get(TriggerKeystroke)": "",
"Get(TriggerModifierKeys)": "",
"Get(TriggerTargetPanel)": "0\r",
"Get(UUID)": "A36A8331-6CB7-4E81-A5AD-660F361612E8",
"Get(UUIDNumber)": "6201648709283681893653079105481314214721707393510570470818",
"Get(UseSystemFormatsState)": "1",
"Get(UserCount)": "1",
"Get(UserName)": "Teruhiro Komaki",
"Get(WindowContentHeight)": "768",
"Get(WindowContentWidth)": "1024",
"Get(WindowDesktopHeight)": "1865",
"Get(WindowDesktopWidth)": "3360",
"Get(WindowHeight)": "873",
"Get(WindowLeft)": "2064",
"Get(WindowMode)": "0",
"Get(WindowName)": "function",
"Get(WindowOrientation)": "-1",
"Get(WindowStyle)": "0",
"Get(WindowTop)": "170",
"Get(WindowVisible)": "1",
"Get(WindowWidth)": "1024",
"Get(WindowZoomLevel)": "100"
}

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

A function that returns a Get function other than "Get(DocumentsPathListing)" in JSON.
This function is used for debugging.
The type of JSON is JSONString for everything except objects.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: