Evaluating math expressions in field

[seabreezefarm]

I'm looking to create a field in an invoice solution that will parse and evaluate math expressions on the fly. For example, I would like to be able to enter in the "Quantity" field, an expression such as 19+123, or 37.56/7, and have the field automagically convert it to the appropriate result. Any ideas on how to do this? Is there a custom function or plug in for this?

Thanks much,

George Page

seabreezefarm.net

[comment]

You could use the Evaluate() function for this. However, you need to provide for user entering a non-valid expression.

[seabreezefarm]

You could use the Evaluate() function for this. However, you need to provide for user entering a non-valid expression.

Nice! That works great. Is there a generic provision for evaluating the non-valid expressions?

[comment]

See;

http://www.filemaker.com/11help/html/func_ref3.33.14.html#1028187

http://www.filemaker.com/11help/html/func_ref3.33.5.html#1027784

[FMPierce]

I'm making a DB that you can put a formula into and it will evaluate it, the only problem was I did'nt have any way to see if it was valid this helped a lot.

:thankyou2:

[bcooney]

Automatic message

This topic has been moved from "Database Schema & Business Logic → Custom Functions" to "Database Schema & Business Logic → Calculation Engine (Define Fields)".