Enhances Salesforce formulas with syntax highlighting, autocomplete, formatting, field analysis, and syntax checking.

Latest Version

Version
2.6.1
Update
October 12, 2024
Size
440KiB
Developer
www.enhancedformulaeditor.com
Category
Users
6,000+
Rating
4.28814 ★
Manifest Version
3
Web Store Status
Languages Support
English
See more
Permissions
Storage
See more

Salesforce.com Enhanced Formula Editor Extension

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.
Read more

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx",\t"manifest_version": 3,\t"action": {\t\t"default_icon": {\t\t\t"16": "icon16.png",\t\t\t"24": "icon24.png",\t\t\t"32": "icon32.png"\t\t}\t},\t"icons": {\t\t"16": "icon16.png",\t\t"48": "icon48.png",\t\t"128": "icon128.png"\t},\t"content_scripts": [\t\t{\t\t\t"js": [ "contentscript.js" ],\t\t\t"matches": [ "https://*.salesforce.com/*", "https://*.salesforce-setup.com/*", "https://*.lightning.force.com/*", "https://*.cloudforce.com/*" ],\t\t\t"all_frames": true\t\t}\t],\t"web_accessible_resources": [\t\t{\t\t "resources": [\t\t\t"options.html",\t\t\t"edit_area_loader.js",\t\t\t"activate_editor.js",\t\t\t"elements_functions.js",\t\t\t"resize_area.js",\t\t\t"reg_syntax.js",\t\t\t"langs/en.js",\t\t\t"reg_syntax/forceformula.js",\t\t\t"edit_area.css",\t\t\t"edit_area.js",\t\t\t"manage_area.js",\t\t\t"edit_area_functions.js",\t\t\t"keyboard.js",\t\t\t"search_replace.js",\t\t\t"highlight.js",\t\t\t"regexp.js",\t\t\t"images/*",\t\t\t"jsforce-core.min.js",\t\t\t"jquery.min.js",\t\t\t"FieldDetailsScreenshot.jpg",\t\t\t"plugins/*",\t\t\t"review.js"\t\t ],\t\t "matches": [\t\t\t""\t\t ]\t\t}\t\t\t],\t"description": "Enhances Salesforce formulas with syntax highlighting, autocomplete, formatting, field analysis, and syntax checking.",\t"name": "Salesforce.com Enhanced Formula Editor",\t"version": "2.6.1",\t"options_page": "options.html",\t"background": {\t\t"service_worker": "background.js"\t},\t"permissions": ["storage"]}
Read more

Similar Extensions

icon

Salesforce Lightning Inspector Extension · Developer Tools 6,000+ 48 ★ 8.72MiB

icon

Salesforce Tool Suite Extension · Developer Tools 6,000+ 103 ★ 4.66MiB

icon

Salesforce advanced Code searcher Extension · Developer Tools 6,000+ 183 ★ 21.36MiB

icon

ORGanizer for Salesforce Extension · Developer Tools 6,000+ 244 ★ 1.44MiB

icon

Salesforce Change Set Helper Extension · Productivity 6,000+ 59 ★ 1.51MiB

icon

Salesforce Colored Favicons Extension · Productivity 6,000+ 97 ★ 13.41KiB

icon

Salesforce Admin Check All Extension · Productivity 6,000+ 75 ★ 40.4KiB

icon

Salesforce DevTools Extension · Developer Tools 6,000+ 48 ★ 4.6MiB

icon

Salesforce Inspector Reloaded Extension · Developer Tools 6,000+ 153 ★ 1.01MiB

icon

Salesforce Searchbox Extension · Developer Tools 6,000+ 16 ★ 36.98KiB

icon

Boostr for Salesforce Extension · Productivity 6,000+ 34 ★ 1.17MiB

icon

CRM Science - Admin Assistant Extension · Productivity 6,000+ 7 ★ 624KiB

icon

Salesforce.com Quick Login As Extension · Developer Tools 6,000+ 41 ★ 49.94KiB

icon

Record and Metadata Comparator for Salesforce Extension · Productivity 6,000+ 39 ★ 65.29KiB

icon

Salesforce.com Id Clipper Extension · Productivity 6,000+ 38 ★ 54.81KiB

icon

Salesforce inspector Extension · Developer Tools 6,000+ 330 ★ 422KiB

icon

Salesforce Show Api Name Extension · Developer Tools 6,000+ 26 ★ 13.77KiB

icon

Salesforce Navigator for Lightning Extension · Productivity 6,000+ 22 ★ 253KiB

icon

Salesforce Simplified Extension · Developer Tools 6,000+ 46 ★ 609KiB

icon

Why Salesforce Extension · Developer Tools 6,000+ 38 ★ 253KiB

icon

Org Header for Salesforce® Extension · Developer Tools 6,000+ 15 ★ 14.58KiB

icon

SOQL Extractor and Analyzer for SalesForce Extension · Productivity 6,000+ 16 ★ 56.25KiB

icon

Force.com LOGINS Extension · Productivity 6,000+ 188 ★ 459KiB

icon

EasyCrud(Salesforce) Extension · Developer Tools 6,000+ 26 ★ 8.11MiB

User reviews

icon

J S (ID: 000000eb7ed228fc) Voted 4 ★ - Updated 10/17/2022 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?

icon

M B (ID: 0000006ef8fd35aa) Voted 5 ★ - Updated 09/14/2022 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.

icon

Adrian Zgoda (ID: 000000583f5b18c5) Voted 4 ★ - Updated 08/05/2022 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!

icon

Hien Ferber (ID: 000000def5b24b5a) Voted 5 ★ - Updated 08/03/2022 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!

icon

April Barclay (ID: 0000002702204710) Voted 5 ★ - Updated 04/26/2022 This extension is the bees knees for formula editing. Showing the matching parentheses is key and makes reading formulas much easier.