Base Trash ☁

Base Trash is your safety net for accidental deletions. When you delete an item in a base, the item moves to Base Trash. This applies to records, tables, fields, views, dashboards, widgets, workflows, scripts, and extensions. You can restore the item from Base Trash until someone empties the trash or the retention period ends.

Open Base Trash

  1. In the topbar, click the History icon.
  2. Select Base Trash.

Access the Trash from the History menu

Reading the Trash list

Trash modal overview

Each deletion shows as one entry in the list. Each entry shows:

DetailWhat you see
Who deleted itTo see the name and email of the user, hover over the avatar.
WhenTo see the exact timestamp, hover over the time label.
What was deletedThe resource name and its location. For deleted records, a preview shows the primary field for up to eight rows. To see the full batch, click Show all.

An expanded batch

What you can recover

Base Trash covers all items in a base:

ResourceWhat gets restored
RecordsThe deleted rows come back with their values and links. A bulk delete shows as one entry, so you can restore a full batch at the same time.
TablesThe table comes back with all its views, fields, and records intact.
ViewsThe view returns with its filters, sorts, group-by, and field visibility.
FieldsThe field comes back with all its cell values.
Dashboards & widgetsThe dashboard layout and any widgets on it come back as configured.
Workflows & scriptsThe full definition comes back: triggers, steps, and code.
ExtensionsThe extension comes back with its saved configuration.

Restoring an entry

Next to the entry that you want back, click Restore. Records go back into the table. Tables, views, and fields go back into the base.

Some things to know:

SituationWhat happens
Restoring a tableNocoDB also restores all its views, fields, and records in one step.
If a field has been renamed since the record was deletedThe restored value goes into the renamed field, not into a new field.
If a field has been deleted since the record was deletedNocoDB drops that value. The rest of the record still comes back.
If a linked record is goneNocoDB skips that link and restores the other links.
If a Single Select or Multi Select option was renamed after the deletionThe restored record uses the current option name.

When restore can't go through

Sometimes a restore conflicts with the current data. Then a panel opens. It lists the conflicts and gives you three options:

OptionWhat it does
CancelKeeps all items in the Trash. Fix the conflicting records first.
Restore the clean onesRestores all items that have no conflicts. The other items stay in the Trash.
Restore anywayRestores all items. NocoDB clears the conflicting fields on the restored records, so they do not override the current active data.

You can see three types of conflicts:

ConflictCause
Linked record takenThe link that the restored record had now points to another record. For example, a one-to-one slot, or a has-many parent whose child has been linked again. The other record keeps the link.
Unique value takenA field marked Unique on the restored record now has the same value as an active record.
Format mismatchSomeone added or tightened a validation rule (Email, URL, or Phone number) after the record was deleted. The stored value does not match the new rule.

For all three types, Restore anyway clears the conflicting field on the restored record. You can then fix the field manually.

Empty Base Trash

Empty Trash button in the Trash modal

  1. In the top-right of the dialog, click Empty Trash.
  2. Confirm the dialog.

Empty Trash permanently deletes everything in the base's Trash: records, tables, views, fields, dashboards, widgets, workflows, scripts, and extensions. There is no undo. For longer-term recovery, use Base snapshots.

Who can do what

ActionOwnerCreatorEditorCommenterViewer
Open Base TrashYesYesYesNoNo
Restore a recordYesYesYesNoNo
Restore a table, view, field, dashboard, widget, workflow, script, or extensionYesYesNoNoNo
Empty TrashYesNoNoNoNo
View or change trash settingsYesNoNoNoNo

If a base uses row-level security, the same rules apply in Base Trash. If you could not see a record in the live table, you also cannot see it in Base Trash after deletion.

Editors can restore records but can't permanently delete individual entries. To clear them sooner than the retention period, an Owner needs to Empty Trash.

Availability

  • Base trash is available on all NocoDB Cloud plans and on licensed self-hosted deployments (Business plan and above). The retention period before automatic cleanup is different for each plan. For plan defaults and per-table overrides, see Trash settings.

Last updated on

Latest product updates?See Changelog
Stay in the loop? Follow us onLinkedInLinkedInYouTubeYouTubeXX