Brian Dunning's FileMaker Custom Functions

suffixPlural ( theNumber )

Given any number, this function returns the letter "s" if the number is equal to 1, otherwise nothing is returned.

  Average rating: 3.9 (31 votes) Log in to vote

Michael Richards   Michael Richards

Share on Facebook Share on Twitter

  Sample input:
suffixPlural ( -1 )
suffixPlural ( 0 )
suffixPlural ( 0.5 )
suffixPlural ( 1 )
suffixPlural ( 2 )
  Sample output:


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

Consider using a quantity field in an invoicing situation. The invoice provides improved human readability if the units display the plural "s" where appropriate.

For example:
0 hours
1 hour
1.5 hours



Log in to post comments.


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

Under construction. Email me your wish list for improvements.