# Change History and Comments per Record | BaseTable

> Online database with row-level auditing: field-by-field change history (previous value → new) and a comment thread in every record. Free with BaseTable.

- **Source (source):** https://aistohire.com/basetable-flexible-online-database-154/f/change-history-and-comments-per-record
- **Platform (platform):** AIstoHire
- **Language (language):** en

## In summary

- Comments and change history on every record
- Open any BaseTable record and you'll find three tabs: Fields, Comments and History. The team thread and the trail of who touched what live inside the data itself, not in a separate chat.
- The diff, field by field
- Human-readable values, not JSON
- Conversation tied to the data

## Comments and change history on every record

BaseTable is AIsToHire's no-code database, and traceability isn't an extra you need to turn on: it comes built into every record. When you open a row's detail view you'll see three tabs—Fields, Comments and History. In Comments you have a thread specific to that record: you type, send with Ctrl+Enter and the message is timestamped alongside the previous ones. In History you see the trail of everything that's happened to that row, from most recent to oldest.

History logs four things: record created, updated, deleted and restored, each with its date and time in your language. The interesting part is edits: instead of « someone changed something », it lists the change field by field, with the field name, the old value struck through and the new value next to it. And values are shown formatted to their type, so a currency reads as currency, a duration as duration and a multi-select as its labels, not as raw JSON.

It also works when things break. Deletion entries survive the record: if a row was deleted, its trail remains there for review. If you recover it from trash, a « Record restored » entry is added. And if meanwhile you deleted a field, history doesn't go silent: it marks that change as « (deleted field) » instead of disappearing.

In teams it fits with the app's permissions. Share the base and whoever has editor role on the table can comment and delete their own comments; those who enter as readers see the thread and history without being able to write. You, as base owner, can remove any comment from your base. The actual author of each change and each comment is saved with the entry—even if made by a guest—while the panel shows the action, date and change detail.

All this is in BaseTable, AIsToHire's online database app: https://aistohire.com/basetable-flexible-online-database-154

## What's included

- **The diff, field by field** — each edit reads like « Status »: In progress → Done, with the field name, old value struck through and the new one. No need to guess what moved.
- **Human-readable values, not JSON** — the history formats each value according to its field type—currency, percentage, duration, date with time, select, rating, collaborator or linked record.
- **Conversation tied to the data** — the comment thread lives in the record, not in an external chat. Anyone opening that row six months later finds the discussion that explains it.
- **Four timestamped actions** — created, updated, deleted and restored, sorted from most recent to oldest and paginated 50 at a time with «Load previous».
- **The trail survives deletion** — deletion entries are preserved even when the record is gone, and restoring it from trash adds its «Record restored» entry.
- **Schema-change proof** — if you delete a field later, the history still shows that change marking it as «(deleted field)» instead of losing the entry.
- **Comments with permissions** — table editors comment and delete their own messages, readers only read and the base owner can remove any comment.
- **No setup required** — no need to enable auditing or hire a separate plan. Every record you create in BaseTable automatically starts storing its thread and history.

## Frequently Asked Questions

### How do I see who changed data and when?

Open the record and go to the History tab: you'll see entries from most recent to oldest, each with its action (created, updated, deleted or restored) and its date and time. In edits, the change is detailed field by field: the field name, the previous value crossed out and the new value. The author of the change is saved along with the entry, even when it was made by a guest of the database.

### Are comments per record or per table?

Per record. Each row has its own thread in the Comments tab, with the oldest messages at the top and new ones at the bottom. You type in the text box and send with the Send button or with Ctrl+Enter. Each comment supports up to 2,000 characters and each record stores up to 500; they load 50 at a time with the «Load previous» button.

### Can anyone I share the base with comment?

It depends on the role you assign them in each table. Those who enter with an editor role can write comments and delete their own; those who enter as readers see the thread and history but cannot write. As the base owner, you can remove any comment, whoever wrote it. Permissions are the same ones you use for sharing: by table, by view, and by field.

### If I delete a record by mistake, is its history lost?

