Description from extension meta
Enhances Salesforce formulas with syntax highlighting, autocomplete, formatting, field analysis, and syntax checking.
Image from store
Description from store
Use this extension to save time and headaches working with Salesforce formulas. It helps you quickly understand the structure of a Salesforce formula, debug it, and edit the formula.
This extension requires a paid license key subscription and offers a free 14-day trial.
Watch the video and visit the extension's website for examples of the below features:
https://www.enhancedformulaeditor.com/
When you visit a Salesforce formula edit page it will automatically enhance the formula text field with a code editor or provide an Open button to use the code editor in a popup window. This includes Flow formulas, Process Builder formulas, 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.
Editor Features Include:
- Syntax highlighting
- Tabbing (tab and shift-tab)
- Parentheses matching
- Format button
- Autocompletion
- Review Changes
- Automated Syntax Checking
A new button named "Analyze Fields" 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 record values
- Picklist values
- Sub formulas
Have an issue or a great idea for this extension? Visit the support tab above to leave feedback.
Updates
3/5/2023 - Format button support for Flows and Process Builders
6/12/2022 - Summer 2022 updates (new functions, latest api version)
2/8/2022 - Added automatic syntax checking
1/26/2022 - Added a Review Changes button to highlight what was changed
1/8/2022 - Autocomplete now searches in the middle of field names/functions
12/14/2021 - Added font family dropdown so fixed-width/monospace fonts can be used
12/12/2021 - Added field/function autocomplete for some instances
11/7/2021 - Added OAuth API Access for orgs that don't have the sid cookie available
8/7/2021 - Format formula improvements
6/8/2021 - Added support for cloudforce.com
3/21/2021 - Now supports flow and process builder formulas
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.
Latest reviews
- (2024-07-02) Sasha Agrich: This tool is awesome. I didn't think I needed it until I had it. Favorite features: - Ability to check syntax without having to press the 'Check Syntax' button - Ability to see related field/formula compile sizes - Ability to call up fields by typing them without having to go to the clunky 'Insert Field' button - Color coded formulas - get to easily see what's commented in, commented out, functions, etc
- (2022-10-17) J S: Great features so far! Really wanted to make use of the "Analyze fields" feature which does not seem to support our custom object. This object is also somewhat a managed object created by our partner organization. The error message I receive is the following. "Error describing object 'Object_Name__c'. It may only be accessible from a newer version of the API or you may not have meta data api access. Error message: The requested resource does not exist." Is there a workaround for this?
- (2022-10-17) J S: Great features so far! Really wanted to make use of the "Analyze fields" feature which does not seem to support our custom object. This object is also somewhat a managed object created by our partner organization. The error message I receive is the following. "Error describing object 'Object_Name__c'. It may only be accessible from a newer version of the API or you may not have meta data api access. Error message: The requested resource does not exist." Is there a workaround for this?
- (2022-09-14) M B: Great extension! I love it and use it almost on a daily basis. Can't imagine life without it now! If I can make one suggestion though, it would be to not have the formula editor open in a separate window when trying to write a formula in flow. If I'm making a formula for my flow's start condition or if I'm making a formula for a variable/resource, the only option I have is for the formula editor to open in a separate window. I would love if it kept the formula editor confined to the same window. It functions like that already for custom formula fields in object manager, I just wish it did the same for flow.
- (2022-09-14) M B: Great extension! I love it and use it almost on a daily basis. Can't imagine life without it now! If I can make one suggestion though, it would be to not have the formula editor open in a separate window when trying to write a formula in flow. If I'm making a formula for my flow's start condition or if I'm making a formula for a variable/resource, the only option I have is for the formula editor to open in a separate window. I would love if it kept the formula editor confined to the same window. It functions like that already for custom formula fields in object manager, I just wish it did the same for flow.
- (2022-08-05) Adrian Zgoda: This is a very, very helpful extension when it comes to editing any formulas. I've used other formula formatting extensions before, but this one is definitely more robusts and makes searching and adding fields a breeze once you know how. My only complaint is that it seems to drastically slow down certain parts of Salesforce's Setup area especially in Flows (especially when adding fields inside of an element). I even went through and disabled all of my extensions and enabled them oneat a time to narrow it down to this extension causing the issues. At this point, I just do all of my automation work in incognito with that extension disabled. If this could be fixed, this would be a 5-star extension, without a doubt!
- (2022-08-05) Adrian Zgoda: This is a very, very helpful extension when it comes to editing any formulas. I've used other formula formatting extensions before, but this one is definitely more robusts and makes searching and adding fields a breeze once you know how. My only complaint is that it seems to drastically slow down certain parts of Salesforce's Setup area especially in Flows (especially when adding fields inside of an element). I even went through and disabled all of my extensions and enabled them oneat a time to narrow it down to this extension causing the issues. At this point, I just do all of my automation work in incognito with that extension disabled. If this could be fixed, this would be a 5-star extension, without a doubt!
- (2022-08-03) Hien Ferber: I cannot live my SFDC admin life without this extension. The enhancements added to it like analyzing fields, testing value on a record and auto-checking syntax make it even better!
- (2022-08-03) Hien Ferber: I cannot live my SFDC admin life without this extension. The enhancements added to it like analyzing fields, testing value on a record and auto-checking syntax make it even better!
- (2022-04-26) April Barclay: This extension is the bees knees for formula editing. Showing the matching parentheses is key and makes reading formulas much easier.
- (2022-04-26) April Barclay: This extension is the bees knees for formula editing. Showing the matching parentheses is key and makes reading formulas much easier.
- (2022-03-04) Ed Sarkissian: Love love love this extension. So incredibly handy. Thank you Kyle.
- (2022-03-04) Ed Sarkissian: Love love love this extension. So incredibly handy. Thank you Kyle.
- (2021-12-22) Jeremy Farber: Purchased already using Google now asking me to purchase again for $20. Look for the free version it works just as good.
- (2021-12-22) Jeremy Farber: Purchased already using Google now asking me to purchase again for $20. Look for the free version it works just as good.
- (2021-12-14) Sydnie Blanchard: Had high hopes, but doesn't seem to come up when I click the extension.
- (2021-11-05) Gina Marques: One of my FAVORITE extensions, helps with structuring your formulas correctly. I'm always missing something, and this tools saves so much time when debugging syntax errors.
- (2021-11-05) Gina Marques: One of my FAVORITE extensions, helps with structuring your formulas correctly. I'm always missing something, and this tools saves so much time when debugging syntax errors.
- (2021-08-19) Unai García: Great extension. The Format functionality saves us so much time when trying to clean up or visualise long formulas. The parenthesis matching is also very helpful to debug and try and find issues in the formulas.
- (2021-08-19) Unai García: Great extension. The Format functionality saves us so much time when trying to clean up or visualise long formulas. The parenthesis matching is also very helpful to debug and try and find issues in the formulas.
- (2021-06-18) Peter Teplicky: Formula editor is a very handy add-on that offers additional functionality that is missing in the standard Salesforce formula editor. I appreciate Kyle's professional approach really very much, as he responded promptly to my suggestion for improvement, and nearly in real time did find a solution, which was perfectly fitting. It works on formulas on Fields, Validation rules, Process builder, and Flows. I can only recommend this add-on as a very useful tool for every Salesforce administrator.
- (2021-06-18) Peter Teplicky: Formula editor is a very handy add-on that offers additional functionality that is missing in the standard Salesforce formula editor. I appreciate Kyle's professional approach really very much, as he responded promptly to my suggestion for improvement, and nearly in real time did find a solution, which was perfectly fitting. It works on formulas on Fields, Validation rules, Process builder, and Flows. I can only recommend this add-on as a very useful tool for every Salesforce administrator.
- (2021-01-13) Cassandra Yu: 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.
- (2021-01-13) Cassandra Yu: 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.
- (2020-08-12) David Palmer: HUGE time-saver! Works like a dream. Totally under-priced. Wish I had known about this extension a looooong time ago!
- (2020-08-12) David Palmer: HUGE time-saver! Works like a dream. Totally under-priced. Wish I had known about this extension a looooong time ago!
- (2020-07-13) Andrei Tomescu: Installed the extension, opened a formula in Salesforce Lightning....and no help offered. As I didn't had the extension. Wasted money! :(
- (2020-07-13) Andrei Tomescu: Installed the extension, opened a formula in Salesforce Lightning....and no help offered. As I didn't had the extension. Wasted money! :(
- (2020-02-13) Clayton Goss: Awesome! Great tool and makes writing formulas so much easier!
- (2020-02-13) Clayton Goss: Awesome! Great tool and makes writing formulas so much easier!
- (2019-10-03) Karen Bonilla: Such a great extension! It's super useful for matching up parentheses on complicated formulas.
- (2019-10-03) Karen Bonilla: Such a great extension! It's super useful for matching up parentheses on complicated formulas.
- (2019-09-23) Nicola Mitcham: Love it!
- (2019-09-23) Nicola Mitcham: Love it!
- (2019-06-05) Josh E: Love this extension! Night and Day from the standard editor.
- (2019-06-05) Josh E: Love this extension! Night and Day from the standard editor.
- (2019-04-24) Andrea Onhaus: I have paid for it and installed it and its not working at all. Nowhere to go for help. I need help asap
- (2019-04-24) Andrea Onhaus: I have paid for it and installed it and its not working at all. Nowhere to go for help. I need help asap
- (2019-02-23) It works, thank you!
- (2019-02-23) It works, thank you!
- (2018-06-19) Ryley Oroku: The parentheses matcher helps so much.
- (2018-06-19) Ryley Oroku: The parentheses matcher helps so much.
- (2017-05-01) Yehoshua {Jeff} Krakowski: 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 : (
- (2017-05-01) Yehoshua {Jeff} Krakowski: 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 : (
- (2017-03-28) Matthew Straney: 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
- (2017-03-28) Matthew Straney: 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
- (2017-02-22) Joshua Hric: 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.
- (2017-02-22) Joshua Hric: 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.
- (2017-01-30) April Barclay: Makes formula building so much easier.
- (2017-01-30) April Barclay: Makes formula building so much easier.
Statistics
Installs
6,000
history
Category
Rating
4.2881 (59 votes)
Last update / version
2024-10-13 / 2.6.1
Listing languages
en