Formula Field or Automation: Which Should Calculate?

Choosing between a formula field or automation comes down to whether the value should follow its inputs forever or be fixed at a moment in time.

Why the distinction matters

Both produce a number. They behave differently when the inputs change afterwards.

A formula recalculates whenever its inputs change
An automation writes a value once, and it stays
A historical figure that silently updates is misleading
A live figure that stopped updating is equally misleading

When to use each

Situation	Use
Total from quantity and price	Formula — it should follow the inputs
Hour balance remaining	Formula — it changes as work is logged
Exchange rate applied	Automation — fixed at the moment of the decision
Value at approval	Automation — the historical figure should not move

How to configure it in Jestor

Use a formula field in Jestor where the value should always reflect current inputs.
Use an automation to write a value that must stay fixed from that moment.
Confirm the source fields are the right type — formulas cannot calculate on text.
Use formula blocks on panels where the calculation belongs to the view rather than the record.
Check the execution log after configuring an automation-written value.

Why choose Jestor for calculated values?

Jestor offers formulas at field level and at panel level, which lets a calculation live with the record when it belongs there and with the view when it does not.

Because the change history records what wrote each value, a figure that moved unexpectedly can be traced to whether a formula recalculated or an automation overwrote it.

Frequently Asked Questions

Does a formula update automatically?

Yes, whenever its inputs change. See jestor.com.

How do I fix a historical value?

Have an automation write it at the relevant moment.

Why will my formula not calculate?

The source field is probably text.

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.

How do you choose an AI tool for professional services operations teams in SMBs?

To choose an AI tool for professional services operations teams in SMBs, look for a platform that combines no-code tables for clients, engagements, and documents with AI features that answer messages, read documents, and summarize data, while keeping professionals in control of advice. In Jestor, these pieces work together,

How do you build a business continuity plan for a services firm?

To build a business continuity plan for a services firm, list critical processes and deadlines, identify risks such as system outages or key person absence, define backup options, assign roles, and test the plan. In Jestor, processes, risks, and actions are connected, so the firm keeps serving clients during disruptions.

What is the best way to run IT security awareness training for staff in a services firm?

A practical way to run IT security awareness training for staff in a services firm is to define short training modules, assign them to all staff, track completion, run simulated phishing tests, and schedule refreshers. In Jestor, staff, modules, and results are connected, so security habits become part of the

How do you route website lead forms to the right team in a services firm?

To route website lead forms to the right team in a services firm, ask for the service and company size in the form, route leads automatically to the right team, set response time targets, record follow-ups, and track conversion by source. In Jestor, forms, leads, and teams are connected,