Brian Dunning's FileMaker Custom Functions

evaluateAsNeeded ( value )

Evaluate calcs in number fields

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

Jonathan Fletcher   Jonathan Fletcher
Fletcher Data Consulting

Share on Facebook Share on Twitter

  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   unix, Japan
Jul 14, 2016
Is there a reason to use case() ?

Set auto-enter calculation as
Evaluate ( GetAsText ( self ) )
 
Jonathan Fletcher   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?
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.