The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:
title: Basic actions redirect_from: - /docs/latest/actions/basic
Basic actions
Basic actions are "implicit" actions that do things that people typically want to do when interacting with a database: Create, Update, Delete. Basic actions auto-track the schema of the source table backing the model. By auto-tracking the schema, we mean that Metabase will create action forms for people to fill out that include all of the fields from the primary source table that underlies that model.
If you only want to give people the option to update a subset of columns, or update columns in multiple tables, you can write a custom action.
To add, update, or delete one row without a model, create a data action from a table.
Creating basic actions
Only admins can create basic actions. Once an admin turns on data actions for the database, you can create basic actions on a new or existing model that only wraps a single database table.
- Visit the model and click the info button.
- Click Actions.
- Click the ... next to New action, and select Create basic actions.
Basic action limitations
Basic actions are only available for "basic" models:
- Models built using the graphical query builder. Basic actions are unavailable for models created with native queries (SQL).
- The model must "wrap" a single raw table in a database. The query should simply select that table in the data step of the notebook editor, and nothing more: no joins, no custom columns, no filters or summarization, no sorting.
- The underlying table can only have one primary (entity) key.
Basic action types

Basic actions include:
Update
The update action will present people with a form with editable fields for each column in the primary source table.
When setting up an Update action on a dashboard, you must pass an entity key (like an ID) to the action from a dashboard filter. For other values, you can either prompt the person to fill in a value for each field, or have a field automatically filled in via parameters (such as values set in dashboard filters).
Delete
The Delete action will create a form that prompts people for an entity key, and will delete the record (row) corresponding to that ID in the underlying table that backs the model.
Create
The Create action is the INSERT INTO action. The Create action will present a form with editable fields for each column in the primary source table backing the model. Once filled out, the action will insert the record into the primary table that underlies the model.
Basic actions on dashboards
When setting up actions on a dashboard, you can either prompt the person to fill in a value for each field, or have a field automatically filled in via parameters (such as values set in dashboard filters).
The Update basic action requires you to pass a value for the entity key.
Disable basic actions
You can't archive basic actions, or delete them one at a time. Instead, admins can turn off all of a model's basic actions at once:
- Visit the model, click the info button, and click Actions.
- Click the ... next to New action, and select Disable basic actions.
- Click Disable.
Disabling basic actions also removes any dashboard buttons that use them.
Basic actions from object detail view
If you have basic actions enabled for a model, you can click on an individual record to view its object detail. From that object detail modal, you can click on the ellipses (...) and select update or delete to modify that specific record.
