Improved Formula Editor/Bar

Improved Formula Editor/Bar

If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier!

  1. Colour coded statements and keywords (e.g. IF THEN ELSE, line items, constants)
  2. Ability to indent and enter new lines. Particularly useful for IF statements
  3. Keyword autocompletion
  4. Ability to add inline comments into formulae as in virtually all programming languages

I'm pretty sure that keyword autocompletion has been created already as an idea, however I have included this for completion.

11 Comments
JaredDolich
Moderator

One upvote from me.

@Nicolas Cadier not sure if you knew about A+. It's a Google add-in for Anaplan that has these features and more.

Please note though, It's not supported by Anaplan and I can't vouch for the security. It also only works on the browser you add it to.

You might take a look at use this as a basis to develop your idea.

https://chrome.google.com/webstore/detail/a%2B-for-anaplan-model-buil/najhicgfojolaebaoccdbopmobcdhp...

 

 

Nicolas Cadier
Certified Master Anaplanner

@JaredDolich 

A+ is something that I'm very much interested in! However, due to the fact that the extension is not supported and therefore potentially insecure, as you say, unfortunately makes it too much of a risk to use in development. 

Miran
Super Contributor
 
Status changed to: Your support is needed
JoeAnderson
Occasional Contributor

I would also like to see this implemented. I currently use the A+ extension but would rather see this as native functionality.

 

I'd like to add to another item to your 3 in the initial post.

 

iv. Ability to add inline comments into formulas as in virtually all programming languages

 

This would be a huge enhancement to readability of complex formulas and for maintenance.

Nicolas Cadier
Certified Master Anaplanner

@JoeAnderson I like this idea! I've added into the list of ideas.

vicky_ascencio
Occasional Contributor
 
Status changed to: Considered for Future Roadmap
wwood
Occasional Contributor

Another vote for this functionality, due to the insecurity of the A+ extension.

wwood
Occasional Contributor

Another vote for this.

AndrewS
New Contributor

Plus one vote, particularly for:

    ii. Ability to indent and enter new lines. Particularly useful for IF statements

 

GeorgeDuckett
Regular Contributor

FYI I've created an open source extension that enhances the formula functionality in the new model building experience in various ways (code completion, syntax/semantic checking, info hovering etc. I've made a post about it here: https://community.anaplan.com/t5/Anaplan-Platform/Better-Formula-Editor-for-Anaplan-A-new-Chrome-Fir... 

harri.granqvist
New Contributor

Points 2 and 4 very important for longer formulas. Actually with NUX you may add line changes to code but when saved, formatting disappears.