Brian Dunning's FileMaker Custom Functions

fd_ValueList ( Field )

Creates a valuelist from a field of the current found set

  Be the first to rate this function Log in to vote

flusheDData   flusheDData - Show more from this author
n/a
http://www.udias.com

Share on Facebook Share on Twitter

  Sample input:
fd_ValueLIst ( MyTable::MyField )
where
MyField has
Alpha in the first record
Bravo in the second record
Charlie in the third record
  Sample output:
Alpha
Bravo
Charlie

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

This tail recursive function creates a value list (unique values) from a given field of the current found set.
Pleasse note that this tail recursive function is limited to 40000 values.
The values order is the one of the current found set.

 

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 18 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: