#4.29 / 59 rate

Salesforce.com Enhanced Formula Editor

6,000 users

2020-07-02

https://www.enhancedfo...

kyle.p.developer@gmail...

https://www.enhancedfo...

Extension Information

5 star

66%

4 star

13%

3 star

2 star

1 star

Supported Languages

Permissions

Description

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

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.

Reviews

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

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?

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.