A Chrome extension to enhance the formula editor

I've released the first, very much alpha, version of my chrome extension that adds various functionalities to the formula editor.

https://chrome.google.com/webstore/detail/better-formula-editor-for/lonibgccfehnjjhchfcbdhkaajhobeak

 

It's very much in alpha as there are some known limitations / quirks, but currently it highlights syntax errors, missing dimension errors, incompatible line item / formula data types and allows you to hover over a line item to see it's data type and dimensions. A couple of examples of how it looks below.

Hover to see dimensions:

GeorgeDuckett_0-1635782077710.png

 

Highlight data type errors:

GeorgeDuckett_1-1635782077650.png

 

Missing dimension warnings:

GeorgeDuckett_2-1635782077631.png

 

All the above are far from perfect; some of the error messages could be better but are a very basic first step. I'm also working on being able to hover over more things with data types (list items, list item properties, functions etc, not just line items), as well as things like function names to get the parameters etc.

Context-aware customised auto-complete for lineitem names / functions / module names etc is also on the list.

 

I'd be very interested in any feedback anyone has.

Comments

  • Is it going to replace A+ chrome extension ?
  • Possibly the formula editing enhancements it does, yes, although I've got lots of testing / enhancements to do. I've focused on utilizing a better editor engine (the one Anaplan are moving to; Monaco) to be able to provide things only really possible by parsing the formula being edited and integrating with Monaco's extendable functionality.
  • Wow nice work... I like how it tries to offer solutions too where you might be missing mappings.

    My main resistance to the new modelling experience is formula indentation. If you can crack that and I'll move over to the new experience with your add-in!
  • Thanks for the feedback. I'm currently planning on adding even better missing mappings support where it tries to add them for you with auto-complete based on your existing mappings (i.e. working out you use line items on PROP ... modules typically).


    Re. formula formatting, you mean currently you have this on the current formula editor (with A+ I assume), but with the new experience you don't?
    I read somewhere that formula formatting was something on Anaplan's roadmap, so I've not put that in as a feature of my extension.

  • I've polished and added enough features to reach v1. I've made a comprehensive post in the main forums detailing all current features, with a video demoing them here: https://community.anaplan.com/t5/Anaplan-Platform/Better-Formula-Editor-for-Anaplan-A-new-Chrome-Extension/m-p/128250

  • FYI The extension now includes the option to format/indent a valid formula; I decided not to wait for Anaplan to put formula formatting/indentation into their editor. Any issues / thoughts for further enhancements please let me know!

Categories