# Airtable ### Airtable actions in CodeWords Here's a comprehensive list of all the actions you can perform with Airtable 1. create-single-record * **What it does**: Adds a single new record to a specified table. * **When to use it**: Use this when you need to add individual entries, like a new customer in your CRM. 2. create-multiple-records * **What it does**: Adds several new records at once. * **When to use it**: Perfect for bulk data imports, like uploading a batch of new leads from a trade show. 3. create-table * **What it does**: Sets up a new table within a base. * **When to use it**: Ideal for expanding your database with new categories of information, like adding a table for customer feedback. 4. create-field * **What it does**: Adds a new field (column) to a table. * **When to use it**: Use this when you need to track additional data points, such as a new sales metric. 5. create-comment * **What it does**: Adds a comment to a record. * **When to use it**: Great for leaving notes or updates on specific records, like a project status update. 6. update-record * **What it does**: Modifies an existing record with new data. * **When to use it**: Use this to update customer details or amend order statuses. 7. update-table * **What it does**: Changes settings at the table level. * **When to use it**: Useful for adjusting table configurations, like changing permissions. 8. update-field * **What it does**: Modifies a field in a table. * **When to use it**: Handy for renaming fields or changing field types. 9. update-comment * **What it does**: Edits an existing comment on a record. * **When to use it**: Ideal for revising notes or clarifying previous comments. 10. delete-record: * **What it does**: Removes a record from a table. * **When to use it**: Use this carefully to clean up obsolete data, like removing outdated contacts. 11. get-record * **What it does**: Retrieves a specific record based on a given ID. * **When to use it**: Perfect for fetching detailed information about a customer or order. 12. get-record-or-create * **What it does**: Retrieves a record or creates it if it doesn’t exist. * **When to use it**: Useful for ensuring data consistency, like checking for duplicate entries before adding new ones. 13. list-records * **What it does**: Lists all records in a table. * **When to use it**: Ideal for generating reports or exporting data. 14. list-records-in-view * **What it does**: Lists records from a specific view. * **When to use it**: Use this to filter data according to specific criteria, like a sales pipeline. 15. list-tables * **What it does**: Lists all tables within a base. * **When to use it**: Useful for getting an overview of your database structure. 16. list-bases * **What it does**: Lists all bases in your Airtable workspace. * **When to use it**: Perfect for navigating through multiple projects. 17. search-records * **What it does**: Finds records that match a search query. * **When to use it**: Ideal for locating specific data points, like finding all customers from a particular region. 18. create-or-update-record * **What it does**: Creates a new record or updates an existing one if it matches certain criteria. * **When to use it**: Great for maintaining up-to-date information, like syncing customer profiles. ### Available Triggers in CodeWords 1. new-records * **When it fires**: Triggers when new records are added. * **Business scenario**: Automatically send a welcome email to new customers. 2. new-records-in-view * **When it fires**: Triggers when new records appear in a specific view. * **Business scenario**: Notify the sales team when new leads enter the "Qualified" view. 3. new-or-modified-records * **When it fires**: Triggers when records are created or modified. * **Business scenario**: Update your team chat with changes to active projects. 4. new-or-modified-records-in-view * **When it fires**: Triggers on new or modified records in a view. * **Business scenario**: Alert managers to significant changes in high-priority projects. 5. new-or-modified-field * **When it fires**: Triggers when a field is added or changed. * **Business scenario**: Keep track of structural database changes for audit purposes. 6. new-field * **When it fires**: Triggers when a new field is created. * **Business scenario**: Notify stakeholders when new metrics are being tracked. 7. new-modified-or-deleted-records * **When it fires**: Triggers on any record addition, change, or deletion. * **Business scenario**: Maintain a comprehensive change log for compliance. 7. new-modified-or-deleted-records * **When it fires**: Instantly triggers on any record addition, change, or deletion. * **Business scenario**: Immediately update dashboards or reports with real-time data changes. ### Building practical workflows with CodeWords #### Example workflow 1: Automating lead management 1. **Trigger**: `new-records-in-view` — Fires when new leads enter the "Potential" view in Airtable. 2. **Action**: `create-single-record` — Adds these leads to your CRM database as individual records. 3. **Action**: `create-comment` — Leaves a note on each record indicating the source of the lead. 4. **Action**: `update-record` — Updates the lead status to "Contacted" once a follow-up email is sent. #### Example workflow 2: Real-time project tracking 1. **Trigger**: `new-modified-or-deleted-records-instant` — Instantly reacts to changes in project records. 2. **Action**: `list-records-in-view` — Retrieves all current tasks from the "In Progress" view. 3. **Action**: `create-or-update-record` — Updates a project management tool with the latest task status. ### Practical tips and what to watch out for * **Consistency is key**: Use `get-record-or-create` to avoid duplicates and maintain clean data. * **Plan your views**: Make use of specific views to filter data appropriately and trigger the right automations. * **Stay informed**: Use triggers like `new-modified-or-deleted-records` to keep everyone updated on important changes. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.codewords.ai/apps-and-integrations/popular-integrations/airtable.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.