Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.4   10.5   11.0   11.1   11.2   11.3   11.4   11.5   12.0   12.1    Statistic    FMM    Blog  


Creates a new JSON encoded number.

Component Version macOS Windows Linux Server iOS SDK
JSON 2.7 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "JSON.CreateNumber"; value )   More


Parameter Description Example
value The number value. 123.4


Returns JSON code.


Creates a new JSON encoded number.
Version 10.0 or newer preserve formatting if you pass a text with a number containing digits with optionally one dot and one minus.
Returns NULL if you pass empty text.


Creates a number:

MBS( "JSON.CreateNumber"; 123 )

Example result: 123

Create big number:

MBS( "JSON.CreateNumber"; 12063660878882855000013426248015578834577 )

Pass through vs. number parsing:

MBS( "JSON.CreateNumber"; "123.5" ) & ¶ & MBS( "JSON.CreateNumber"; 123,5 )
// in German with comma as separator second one is parsed as double precision value.

Example result:

See also

Release notes

Example Databases

Blog Entries

FileMaker Magazin

Created 18th August 2014, last changed 7th December 2021

JSON.CreateNull - JSON.CreateObject

Feedback: Report problem or ask question.

MBS Xojo tutorial videos

Start Chat