Back to APIs

Create, update or delete single or multiple records in your bases.

Using our official Airtable integration

  • Create any tasks possible with the Airtable API.

  • Use io.runTask() and the official SDK or fetch.

    • Example code using Airtable

    Below are some working code examples of how you can use Airtable with Trigger.dev. These samples are open source and maintained by the community, you can copy and paste them into your own projects.

    Update Airtable when a new subscription is added to Stripe.Add a new record to Airtable when a Typeform response is submitted.Update Airtable database when there is a sale in Stripe.
    import { TriggerClient } from "@trigger.dev/sdk";
    import { Airtable } from "@trigger.dev/airtable";
    import { Typeform } from "@trigger.dev/typeform";
    const typeform = new Typeform({
      id: "typeform",
      token: process.env.TYPEFORM_TOKEN!,
    });
    

    const airtable = new Airtable({
      id: "airtable",
      token: process.env.AIRTABLE_TOKEN!,
    });
    

    //this is the type definition for the table
    type Submission = {
      id: string;
      name: string;
      email: string;
      emailContactEnabled: boolean;
    };
    

    // This job populates an Airtable table when a new submission is created in Typeform
    client.defineJob({
      id: "typeform-new-submission-update-airtable",
      name: "On new Typeform submission update Airtable",
      version: "1.0.0",
      integrations: {
        typeform,
        airtable,
      },
      trigger: typeform.onFormResponse({
        // to get uid & tag instructions can be found here:
        // https://trigger.dev/docs/integrations/apis/typeform#get-notified-of-new-form-responses
        uid: "<your-form-id>",
        tag: "<your-tag>",
      }),
      run: async (payload, io, ctx) => {
        // You can get your base-id and table-name from airtable
        const table = io.airtable
          .base("<your-base-id>")
          .table<Submission>("<your-table-name>");
    

        if (payload.form_response.answers[0].type !== "text") {
          throw new Error("The first answer is not a name");
        }
        const name = payload.form_response.answers[0].text;
    

        if (payload.form_response.answers[1].type !== "email") {
          throw new Error("The second answer is not an email");
        }
        const email = payload.form_response.answers[1].email;
    

        if (payload.form_response.answers[2].type !== "choice") {
          throw new Error("The third answer is not a choice");
        }
        const emailContactEnabled =
          payload.form_response.answers[2].choice.label === "Yes";
    

        //create a new record
        const newRecords = await table.createRecords("create records", [
          {
            fields: {
              id: payload.event_id,
              name,
              email,
              emailContactEnabled,
            },
          },
        ]);
    

        await io.logger.info("A new form submission was created.", {
          payload,
          newRecords,
        });
      },
    });
    ,