This extension enhances Anaplan formula editing in several ways; providing code completion, hover info and validity checks.

Latest Version

Version
3.0.6
Update
March 14, 2023
Size
1.36MiB
Developer
Category
Users
625
Rating
4.75 ★
Manifest Version
3
Web Store Status
Languages Support
English
See more
Permissions
See more

Better Formula Editor for Anaplan Extension

Works best with the 'new model experience', but can work with the old/current.

Formula Validation: Various checks are performed on formulas including simple things like ensuring all entities are named / referenced correctly or ensuring the correct data types are used throughout the formula, through to things like checking for dimension miss-matches when referring to line items with different dimensions.

Formula Formatting: Provides basic formatting for valid formulas; breaking up IF...THEN....ELSE onto multiple lines with proper indentation.

Hover Information: You can hover your mouse over most elements of a formula to get contextual information, for example hovering over line items shows their dimensions and data type and hovering over function names to get information about that function.

Code Completion: As you are typing the editor will offer auto-complete suggestions for things like line items within the current module, fully qualified line items within other modules, function names etc. As well as that, where you reference a line item with differing dimensions to the current modules dimensions it can auto-complete the required LOOKUPs or SUMs needed based on what you've used elsewhere.

Quick Fixes: When errors are encountered the extension will allow the user to choose an appropriate fix from a menu which when chosen would make the required changes to the formula automatically.

Function Information: When completing functions with parentheses you get popup contextual information relating to the parameters of the function together with an explanation of both the function and the parameters. You also get parameter type checking, and if the given parameter expects a keyword, these get auto-completed.

Shortcuts: Standard Monaco editor shortcuts apply. Ctrl-Space; Open code completion. Ctrl-Shift-Space; Open function info (when within function parentheses). Shift-Alt-F for formatting.

I welcome ideas for future enhancements; this is very much in active development. If you would like to sponsor me, you can do so here: https://github.com/sponsors/georgeduckett There are various tiers available with a variation of benefits.
Read more

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx",\t"manifest_version": 3,\t"name": "Better Formula Editor for Anaplan",\t"version": "3.0.6",\t"description": "This extension enhances Anaplan formula editing in several ways; providing code completion, hover info and validity checks.",\t"icons": {\t\t"128": "logo.drawio.png"\t},\t"content_scripts": [\t\t{\t\t\t"matches": [\t\t\t\t"https://*.app.anaplan.com/*"\t\t\t],\t\t\t"js": [\t\t\t\t"/bin/content-script.js"\t\t\t],\t\t\t"run_at": "document_end",\t\t\t"all_frames": true\t\t}\t],\t"host_permissions": [\t\t"https://*.app.anaplan.com/*/anaplan/*",\t\t"https://*.app.anaplan.com/a/modeling/*"\t],\t"web_accessible_resources": [\t\t{\t\t\t"resources": [\t\t\t\t"bin/*"\t\t\t],\t\t\t"matches": [\t\t\t\t""\t\t\t]\t\t}\t]}
Read more

Similar Extensions

icon

Bunpro Review Notifier Extension · Fun 625 3 ★ 31.87KiB

icon

Live Reload Browser Page (Pro) Extension · Developer Tools 625 1 ★ 3.83MiB

icon

Improved Anaplan Extension · Developer Tools 625 16 ★ 60.37KiB

icon

Elon Be Gone Extension · Productivity 625 2 ★ 252KiB

icon

Better Anaplan by Atkan Extension · Accessibility 625 0 ★ 5.63KiB

icon

BetterCacher Extension · Productivity 625 0 ★ 60.67KiB

icon

Glints TalentRadar Extension · Productivity 625 0 ★ 105KiB

icon

Anaplan Formulator Extension · Productivity 625 5 ★ 72.64KiB

icon

Probability Toolkit Extension · Productivity 625 4 ★ 63.07KiB

icon

CSS Injector Extension · Developer Tools 625 0 ★ 2.85MiB

icon

Safer Send Button Extension · Social & Communication 625 0 ★ 99.29KiB

icon

Feedly Star Opener Extension · Productivity 625 3 ★ 52.94KiB

icon

DemoMonkey Extension · Developer Tools 625 7 ★ 1.36MiB

icon

Traction Guest Extension · Productivity 625 1 ★ 60.52KiB

icon

Reddit FRANK Detector Extension · Social & Communication 625 2 ★ 48.7KiB

icon

Anti FeR toolkit Extension · Fun 625 3 ★ 85.54KiB

icon

CSS Brio Pro Extension · Developer Tools 625 3 ★ 308KiB

icon

Better OLWLG Extension · Accessibility 625 0 ★ 272KiB

icon

Feedbin Notifier Extension · Productivity 625 3 ★ 16.44KiB

icon

Tiny Tiny RSS Open in Background Tab Extension · Productivity 625 4 ★ 30.81KiB

icon

Sort My Classes Extension · Productivity 625 2 ★ 910KiB

icon

Snap Environment Switcher Extension · Developer Tools 625 16 ★ 208KiB

icon

Polygonscan Quick Extension · Productivity 625 0 ★ 12.28KiB

icon

WCL Ranked Buff Remover Extension · Fun 625 3 ★ 1.15MiB

User reviews

icon

Shubham Chaudhary (ID: 0000006f31d6cc50) Voted 4 ★ - Updated 09/21/2022 I have just started using it. I like the extension. I'll update my experience and suggestions here after some days. Thanks George for the extension.

icon

Pandji Mahardika (ID: 000000b607bd6b99) Voted 5 ★ - Updated 01/26/2022 Nice working, very usefull