Brian Dunning's FileMaker Custom Functions

maxLength ( lst ; maximum )

Function that returns the length of the longest value in a list. Useful for conditional formatting

  Average rating: 4.0 (38 votes) Log in to vote

Nicolas Bourré   Nicolas Bourré
http://Www.nicolasbourre.com

Share on Facebook Share on Twitter

  Sample input:
maxLength ("apple¶brocoli¶potato"; 0)
  Sample output:
7

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

Function that returns the length of the longest value in a list. This function could also be used to get the longest line in a text.

Could be useful for conditional formatting based on the longest line in a text field.

 

Comments

KevinSmith   KevinSmith
Sep 12, 2018
The code is missing a bracket character. The first line of code should read "Let (".
 
Nicolas Bourré   Nicolas Bourré
Sep 12, 2018
Corrected thanks!
 

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.