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 - Show more from this author
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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: