airtable-filters
Use this skill when the user wants to find, filter, or narrow down Airtable records by field values, even when they don't explicitly say "filter."
- License 许可
- MIT
- 最近更新
- 2026-08-25
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- airtable-filters
- license
- MIT
- metadata
- { "author": "airtable", "version": "1.0.0" }
- description
- Use this skill when the user wants to find, filter, or narrow down Airtable records by field values, even when they don't explicitly say "filter."
02 资源文件 1
- 参考文档agents/openai.yaml247 B
03 SKILL.md 正文
Airtable MCP Filters
MCP tools that list or display records from tables or interface pages accept an optional filters parameter, using the same schema.
When querying records from an interface page, these filters are combined with the page's built-in filters using AND.
Schema shape
When no top-level operator is specified, conditions are combined with AND. The first element in a condition's operands array is always a field ID — look up the table's schema to find field IDs before filtering.
Field type categories
- Text-like: singleLineText, multilineText, email, url, phoneNumber, richText, barcode
- Numeric: number, percent, currency, rating, duration, autoNumber, count
- Date: date, dateTime, createdTime, lastModifiedTime
- Single select: singleSelect
- Multiple selects: multipleSelects
- Single collaborator: singleCollaborator
- Multiple collaborators: multipleCollaborators
- Linked records: multipleRecordLinks
- Attachment: multipleAttachments
- Checkbox: checkbox
Computed fields (formula, rollup, lookup) support whichever operators match their result type.
Comparison operators
| Operator | Second operand | Field categories |
|---|---|---|
= |
string, number, boolean, choice ID | text-like, numeric, date, checkbox, single select, multiple selects, single collaborator, multiple collaborators, linked records |
!= |
string, number, choice ID | text-like, numeric, date, single select, single collaborator |
<, >, <=, >= |
number or date value object | numeric, date |
contains |
string | text-like, linked records |
doesNotContain |
string | text-like, linked records |
doesNotContain |
array of IDs | multiple selects, multiple collaborators |
isEmpty, isNotEmpty |
(none) | text-like, numeric, date, single select, multiple selects, single collaborator, multiple collaborators, linked records, attachment |
hasAnyOf, hasAllOf |
array of IDs | multiple selects, multiple collaborators, linked records |
isAnyOf |
array of IDs | single select, single collaborator |
isNoneOf |
array of IDs | single select, single collaborator, linked records |
isWithin |
date range object | date |
filename, fileType |
string or "image"/"text" |
attachment |
When matching a field against multiple values, prefer dedicated operators (isAnyOf, isNoneOf, hasAnyOf, hasAllOf) over combining multiple = conditions with or/and, when those operators are available for the field type.
Field-type rules
Select fields
For select fields, operand values must be choice IDs (e.g., "selABCDEFGHIJKLM"), not display names. Look up the table's schema to find choice IDs before filtering.
Collaborator fields
When filtering by a collaborator group ID, use operatorOptions to match individual members of the group instead of the literal group ID. See the tool's operatorOptions parameter for details.
Example operand: {"operator": "hasAnyOf", "operands": ["fldCRi9oz2vRLcIWr", "ugpDUVUnftA7H9bG8"], "operatorOptions": {"matchGroupsByMembership": true}}
Attachment fields
Use fileType to filter attachments by type (e.g., "image", "text") rather than isNotEmpty when the user specifies a file type.
Date fields
Date comparisons (=, !=, <, >, <=, >=) use a date value object instead of a raw date string, and isWithin uses a date range object. The tool schema defines the available modes for each. Always include timeZone.
Composing conditions
A filter's top-level operands array can contain two or more conditions, which are combined with the top-level operator (AND by default). For simple multi-condition filters, this flat structure is sufficient.
When the logic requires mixing AND and OR, nest a filter object as one of the operands. Each nested filter has its own operator and operands.
OR inside AND — useful when one condition is fixed and another allows multiple alternatives:
"Scripted videos that are either in Writing or Pre-Production" → Bucket = Scripted AND (Status = Writing OR Status = Pre-Production)
AND inside OR — useful when you want records matching either a simple condition or a combination:
"Approved videos, or videos assigned to Bailey that are in Cut 2" → Status = Approved OR (Editor = Bailey AND Status = Cut 2 Ready)
When combining many conditions on different fields, prefer a flat AND rather than unnecessary nesting. Only nest when the logic genuinely requires mixed AND/OR at different levels.
Prefer composing all conditions into a single filters object rather than splitting them across multiple calls. A single call with a composed filter is more efficient and returns the correct result set directly.
Examples
Filter where a text field equals "orange" OR a number field is greater than 5:
{
"operator": "or",
"operands": [
{"operator": "=", "operands": ["fld8WsrpLHHevsnW8", "orange"]},
{"operator": ">", "operands": ["fldulcCPDVz87Bmnw", 5]}
]
}
Filter for records where a date field is within the past week:
{
"operands": [
{
"operator": "isWithin",
"operands": ["fldABC12345678x", {"mode": "pastWeek", "timeZone": "America/New_York"}]
}
]
}
04 同仓库更多 Skills
syllabus
Generates a curated supplementary reading list from any course syllabus using Consensus academic search. Grill-me intake (syllabus input format + course audience + year range) plus a grouping forcing-options checkpoint before any search runs — so the reading list matches the course's level and recency need. Parses the syllabus to extract topics and learning outcomes, searches Consensus for recent peer-reviewed papers per topic, and produces a professionally formatted .docx with clickable Consensus links, plain-language summaries calibrated to audience level, and Bloom-higher-order discussion questions tied to course learning goals. Use when the user uploads a syllabus, course outline, or curriculum document and wants supplementary readings (e.g., 'create a reading list from this syllabus', 'find recent papers for my course') — even casual mentions with a syllabus attached should trigger this skill.
pulse
Multi-source recency research skill that takes the pulse of any topic across Reddit, Hacker News, the open web, and optionally X/Twitter within a configurable recent window (default 30 days). Forcing intake clarifies topic specificity, angle (trend/sentiment/problems/opportunities/comparison), time window, and platform scope before searching. Returns a synthesized briefing with citations, engagement metrics, and cross-platform pattern analysis. Use when the user requests multi-source recency intelligence on a topic (e.g., 'pulse on [topic]', 'what's happening with [topic]', 'what are people saying about [topic]', 'current conversation about [topic]', 'take the pulse of [topic]', 'trending: [topic]', 'find me info on [topic]'), and for competitor research, trend discovery, tool comparisons, and audience sentiment analysis.
patent
Patent prior-art and landscape intelligence skill — not generic patent help. Commits to one of five sub-use-cases via forcing intake (novelty search / freedom-to-operate / competitive landscape / acquisition diligence / litigation prior-art) before any search runs. Searches Google Patents, Espacenet, USPTO, and optionally Lens.org for citation-graph signals. Output is an editable Word document (.docx) with verdict, ranked closest art (claim-text extracted), CPC-class-aware landscape, family-resolved hits, geographic coverage, FTO flags where applicable, strategy recommendations, and full audit log. Use when the user asks for patent searching or analysis (e.g., 'prior art search for [invention]', 'freedom to operate analysis for [product]'). Produces search signal, not legal advice — always recommends consulting a patent attorney before filing or licensing decisions. Trademark, copyright, and trade-secret questions are out of scope.
notebooklm
Browser automation skill for controlling Google's NotebookLM. Use when the user wants anything done in NotebookLM (e.g., 'open NotebookLM', 'check my [name] notebook', 'ask my notebook about X', 'add [source] to NotebookLM', 'generate a Video Overview from my notebook', 'use NotebookLM Studio'). Handles reading and querying notebooks, adding sources (URLs, text, files, YouTube links, synthesized content), generating Studio outputs (Audio/Video Overviews, Mind Maps, Reports incl. Briefing Doc/Study Guide/FAQ, Flashcards, Quiz, slide decks, infographics — discover the exact set from the live Studio panel; the UI evolves fast), and creating new notebooks. Requires browser automation environment — fails gracefully when unavailable.
litreview
Academic literature orientation skill that searches papers via free keyless APIs (PubMed E-utilities + OpenAlex) by default — with the Consensus MCP as an optional enhancement lane when connected — builds a strategic search plan using PICO (default) or SPIDER / Decomposition / hybrid as fallbacks, and synthesizes findings into a formatted Word (.docx) research guide. Grill-me intake (research question specificity + framework hint + tentative depth) before the recon search; a second forcing checkpoint after Phase 2 confirms framework + sub-areas + depth before searches consume budget. Configurable depth (5/10/20 queries) controls coverage vs. speed. Output is a 'launching pad' — an orientation guide that lets a researcher dive in confidently, not a finished review. Use when the user starts literature-oriented research (e.g., 'litreview on [topic]', 'literature review on [topic]', 'I'm starting a literature review on X', 'I'm writing a paper on X', 'help me research X', 'I'm doing research on X', 'can you help me research X'). Do NOT use for single one-off paper searches wanting a quick list — that's a plain PubMed/OpenAlex (or Consensus) query.
grants
NIH grant research skill for clinical researchers. Grill-me intake (research idea + career stage + preliminary data + environment + submission posture + known institute targets) locks down the funding strategy before any search runs. Runs a 5-facet Consensus positioning analysis (with draft Significance/Innovation language), maps the research to the right NIH institutes and study sections via RePORTER, finds NOSIs and funded overlap, and produces an editable Word document (.docx) with budget/scope-aware mechanism recommendations, submission timelines, and a mandatory program officer recommendation. Use when the user asks about research funding or makes any grant-related request (e.g., 'grants for [topic]', 'find grants for my research idea', 'what grants match my research', 'help me find NIH funding', 'grant opportunities for my research'). NIH-only scope — non-NIH funders (PCORI, DOD CDMRP, VA, foundations) are out of scope and flagged at intake.