No. Deletion entries survive the record, so you can check what was deleted even if the row is no longer in the table. Deleted records can be restored from the BaseTable trash, and when you do, the history adds a «Record restored» entry with its date. The app also has undo and redo for immediate mistakes.

### How much history is saved for each table?

Each table keeps its last 500 history entries; beyond that, the oldest ones are automatically discarded so the base doesn't grow out of control. If a single edit touches a huge number of fields at once, the detail is trimmed and the entry is saved without the full breakdown. It's not a legal audit file: it's day-to-day team traceability.

- [BaseTable — Flexible spreadsheet-style database](https://aistohire.com/basetable-flexible-online-database-154)

## About the platform

**BaseTable — Flexible spreadsheet-style database** — an app by AIstoHire. Available at: https://aistohire.com/basetable-flexible-online-database-154/f/change-history-and-comments-per-record

### Other languages

- `es`: https://aistohire.com/es/basetable-base-datos-flexible-online-154/f/historial-de-cambios-y-comentarios-por-registro
- `fr`: https://aistohire.com/fr/basetable-base-de-donnees-flexible-en-ligne-154/f/historique-modifications-commentaires-enregistrement
- `it`: https://aistohire.com/it/basetable-database-flessibile-online-154/f/cronologia-modifiche-e-commenti-per-record
- `pt`: https://aistohire.com/pt/basetable-banco-de-dados-flexivel-online-154/f/historico-de-alteracoes-e-comentarios-por-registro
- `de`: https://aistohire.com/de/basetable-flexible-online-datenbank-154/f/aenderungshistorie-und-kommentare-pro-datensatz
- `bg`: https://aistohire.com/bg/basetable-onlayn-baza-danni-kato-elektronna-tablitsa-bez-programirane-154/f/istoriya-na-promenite-i-komentari-po-zapis
- `ja`: https://aistohire.com/ja/nokodo-database-spreadsheet-154/f/record-henko-rireki-comment
- `nl`: https://aistohire.com/nl/basetable-online-database-als-spreadsheet-zonder-code-154/f/wijzigingsgeschiedenis-en-opmerkingen-per-record
- `ko`: https://aistohire.com/ko/basetable-nocode-database-spreadsheet-154/f/record-byeol-byeongyeong-iryeok-comment
- `sv`: https://aistohire.com/sv/basetable-databas-online-i-kalkylbladsstil-utan-kod-154/f/andringshistorik-och-kommentarer-per-post
- `da`: https://aistohire.com/da/basetable-online-database-som-et-regneark-uden-kode-154/f/aendringshistorik-og-kommentarer-pr-post
- `ar`: https://aistohire.com/ar/basetable-qaada-bianat-aunlain-shbiha-bjdul-albianat-dun-brmja-154/f/change-history-and-comments-per-record
- `no`: https://aistohire.com/no/basetable-database-pa-nett-i-regnearkstil-uten-koding-154/f/endringshistorikk-og-kommentarer-per-oppforing
- `fi`: https://aistohire.com/fi/basetable-taulukkolaskennan-kaltainen-tietokanta-netissa-ilman-koodausta-154/f/muutoshistoria-ja-kommentit-tietueittain
- `zh`: https://aistohire.com/zh/basetable-no-code-spreadsheet-database-154/f/record-change-history-and-comments
- `pl`: https://aistohire.com/pl/basetable-baza-danych-online-jak-arkusz-bez-programowania-154/f/historia-zmian-i-komentarze-rekordu
- `he`: https://aistohire.com/he/basetable-msd-ntonim-aonliin-bsgnon-gilion-bli-tknot-154/f/historiyat-shinuyim-vetgovot-lechol-reshuma
- `cs`: https://aistohire.com/cs/basetable-online-databaze-ve-stylu-tabulky-bez-programovani-154/f/historie-zmen-a-komentare-u-zaznamu
- `id`: https://aistohire.com/id/basetable-basis-data-online-seperti-lembar-kerja-tanpa-coding-154/f/riwayat-perubahan-dan-komentar-per-rekaman
