fm_count_records
Count records in a FileMaker table with an optional OData filter to validate data volume or filter expressions before running a full query.
Instructions
Get the total record count for an FileMaker table, optionally filtered.
Quick way to check data volume or validate filter expressions before running a full query.
Args: table: Table name (see fm_query_records for available tables). filter: Optional OData $filter expression to count matching records.
Returns: The record count as a text message.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| filter | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |