Standalone Salesforce Formula Debugger
While the Formula Debugger browser extension is not yet as polished as I would like, I am making a similar standalone tool publicly available.
(link in the comments)
This one will NOT connect to your Salesforce org.
You will have to copy and paste the formula in the page and click Analyze.
It will parse the formula into an AST (Abstract Syntax Tree) and expose that data structure below with input fields.
Then you can experiment with different values on the fields, click Calculate Formula and see the results of each of the intermediary expressions that make up the formula.
That way you can test and troubleshoot the formula. Hopefully it will help speed up the trial and error process that is usually involved in complex formulas.
The Open Diagram button will also display an equivalent Mermaid diagram of the formula.
Note that not all Salesforce formula functions have been implemented yet, so some formulas may not work.
