- 11 Sep 2023
- 2 Minutes to read
- Print
- DarkLight
Adding, duplicating, and deleting Airtable records
- Updated on 11 Sep 2023
- 2 Minutes to read
- Print
- DarkLight
A record is an individual item in a table. Records are the basic unit of data that are pulled into various views and interfaces.
Introduction
Plan availability | All plan types/levels |
Permissions |
|
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading | |
Airtable terminology |
|
Adding records
- Visit your Airtable homepage.
- Click Create a base or open an existing base.
- Once inside your base, click the + icon in the bottom-left corner of your bases’ table.
Duplicating records
- Visit your Airtable homepage.
- Open your preferred base.
- Right-click on the record you want to duplicate and select Duplicate record.
.gif)
Deleting and archiving records
- Visit your Airtable homepage.
- Open your preferred base.
- Right-click on the record you want to delete and select Delete record.
Instead of deleting records, you can archive records by applying filtering conditions to your views to hide content that is no longer relevant.
Suppose any records are updated to match your archive filter criteria. In that case, those records will automatically appear in the archived records view. They will no longer be visible in any views which exclude archived records. We recommend reviewing our Advanced filtering using conditions article for more on customizing your filtering conditions with condition groups.
We do not currently offer the ability to archive a base, but you can remove a base from your workspace by deleting it.
FAQs
Records can be duplicated using the fill handle.
We recommend using the dedupe extension or this delete duplicates script to merge, delete, and duplicate records.
At this time the only way to delete a record using an automation is to do so via the Run a script action.
To rename a table:
- Click the arrow next to your table's name.
- Click Rename table and enter your preferred name.
- Under What should each record be called?, click the down arrow to select an updated name.