getFieldOptions
Discover distinct values for dropdown fields by analyzing existing records, returning usage counts to inform filtering and reveal data patterns.
Instructions
Discover possible values for select fields (dropdowns) by analyzing existing data. Use this to see what values are actually being used in a field before filtering or to understand data patterns. Returns unique values with counts. Note: Only shows values currently in use - empty options won't appear.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fieldName | Yes | Field to analyze (works best with select/dropdown fields like 'type', 'status', 'category') | |
| tableName | Yes | Table containing the field to analyze | |
| sampleSize | No | Records to sample for analysis (default: 100, max: 100). Larger samples give more complete results. |