Tables

Interact with Tables to manage tables, fields, views, and more.

Triggers

Events from this node that can start a flow. Add one from Choose a trigger.

Base Created

When a base is created

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base the event refers to
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Base Updated

When a base is updated

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base the event refers to
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Base Deleted

When a base is deleted

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base the event refers to
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Table Created

When a table is created

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the table
tableId	Text	Unique identifier for the table the event refers to
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Table Updated

When a table is updated

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the table
tableId	Text	Unique identifier for the table the event refers to
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Table Deleted

When a table is deleted

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the table
tableId	Text	Unique identifier for the table the event refers to
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Field Created

When a field is created

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "fieldId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the field
fieldId	Text	Unique identifier for the field the event refers to
tableId	Text	Unique identifier for the table that owns the field
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Field Updated

When a field is updated

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "fieldId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the field
fieldId	Text	Unique identifier for the field the event refers to
tableId	Text	Unique identifier for the table that owns the field
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Field Deleted

When a field is deleted

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "fieldId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the field
fieldId	Text	Unique identifier for the field the event refers to
tableId	Text	Unique identifier for the table that owns the field
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Record Created

When a record is created

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "recordIds": [
    "string"
  ],
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the records
recordIds[]	List	Identifiers of the records the event refers to
tableId	Text	Unique identifier for the table that owns the records
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Record Updated

When a record is updated

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "recordId": "string",
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the record
recordId	Text	Unique identifier for the record the event refers to
tableId	Text	Unique identifier for the table that owns the record
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Record Deleted

When a record is deleted

Settings

No settings.

Output

Later steps use this data through Current Trigger in the $ picker. For example, baseId is $trigger.output.baseId.

