Brian Dunning's FileMaker Custom Functions

Get_Index ( TableName ; FieldName ; RecordSeparator )

Use SQL to obtain a sorted "Index" [ValueList] on a Field

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

Chris Belanger   Chris Belanger
Innovative Solutions

Share on Facebook Share on Twitter

  Sample input:
Get_Index ( "Company" ; "City" ; "¶")
  Sample output:

Calgary
Edmonton
Ponoka
Red Deer

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

Parameters: TableName ; FieldName ; RecordSeparator [all TEXT]

Purpose: To instantly obtain a sorted "Index" of the values contained in TableName::FieldName

Uses a simple SQL query so it is VERY FAST!

I created this because I am analyzing a FMP solution that I need to replace, and it has lots of wonky data.

If you use a ¶ as a record separator, this creates a value list.
Could be modified to take input in FileMaker form such as TABLE::FIELDNAME instead. The function would just need to separate the Table & FieldName prior to the query.

 

Comments

Alex   Alex, Marienburg (DE)
Jun 30, 2018
I love the function, thank you so much.
 

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.