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
在α很有年代ome 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:
Highlight data type errors:
Missing dimension warnings:
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.
Solved!Go to Solution.
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-Ext...
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-Ext...