Computed or Formula Fields Not Updating in Base44

Computed or formula fields in your Base44 database tables are showing stale, incorrect, or blank values. When you update the source fields that the formula depends on, the computed field does not recalculate automatically.

This issue is especially problematic for apps that rely on calculated totals, status indicators, or derived values. For example, an order total field that sums line items may show zero, or a status field based on a date comparison may not reflect the current date.

In some cases, the computed field works correctly for newly created records but fails to update when the underlying data changes.

Error Messages You Might See

  • Formula error: undefined reference
  • #ERROR in computed field
  • Circular reference detected

[Formula error: undefined reference](/content/guides/search?q=Formula%20error:%20undefined%20reference "Search for this error"/index.html)
[#ERROR in computed field](/content/guides/search?q=%23ERROR%20in%20computed%20field "Search for this error"/index.html)
[Circular reference detected](/content/guides/search?q=Circular%20reference%20detected "Search for this error"/index.html)

Common Causes

  1. The formula syntax contains an error that silently fails instead of showing a clear error message
  2. The formula references a field that has been renamed or deleted from the table
  3. Computed fields that reference related table data don't refresh when the related record changes
  4. A circular reference exists where two computed fields depend on each other

How to Fix It

Review the formula syntax carefully, paying attention to exact field names and data types. Try simplifying the formula to a basic expression first, then add complexity incrementally to find the breaking point.

If the formula references related tables, check whether Base44 supports automatic refresh of cross-table computed fields or if a manual trigger is needed.

Complex formulas with multiple dependencies or cross-table references often require a developer to restructure into a reliable calculation approach that updates consistently.

Frequently Asked Questions

Why is my Base44 computed field showing the wrong value?

Check that the formula references the correct field names and that none of the referenced fields have been renamed or deleted. Test with a simplified formula first.

Do Base44 computed fields update automatically?

They should recalculate when source fields change, but cross-table references may require a page refresh or manual trigger. Check if your formula depends on data in another table.