How to check correctness of formulas?

Answered
Oleg asked on June 28, 2021

I can't find info about calculated values syntax correctness checker. For example, user can add formula like this -> sum("price""""") . And flexmonster will not show errors. Our app needs this functionality, because fields inside formulas can be outdated and we need to show user attention popup like  "please, delete this fields from your calculated values". And if user enter wrong syntax fields it will work incorrect and popup will show something like -> please delete field "/ sum (". We get calculated fields from formulas with regexp which gets values inside this symbols -> (" ")

1 answer

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 30, 2021

Hi Oleg,
 
Thank you for posting your question.
 
We are aware of such formula validation issues – we already have this in our backlog and will make sure to inform you if anything changes on the matter.
 
Please let us know if there is anything else we can help you with in the meantime.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer