Skill אוטומציות Airtable ל-Claude

מתי להשתמש

"Airtable", "Spreadsheet database", "Project tracker", "CRM ב-Airtable", "Automations".

הוראות עבודה

1. Airtable = Spreadsheet × Database

מתאים כשצריך structured data + workflows + UI — ללא code.

2. Building Blocks

• Base = database.
• Table = sheet.
• Field = column (typed: text, number, date, link, etc.).
• View = filter/sort of records.
• Record = row.
• Automation = trigger → actions.

3. Field Types — חשובים

• Linked Records — relationships (foreign keys).
• Lookup — pull data from linked record.
• Rollup — aggregate (SUM, COUNT) from linked.
• Formula — calculated field.
• Button — trigger action manually.
• Attachment — files.
• Single/Multi-select — dropdowns.

4. Automations — Triggers

• When record created.
• When record updated.
• When form submitted.
• At scheduled time.
• When webhook received.
• When checkbox checked.

5. Automations — Actions

• Create record.
• Update record.
• Find records.
• Send email (Gmail/Outlook).
• Send Slack/Teams message.
• HTTP request (any API).
• Run script (JavaScript).
• Trigger Zap/Make/etc.

6. Scripting (Powerful!)

// Get Linked Records counts
const table = base.getTable('Projects');
const records = await table.selectRecordsAsync();

let totalTasks = 0;
for (const project of records.records) {
  const tasks = project.getCellValue('Tasks') || [];
  totalTasks += tasks.length;
}

console.log(`Total tasks across projects: ${totalTasks}`);

7. Common Use Cases

A. Project Tracker

• Tables: Projects, Tasks, People, Time entries.
• Linked records.
• Status workflows.
• Slack alerts on overdue.

B. Lightweight CRM

• Tables: Contacts, Companies, Deals, Activities.
• Pipeline view (Kanban).
• Email integration.
• Reports.

C. Content Calendar

• Tables: Content, Channels, Authors.
• Calendar view.
• Status workflow.
• Social scheduling integrations.

D. Inventory Management

• Tables: Products, Inventory, Orders.
• Stock alerts.
• Reorder automations.

8. Interfaces — Internal Apps

• Build dashboards / forms / record galleries.
• Permission-controlled.
• Bridge between non-tech users + Airtable backend.

9. Sync Tables

• Pull data from external sources (CSV, Salesforce, Zendesk).
• Read-only typically.
• Auto-refresh.

10. Formulas — Common

• IF({Status} = 'Done', 'Complete', 'In Progress')
• DATEADD({Created}, 7, 'days')
• CONCATENATE({First}, ' ', {Last})
• SUM({Tasks Time})
• IF(NOW() > {Due Date}, '🔴 Overdue', '🟢 OK')

11. Pricing 2026

12. Airtable vs Notion

Use Airtable for data-heavy. Use Notion for docs-heavy.

13. Limitations

• Records cap by plan.
• Automation runs limited.
• Not a real database (no SQL).
• Limited custom UI (vs full app).

14. Israel Specifics

• Hebrew supports — RTL works in cells.
• Israeli SaaS — most have Airtable integrations or via Zapier.
• WhatsApp: via Zapier/Make → Airtable Automation.

15. אסיים בהמלצה.

קלט נדרש

פלט צפוי

דגלים אדומים

• 🚨 Treating Airtable as full DB — limitations bite.
• 🚨 No backups — manual export weekly minimum.
• ⚠️ 30+ tables in 1 base — performance suffers.

הערות חשובות

• Sync tables for live data.
• Interfaces = poor man's app builder.
• Backup regularly (export CSV/JSON).

פרומפט לדוגמה

Build CRM ב-Airtable. 5 users, 1K contacts.

Project tracker with Slack alerts on overdue tasks.

Airtable או Notion ל-content calendar?

© 2026 Automation Expert Pro | גרסה 1.0.0