{
  "baseId": "string",
  "recordIds": [
    "string"
  ],
  "tableId": "string",
  "timestamp": 0
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
baseId	Text	Unique identifier for the base that owns the records
recordIds[]	List	Identifiers of the records the event refers to
tableId	Text	Unique identifier for the table that owns the records
timestamp	Number	Unix timestamp in milliseconds when the event was processed

Actions

Steps this node can perform. Add one from Add a step, then pick the action.

List Bases

Get a list of all bases

Settings

Field	Type	Required	Description
Me	Yes / No		Whether to include only bases that the user has access to
Limit	Number	Yes	Maximum number of bases to return Default: 20
Page	Number	Yes	Page number Default: 1
Search	Text		Search query
Deleted	Yes / No		Whether to include deleted bases

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the base was created
data.deletedAt	Text	Timestamp when the base was deleted, null if not deleted
data.description	Text	Description of the base
data.id	Text	Unique identifier for the base
data.name	Text	Name of the base
data.options	Object	Options for the base
data.updatedAt	Text	Timestamp when the base was last updated

Get Base

Get a base by ID

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to retrieve

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the base was created
data.deletedAt	Text	Timestamp when the base was deleted, null if not deleted
data.description	Text	Description of the base
data.id	Text	Unique identifier for the base
data.name	Text	Name of the base
data.options	Object	Options for the base
data.updatedAt	Text	Timestamp when the base was last updated

Create Base

Create a new base

Settings

Field	Type	Required	Description
Name	Text	Yes	Name of the base
Description	Text		Description of the base

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the base was created
data.deletedAt	Text	Timestamp when the base was deleted, null if not deleted
data.description	Text	Description of the base
data.id	Text	Unique identifier for the base
data.name	Text	Name of the base
data.options	Object	Options for the base
data.updatedAt	Text	Timestamp when the base was last updated

Update Base

Update an existing base

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to update
Name	Text		Name of the base
Description	Text		Description of the base

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the base was created
data.deletedAt	Text	Timestamp when the base was deleted, null if not deleted
data.description	Text	Description of the base
data.id	Text	Unique identifier for the base
data.name	Text	Name of the base
data.options	Object	Options for the base
data.updatedAt	Text	Timestamp when the base was last updated

Delete Base

Delete a base

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to delete

Output

No documented output fields.

List Tables

Get a list of all tables in a base

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Limit	Number	Yes	Maximum number of tables to return Default: 20
Page	Number	Yes	Page number Default: 1
Deleted	Yes / No		Whether to include deleted tables

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.baseId	Text	ID of the base this table belongs to
data.createdAt	Text	Timestamp when the object was created
data.description	Text	Description of the object
data.fields[]	List	Object fields
data.fields[].id	Text	Field ID
data.fields[].name	Text	Field name
data.fields[].options	Object	Field options
data.fields[].system	Yes / No	Whether the field is a system field
data.fields[].type	Text	Field type
data.id	Text	Unique identifier for the table
data.name	Text	Name of the table
data.updatedAt	Text	Timestamp when the object was last updated

Get Table

Get a table by ID

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to retrieve

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.baseId	Text	ID of the base this table belongs to
data.createdAt	Text	Timestamp when the object was created
data.description	Text	Description of the object
data.fields[]	List	Object fields
data.fields[].id	Text	Field ID
data.fields[].name	Text	Field name
data.fields[].options	Object	Field options
data.fields[].system	Yes / No	Whether the field is a system field
data.fields[].type	Text	Field type
data.id	Text	Unique identifier for the table
data.name	Text	Name of the table
data.updatedAt	Text	Timestamp when the object was last updated

Create Table

Create a new table in a base

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to create the table in
Name	Text	Yes	Name of the table
Fields	List		Fields to create in the table
Description	Text		Description of the table

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.baseId	Text	ID of the base this table belongs to
data.createdAt	Text	Timestamp when the object was created
data.description	Text	Description of the object
data.fields[]	List	Object fields
data.fields[].id	Text	Field ID
data.fields[].name	Text	Field name
data.fields[].options	Object	Field options
data.fields[].system	Yes / No	Whether the field is a system field
data.fields[].type	Text	Field type
data.id	Text	Unique identifier for the table
data.name	Text	Name of the table
data.updatedAt	Text	Timestamp when the object was last updated

Update Table

Update an existing table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to update
Fields	List		Fields to create in the table
Name	Text		Name of the table
Description	Text		Description of the table

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.baseId	Text	ID of the base this table belongs to
data.createdAt	Text	Timestamp when the object was created
data.description	Text	Description of the object
data.fields[]	List	Object fields
data.fields[].id	Text	Field ID
data.fields[].name	Text	Field name
data.fields[].options	Object	Field options
data.fields[].system	Yes / No	Whether the field is a system field
data.fields[].type	Text	Field type
data.id	Text	Unique identifier for the table
data.name	Text	Name of the table
data.updatedAt	Text	Timestamp when the object was last updated

Delete Table

Delete a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to delete

Output

No documented output fields.

Get Field

Get a field by ID

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to retrieve
Field ID	Choice (loaded from your account)	Yes	ID of the field to retrieve

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the field was created
data.deletedAt	Text	Timestamp when the field was deleted
data.description	Text	Description of the field's purpose
data.id	Text	Unique identifier for the field
data.name	Text	Display name of the field
data.options	Object	Configuration options specific to the field type
data.system	Yes / No	Whether this is a system-generated field
data.type	Text	Type of the field (e.g., text, number, currency, etc.)
data.updatedAt	Text	Timestamp when the field was last updated

Create Field

Create a new field in a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to create the field in
Name	Text	Yes	Name of the field
Type	Choice	Yes	Type of the field
Options	Code		Options for the field

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the field was created
data.deletedAt	Text	Timestamp when the field was deleted
data.description	Text	Description of the field's purpose
data.id	Text	Unique identifier for the field
data.name	Text	Display name of the field
data.options	Object	Configuration options specific to the field type
data.system	Yes / No	Whether this is a system-generated field
data.type	Text	Type of the field (e.g., text, number, currency, etc.)
data.updatedAt	Text	Timestamp when the field was last updated

Update Field

Update an existing field in a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to update the field in
Field ID	Choice (loaded from your account)	Yes	ID of the field to update
Name	Text		Name of the field

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.createdAt	Text	Timestamp when the field was created
data.deletedAt	Text	Timestamp when the field was deleted
data.description	Text	Description of the field's purpose
data.id	Text	Unique identifier for the field
data.name	Text	Display name of the field
data.options	Object	Configuration options specific to the field type
data.system	Yes / No	Whether this is a system-generated field
data.type	Text	Type of the field (e.g., text, number, currency, etc.)
data.updatedAt	Text	Timestamp when the field was last updated

Delete Field

Delete a field from a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to delete the field from
Field ID	Choice (loaded from your account)	Yes	ID of the field to delete

Output

No documented output fields.

List Records

Get a list of all records in a table using MongoDB aggregation pipeline

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to list records from
Filter	Code		MongoDB filter: query selection criteria
Project	Object		MongoDB projection: field paths to include in each returned document
Sort	Object		MongoDB sort: field paths with 1 for ascending or -1 for descending
Distinct	List		MongoDB distinct: field paths for which unique values are returned
Limit	Number	Yes	Maximum number of records to return Default: 20
Page	Number	Yes	Page number Default: 1
View	Text		ID of the view to list records from

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.autoId	Number	Automatically generated sequential ID for the record
data.createdAt	Text	Timestamp when the record was created
data.createdBy	Object	User who created the record
data.createdBy.email	Text	Email of the user
data.createdBy.id	Text	Unique identifier for the user
data.createdBy.name	Text	Name of the user
data.createdBy.picture	Text	URL to the user's profile picture
data.id	Text	Unique identifier for the record
data.limitedAt	Text	Timestamp when the record was limited
data.updatedAt	Text	Timestamp when the record was last updated
data.updatedBy	Object	User who last updated the record
data.updatedBy.email	Text	Email of the user
data.updatedBy.id	Text	Unique identifier for the user
data.updatedBy.name	Text	Name of the user
data.updatedBy.picture	Text	URL to the user's profile picture

Get Record

Get a record by ID

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to list records from
Record ID	Text	Yes	ID of the record to retrieve

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.autoId	Number	Automatically generated sequential ID for the record
data.createdAt	Text	Timestamp when the record was created
data.createdBy	Object	User who created the record
data.createdBy.email	Text	Email of the user
data.createdBy.id	Text	Unique identifier for the user
data.createdBy.name	Text	Name of the user
data.createdBy.picture	Text	URL to the user's profile picture
data.id	Text	Unique identifier for the record
data.limitedAt	Text	Timestamp when the record was limited
data.updatedAt	Text	Timestamp when the record was last updated
data.updatedBy	Object	User who last updated the record
data.updatedBy.email	Text	Email of the user
data.updatedBy.id	Text	Unique identifier for the user
data.updatedBy.name	Text	Name of the user
data.updatedBy.picture	Text	URL to the user's profile picture

Create Record

Create a new record in a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to create the record in
Records	List		Record data with field values

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.autoId	Number	Automatically generated sequential ID for the record
data.createdAt	Text	Timestamp when the record was created
data.createdBy	Object	User who created the record
data.createdBy.email	Text	Email of the user
data.createdBy.id	Text	Unique identifier for the user
data.createdBy.name	Text	Name of the user
data.createdBy.picture	Text	URL to the user's profile picture
data.id	Text	Unique identifier for the record
data.limitedAt	Text	Timestamp when the record was limited
data.updatedAt	Text	Timestamp when the record was last updated
data.updatedBy	Object	User who last updated the record
data.updatedBy.email	Text	Email of the user
data.updatedBy.id	Text	Unique identifier for the user
data.updatedBy.name	Text	Name of the user
data.updatedBy.picture	Text	URL to the user's profile picture

Update Record

Update an existing record in a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to update the record in
Record ID	Text	Yes	ID of the record to update
Data to update	Key–value pairs	Yes	Record data with field values to update

Output

Later steps use this data by picking this step in the $ picker. For example, data is $.<step ID>.output.data.

{
  "data": "string"
}

Example values show the shape of the data, not real values. See Using data from earlier steps.

Field descriptions

Field	Type	Description
data	Any
data.autoId	Number	Automatically generated sequential ID for the record
data.createdAt	Text	Timestamp when the record was created
data.createdBy	Object	User who created the record
data.createdBy.email	Text	Email of the user
data.createdBy.id	Text	Unique identifier for the user
data.createdBy.name	Text	Name of the user
data.createdBy.picture	Text	URL to the user's profile picture
data.id	Text	Unique identifier for the record
data.limitedAt	Text	Timestamp when the record was limited
data.updatedAt	Text	Timestamp when the record was last updated
data.updatedBy	Object	User who last updated the record
data.updatedBy.email	Text	Email of the user
data.updatedBy.id	Text	Unique identifier for the user
data.updatedBy.name	Text	Name of the user
data.updatedBy.picture	Text	URL to the user's profile picture

Delete Record

Delete a record from a table

Settings

Field	Type	Required	Description
Base ID	Choice (loaded from your account)	Yes	ID of the base to list tables from
Table ID	Choice (loaded from your account)	Yes	ID of the table to delete the record from
Record ID	Text	Yes	ID of the record to delete

Output

No documented output fields.