FM.FieldStatistics
------------------

Queries statistics on a field.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [FM](component_FM.md) | [14.4](newinversion144.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "FM.FieldStatistics"; FileName; TableName; FieldName ) 

**MBS**( **"FM.FieldStatistics";** /\* Queries statistics on a field. \*/  
**$FileName**; /\* The target database name.   
Can be empty to not limit query to one database.e.g. "" \*/   
**$TableName**; /\* The name of the table to check.e.g. "Contacts" \*/   
**$FieldName**) /\* The name of the field to find.e.g. "PrimaryKey" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| FileName | The target database name.    Can be empty to not limit query to one database. | "" |
| TableName | The name of the table to check. | "Contacts" |
| FieldName | The name of the field to find. | "PrimaryKey" |

### Result

Returns JSON or error.

### Description

Queries statistics on a field.  
Same as [FM.TableStatistics](FMTableStatistics.md), but only for one field you picked.  
### See also

- [FM.RecordStatistics](FMRecordStatistics.md)
- [FM.TableStatistics](FMTableStatistics.md)

### Release notes

- **Version 14.5**
    - Added CurrentTimeStamp field to the JSON for [FM.TableStatistics](https://www.mbsplugins.eu/FMTableStatistics.shtml), [FM.RecordStatistics](https://www.mbsplugins.eu/FMRecordStatistics.shtml) and [FM.FieldStatistics](https://www.mbsplugins.eu/FMFieldStatistics.shtml) functions.
- **Version 14.4**
    - Added FieldName entry for [FM.FieldStatistics](https://www.mbsplugins.eu/FMFieldStatistics.shtml) function result.
    - Added [FM.FieldStatistics](https://www.mbsplugins.eu/FMFieldStatistics.shtml) function.
    - Fixed a bug in [FM.FieldStatistics](https://www.mbsplugins.eu/FMFieldStatistics.shtml) function. Now properly quotes field names.

### Blog Entries

- [MBS FileMaker Plugin, version 14.5pr5](https://www.mbsplugins.de/archive/2024-10-28/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [New in MBS FileMaker Plugin 14.4](https://www.mbsplugins.de/archive/2024-09-24/New_in_MBS_FileMaker_Plugin_14/monkeybreadsoftware_blog_filemaker)
- [Neues MBS Plugin 14.4 für Claris FileMaker](https://www.mbsplugins.de/archive/2024-09-17/Neues_MBS_Plugin_144_für_Clar/monkeybreadsoftware_blog_filemaker)
- [MBS Plugin 14.4 for Claris FileMaker](https://www.mbsplugins.de/archive/2024-09-17/MBS_Plugin_144_for_Claris_File/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 14.4pr6](https://www.mbsplugins.de/archive/2024-09-11/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [Unlocking the Power of Database Analysis with MBS FileMaker Plugin Functions](https://www.mbsplugins.de/archive/2024-09-02/Unlocking_the_Power_of_Databas/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 14.4pr3](https://www.mbsplugins.de/archive/2024-08-21/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 14.4pr2](https://www.mbsplugins.de/archive/2024-08-01/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 29th July 2024 , last changed 29th July 2024

  
[FM.ExecuteSQLOnIdle](FMExecuteSQLOnIdle.md) - [FM.Get](FMGet.md)

[HTML Version](FMFieldStatistics.shtml)