How to Audit Record Changes With Table History

To audit record changes with table history, you open the history view scoped to a single table. Instead of the whole account's activity, you see what changed in this process and who or what changed it.

Why account-wide logs are hard to use

A single log covering everything is technically complete and practically unsearchable.

  • Activity from unrelated processes drowning what you need
  • No way to isolate a single table's changes
  • Unclear whether a change came from a person, an automation, or an integration
  • Deletions indistinguishable from updates at a glance

What the history view lets you filter

  • Action type — whether a record was deleted or updated
  • Source — a user, an API call, or an automation
  • Date — today, yesterday, or a custom range
  • Advanced filters — narrowing further for a specific investigation
  • Before and after — the state on both sides of the change

How to configure it in Jestor

  1. Open the table in Jestor and go to the views section.
  2. Select the history view, which is scoped to that table.
  3. Filter by action type to separate deletions from updates.
  4. Filter by source to distinguish user edits from automation or API changes.
  5. Filter by date, and add advanced filters for a narrower investigation.

Why choose Jestor for operational auditing?

Jestor groups changes made together, so if someone altered five fields in one save, the history records a single entry with the full before-and-after state rather than five disconnected lines.

The platform also holds SOC 2 Type I and II certification, with regular penetration testing and access auditing — relevant when the history is being used for compliance rather than curiosity.

Frequently Asked Questions

Can I tell if a change came from an automation?

Yes, the source can be filtered. See jestor.com.

Why do multiple changes appear as one entry?

Changes saved together are grouped, with the full before-and-after state.

Is history available per table?

Yes, filtered to that table specifically.

Video Tutorial: Step by Step

Check out other practical tutorials on the Jestor YouTube channel.

Get to know Jestor

With Jestor, you can automate workflows, connect teams, and build internal systems your way — all without code and powered by AI. Discover Jestor at jestor.com and see how to take your company's operations to a new level of efficiency and control.

Read more