Use this extension to save time and headaches working with Salesforce formulas. It helps you quickly understand the structure of a Salesforce formula, review the fields used by it, and edit the formula.
This extension requires a paid license key subscription and offers a free 14-day trial.
When you visit a Salesforce formula edit page it will automatically enhance the formula text field with a code editor. This includes formula fields, validation rule formulas, workflow rule formulas, and field update formulas.
The extension is updated during each Salesforce quarterly release to support the latest API versions and the latest formula functions.
Watch the video and visit the extension’s website for examples of the below features:
https://www.enhancedformulaeditor.com/
Editor Features Include:
– Syntax highlighting
– Tabbing (tab and shift-tab)
– Parentheses matching
– Find and Replace
– No code wrapping
– Resizing the editor
– Format button
– Works with Lightning!
A new button named “Load Field Details” is added to formula pages that loads details about the fields found in the formula.
Field Details Include:
– Field type
– How many times it is used
– Formula field compile sizes
– Field edit links
– Field record values
– Field Label
– Field Help Text
– Picklist values
– Sub formulas
Have an issue or a great idea for this extension? Visit the support tab above to leave feedback.
Updates
2/15/2021 – Resize editor by dragging and dropping the bottom right corner
1/30/2021 – Picklist options now list the API Name and Label
1/9/2020 – Updated licensing system
11/22/2020 – Updated to use the latest metadata API version
6/30/2020 – Updated to use the latest metadata API version
1/6/2019 – Fixed some bugs handling decimal numbers
9/5/2018 – Added a button that formats the formula for you
7/11/2018 – Editor now remembers your font size
6/24/2018 – Now works with Lightning
3/1/2017 – Editor now remembers what size you made it
8/12/2015 – New “Load Field Details” button
7/11/2015 – Insert buttons for fields and functions work now
1/9/2012 – Fixed text wrapping in nowrap mode.
Can’t write formulas without it! Probably the most used Salesforce extension for me. Sad the price went up, but since I can’t live without it, the price is still minimal IMO. I wish this also worked with writing formulas directly in Process Builder or Flows, though.
HUGE time-saver!
Works like a dream. Totally under-priced.
Wish I had known about this extension a looooong time ago!
Installed the extension, opened a formula in Salesforce Lightning….and no help offered. As I didn’t had the extension. Wasted money! 🙁
Awesome! Great tool and makes writing formulas so much easier!
Such a great extension! It’s super useful for matching up parentheses on complicated formulas.
Love it!
Love this extension! Night and Day from the standard editor.
I have paid for it and installed it and its not working at all. Nowhere to go for help. I need help asap
The parentheses matcher helps so much.
I enjoy all the functionality -but my screen displays the enhanced editor under the standard sf editor. Thus when checking syntax sf always checks the standard editor and ignores my work in the enhanced editor, also saving causing the standard to overwrite the data in the enhanced editor : (
I have alot of hope for this Chrome extension but it does not appear when I’m in any sort of formula editor. Not sure how to activate that. Its been added to my chrome and allowed in incognito. Does not work in regular or incognito
I highly appreciate the functionality this extension provides. It is acts a very lightweight IDE to troubleshoot complex formulas, as well highlighting nested parenthesis and keywords. The only improvement I was would suggest is to work with the debugging tool, as I have to turn off the extension to find the error temporarily.
Makes formula building so much easier.
A splash screen comes up when you first go in which cannot be closed on my laptop. Maybe if I were on a bigger monitor it would work, but this is something basic which should have been caught.
So much easier than cutting and pasting into an external editor. Thanks.
Not sure why Salesforce hasn’t paid you millions and incorporated directly into the product.
Thank you for creating such a useful extension!
I featured your extension on my blog, on a post on my favorite Chrome Extensions for Salesforce:
http://www.forcethe.cloud/2016/07/5-must-have-chrome-extensions-for.html
This is simply incredible!
Super helpful.
Nifty little add in so I don’t have to pull my formulas into the IDE.
It works OK. It doesn’t pair up the parenthesis in different colours (like Notepad ++ does) which would be the main benefit of having it. Still much better than native Salesforce so thank you.
While this may not be perfect, it is light years ahead of what the native formula builder provides.
It has already helped me when creating some pretty complicated validation rules.
A+ on finding the syntax errors where they show themselves.
Hi Kyle, great job on this product! It is really helpful. We use a lot of complex formulas in our SFDC org and as a senior business systems analyst this is priceless. Is it possible to add the “Load Field Details” button/functionality to the formula editor on Workflow Rule, Field Updates? This would make the product even better! Thank you for your consideration.