Skip to content
Gravity Tables
minor v4.1.7 · · 2 min read

Inline edits now trigger calculation recalculation, instantly

Edit a quantity, watch the price update. Edit a number, watch the dependent calculation field follow. No page refresh, no cache fight.

  • Calculation fields recalculate the moment you finish editing a numeric cell
  • Gravity Forms Total fields recalculate from product × quantity edits
  • Internal cache is bypassed for the affected row to guarantee accuracy
  • No additional DB writes, recalculation reuses existing GF logic

This is one of those releases where the bug report and the feature spec are the same paragraph: “When I edit a quantity, the line total should update.”

In every previous version it didn’t. Inline edits committed a single field, but Gravity Forms’ Total and Calculation fields are derived values, not stored ones, and we weren’t re-running the GF calculation engine for the affected row.

What changed#

When you commit an inline edit on a column that participates in a calculation:

  1. The new value is saved (same path as before)
  2. The row’s GF entry is fetched fresh, bypassing our internal cache to avoid stale dependents
  3. GF’s calculation engine re-runs for every dependent Calculation/Total field on the entry
  4. The new derived values are written back to the entry meta
  5. The table re-renders the affected row in place, no full table refetch

The effect: a 5,000-row table with 12 calculated columns updates only the row you touched, in well under 100ms on commodity hardware.

A note on cache invalidation#

This is the kind of fix that exists at the boundary of two cache layers (ours, and Gravity Forms’). The safe move is to invalidate aggressively for the affected row only, which is what 4.1.7 does. We are not blowing away the table-wide cache on every keystroke; that would defeat the point.

Compatibility#

  • Requires: No upgrade path. Activate the new version, edit a numeric cell, watch dependents update.
  • Works with: Standard GF Number, Quantity, Product, Total, and Calculation fields.
  • Doesn’t yet recalc: Hidden conditional logic that depends on the edited field’s visibility. That’s queued for 4.2.

Combined with 4.1.8#

Read together with 4.1.8’s totals row, this means you can now have a table where:

  • Editing a quantity updates the line total
  • The line total update triggers the column total in the footer row
  • Filtering down to a subset re-runs the column total against the filtered slice

All in real time, all without a page reload, all with zero shortcode changes.

#inline-editing#calculations#gravity-forms-total