airtable-formula

airtable-formula is a skill for Claude Code, Codex from Automations-Project/VSCode-Airtable-Formula. It costs 109 tokens per session (852 once invoked), scanned A, original, MIT.

A guide to writing, fixing, and improving Airtable formulas, including translating Excel formulas into Airtable syntax. Airtable is an online database and spreadsheet-like workspace whose formulas use field names rather than cell addresses.

In plain words
What is it for?
Use it for Airtable formulas, formula files, scripting and automations, and tasks involving bases, tables, fields, views, and linked records.
Why use it?
It helps avoid syntax mismatches and common formula errors when moving between Excel and Airtable or working with complex fields.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it for Airtable formulas, formula files, scripting and automations, and tasks involving bases, tables, fields, views, and linked records.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/automations-project/vscode-airtable-formula/airtable-formula
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add Automations-Project/VSCode-Airtable-Formula --skill airtable-formula
Clone the repo
git clone --depth 1 https://github.com/Automations-Project/VSCode-Airtable-Formula

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for airtable-formula

README.md
[![agentmods](https://agentmods.dev/badge/skills/automations-project/vscode-airtable-formula/airtable-formula/github.svg)](https://agentmods.dev/skills/automations-project/vscode-airtable-formula/airtable-formula)
Your own site
<a href="https://agentmods.dev/skills/automations-project/vscode-airtable-formula/airtable-formula"><img src="https://agentmods.dev/badge/skills/automations-project/vscode-airtable-formula/airtable-formula/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for airtable-formula

Your own site · 80×15
<a href="https://agentmods.dev/skills/automations-project/vscode-airtable-formula/airtable-formula"><img src="https://agentmods.dev/badge/skills/automations-project/vscode-airtable-formula/airtable-formula.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 109 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 852 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00109 $0.00852
Opus 5.5 $0.00044 $0.00341
Sonnet 5.5 $0.00022 $0.00170
Haiku 4.5 $0.00011 $0.00085

Measured 3d ago against content hash beb4f4f70176, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

airtable-formula scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 3d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

packages/extension/src/skills/airtable-formula/SKILL.md · 94 lines

How it starts

The opening of the file, as written. The whole thing — 94 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Airtable Formula Skill

Expert assistance for writing, debugging, and optimizing Airtable formulas.

This folder is installed and updated by the Airtable Formula VS Code extension; local edits are replaced on the next update.

When to Use

  • Writing new Airtable formulas
  • Debugging formula errors (#ERROR, NaN, Infinity)
  • Optimizing complex nested formulas
  • Converting Excel formulas to Airtable syntax
  • Working with .formula files

Key Differences from Excel

Excel Airtable
VLOOKUP Use linked records
SUMIF/COUNTIF Use rollup fields
IFERROR IF(ISERROR(...), ...)
NOW() / TODAY() Same, but callable constants
Cell references A1 Field references {Field Name}

Common Patterns

Safe Division

IF({Divisor} = 0, BLANK(), {Value} / {Divisor})

Null-Safe Field

IF({Field}, {Field}, "default")

JSON Object

"{" &
  "\"id\": \"" & RECORD_ID() & "\"," &
  "\"name\": \"" & SUBSTITUTE({Name}, "\"", "\\\"") & "\"" &
"}"

SWITCH vs Nested IF

// Instead of deeply nested IF:
SWITCH({Status}, "A", 1, "B", 2, "C", 3, 0)

Error Troubleshooting

Error Cause Fix
#ERROR Syntax/reference issue Check quotes, brackets, field names
NaN 0/0 or invalid date Add null checks
Infinity X/0 Check divisor ≠ 0
Smart quotes Curly quotes "" Use straight quotes ""

Function Categories

  1. Text: CONCATENATE, LEFT, RIGHT, MID, SUBSTITUTE, TRIM, UPPER, LOWER
  2. Numeric: SUM, AVERAGE, ROUND, MAX, MIN, COUNT, ABS, MOD
  3. Date/Time: TODAY, NOW, DATEADD, DATETIME_DIFF, DATETIME_FORMAT
  4. Logical: IF, SWITCH, AND, OR, NOT, ISERROR
  5. Array: ARRAYJOIN, ARRAYUNIQUE, ARRAYCOMPACT, ARRAYSLICE
  6. Regex: REGEX_MATCH, REGEX_EXTRACT, REGEX_REPLACE
  7. Record: RECORD_ID, CREATED_TIME, LAST_MODIFIED_TIME

References

Load these on demand:

Read the full file on GitHub · 94 lines

Files

What ships with it

4 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 3d ago Changed · +1 lines beb4f4f70176
  2. 4d ago First seen · 93 lines · 109 tokens per session scan A 6727fdc0d6f8

Subscribe to this mod's changes

airtable-formula is a skill published in the GitHub repository Automations-Project/VSCode-Airtable-Formula (32 stars, last pushed 3d ago), licensed MIT. It adds 109 tokens to every session and 852 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-11-07.

Related

airtable-formula compared with skills from other repositories

airtable-formula next to 6 skills from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
airtable-formulaAutomations-Project/VSCode-Airtable-FormulaSkill323d agoMITA109Claude Code, Codex
google-workspace-opshashgraph-online/awesome-codex-pluginsSkill1.6kyesterdayApache-2.0A59Claude Code, Codex
office-xlsxsingula-ai/alegoSkill110yesterdayMITA23Claude Code, Codex
document-skillstravisjneuman/.claudeSkill110yesterdayMITA44Claude Code
estimateDannykkh/skill-olympusSkill7todayMITA66Claude Code, Codex
excel2mdDannykkh/skill-olympusSkill7todayMITA63Claude Code, Codex
dev-documentchristopherlouet/claude-baseSkill5yesterdayMITA94Claude Code