User guide

What this page is for

Fishbowl keeps a record of what was added and what changed on the tables it audits. This page reads that record and shows it as change history: the old value, the new value, who made the change, and when.

It works on every audited table: sales orders, purchase orders, parts, customers, and user accounts and user groups. Ids become names, so a row reads Mark Bennett instead of 4.

The Audit Trail Explorer

Start here

  1. Start typing in Audited table to pick a table.
  2. Click Load history.
  3. Read the grid. One row for each field that changed.

That is the whole loop. Everything else narrows what you see, or changes how it is shown.

Opened from a module toolbar, say from a sales order, the page skips those steps and loads that record's history for you.

Common tasks

Find one record

Set Look up by to Record ID and enter the id.

On a transactional table you can choose Order # instead, and enter the order number like 1058. Those are sales orders, purchase orders, work orders, MOs, transfer orders, and RMAs. On a line-item table, an order number finds every line on that order.

A table that links to a part, product, vendor, or customer also offers Part #, Product #, Vendor, or Customer. On Vendorparts, Part # finds every vendor added to that part. Part and product numbers must match exactly; a vendor or customer matches on any part of its name.

Leave the value blank to load the whole table's history.

The newest change is at the top. If Fishbowl records more changes after you load, a banner above the grid says how many; click Reload to see them.

See the whole record, not just the change

Switch View to Full snapshots. Instead of one row per changed field, you get the complete record as it stood at each change.

ViewShows
Field changesOne row per changed field, old value and new value. Best for "what changed?"
Full snapshotsThe whole record at each change, every column. Best for "what did it look like?"
Full snapshots

Read ids as names

Resolve names is on by default, and it turns raw ids into something readable:

Link tables resolve too. On objecttoobject the table ids become table names, and the record ids become that table's name or number. For order line items, that is the line-item number.

Resolved link-table rows

Untick Resolve names to see the raw ids. They are always on hover anyway.

Narrow a long history

Click any column header to sort.

Take the results with you

Export CSV saves exactly what you see: the same rows, the same resolved names, the same order. Passwords and secrets stay masked.

Every control

ControlWhat it does
Audited tablePicks the table to read. Type to filter. Matches the table name, its friendly label, or its module.
Look up byRecord ID; Order # on a transactional table; Part #, Product #, Vendor, or Customer on a table that links to one.
Record ID / Order #The value to look up. Blank means every record.
Row limitCaps how many change events load. 5000.
Load historyRuns the lookup.
ViewField changes or Full snapshots.
Resolve namesIds as names. On by default.
Change typeAdded, modified, or deleted.
UserOne user, or all of them.
From / ToA date range. Either can be blank.
Columns / fieldsPicks which fields the grid shows.
Search change logFilters and highlights the rows on screen.
Export CSVSaves what is on screen to a CSV file.
?Runs the guided tour. It changes nothing.
BookShows this guide.
GearSettings. The page has none today.
Sun / moonLight or dark.
DEMO badgeThe page is on sample data, not your Fishbowl.

The numbers above the grid count what you are looking at: change events, records, field changes, added, modified, deleted, and how many users were involved.

The guided tour

Questions people ask

Why is there no history before a certain date? The audit tables can be cleaned out, and what was removed cannot be read. A table also shows nothing until something changes in it. The first edit creates the first entry.

Why are there no deletions? Fishbowl's auditing records what was added and what changed.

Why does a row show a number where I expect a name? The page could not find a name column on that table. Ask support to add the mapping.

Why does my long history stop? A lookup returns 5000 change events at most. Narrow the date range or the change type, then load again.

Where are the custom fields? Each one is tracked on its own, and shows as Custom: <name> [Type] with its old and new value.

Can I see a password that changed? No. Passwords and MFA secrets are never shown. The page records that they changed, and when.