Formula Tester
Test Salesforce formulas without saving them
Write or paste a formula field or flow formula, supply the merge-field values by hand or prefill them from a real record, and see the result plus a breakdown of how it was derived, so you can find which branch of that nested IF went sideways.
Formula tester
Write and test Salesforce formulas — formula fields or flow formulas. Enter merge-field values by hand, or prefill them from a real record. Evaluation runs locally in your browser (no AI, instant) and shows how the result was derived. Read-only: prefill runs a single SELECT and nothing is written to your org.
Formula
Type
Return type
Merge field values
Fields are pulled from your formula when you click out of the box — set each one’s value and type, or prefill from a real record. Type defaults to auto-detect from the value.
Prefill from a real record (optional)
Object API name
Record Id (optional)
Result
Output
Number1250
How it was derived
- 1.With values: IF(25000 >= 5000 && 25000 < 25000,1000,IF(25000 >= 25000 && 25000 < 50000,1250,IF(25000 >= 50000 && 25000 < 150000,1500,IF(25000 >= 150000,2000,0))))
- 2.Result: 1250 · Number
Evaluated locally in your browser — no AI, instant. Covers the common formula functions and operators; field types are inferred from the values. Double-check edge cases (timezones, currency rounding, locale, unsupported functions) against a real record.
What you can do
- Evaluate formula-field and flow-formula syntax without deploying anything
- Runs entirely in your browser: instant results, no AI tokens, no API calls
- A derivation breakdown showing how the result was reached, step by step
- Referenced merge fields are detected for you, so you know what to supply
- Prefill every referenced field from a real record with a single query
- Iterate as many times as you like at zero cost
How it works
Write or paste the formula
Anything you would put in a formula field or a flow formula resource.
Supply the values
Fill the referenced merge fields by hand, or prefill them from a real record with one query.
Read the derivation
See the result and how it got there, which branch was taken, and where it diverged from what you expected.
Why it's different
Runs in your browser for nothing
The usual way to test a formula is to save it into your org and watch what happens, which means a half-broken formula field briefly exists in production. This evaluates locally in your browser: nothing is written, nothing is deployed, no AI tokens are spent, and the answer is immediate. Prefilling from a real record is a single read.
Try asking
- Debug a nested IF that returns the wrong value in one edge case
- Check date arithmetic before committing it to a field
- Work out why a formula returns blank for one record and not another
- Draft a flow formula without saving a half-broken version
- Teach a new admin how a hairy existing formula works
Formula Tester — questions
Put Formula Tester to work on your org
Every AI feature on your own provider key, from A$19.95 per user per month.
- 14-day free trial
- No credit card required
- Cancel any time