# evaluateAsNeeded ( value )

Evaluate calcs in number fields

Average rating: 4.2 (22 votes) Log in to vote

Jonathan Fletcher Fletcher Data Consulting |

Sample input:

sqrt ( 9 )

Sample output:

3

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Number field calculation using any entered FileMaker function or sign.

## Comments

unix, Japan Jul 14, 2016 |
||

Is there a reason to use case() ? Set auto-enter calculation as Evaluate ( GetAsText ( self ) ) |
||

Jonathan Fletcher, Fletcher Data Consulting Jul 14, 2016 |
||

I wanted it to pass through the number when it's a number and process the calculation only when there are characters other than numbers. How does your Evaluate approach handle simply numbers? Do you think I was overthinking the solution? | ||

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.