Brian Dunning's FileMaker Custom Functions

Get_IndexAndCount ( TableName ; FieldName ; RecordSeparator )

Uses SQL to return List of counts & unique values on a field

  Average rating: 4.4 (12 votes) Log in to vote

Chris Belanger   Chris Belanger
Innovative Solutions

Share on Facebook Share on Twitter

  Sample input:
Get_IndexAndCount ( "Contacts" ; "LastName" ; "¶" )
  Sample output:
10Anderson¶
8Clayton¶
11Donaldson¶
3Franklin¶

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

PURPOSE: Determine count & unique values for a field
Uses SQL query, so is quite fast

Result Format:
COUNT VALUE
If you use ¶ as the RecordSeparator, this creates a value list

 

Comments

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.