Calc Fields "on the fly"

Classic Servoy
1

Hi:

I’m thinking about creating a solution for our employees where they can see the records of our DB. Ok, it’s very easy :D
But they want to create calculations (as in Excel, or in FM with calc fields), but I don’t know how to do it. Any ideas?

Thanks!

2

In Servoy 6 you can create calculations via the SolutionModel.
That might be the way to go (when 6 is released).

Hope this helps

3

Ok, but how could the users enter the calculation formula?

4

That is of course for you, as the developer of the solution, to decide.
You can give them a plain text area or you give them some point and click interface of the objects they can use (think Calc editor in FMPro). Or anything in between.
In the end it’s just javascript code that you need to pass to the JSCalculation object.

5

ROCLASI:
You can give them a plain text area or you give them some point and click interface of the objects they can use (think Calc editor in FMPro).

Thanks, I’m thinking about and interface similar to that.