FoundSet_List ( field, isUniqueList )

Create a List or a Unique List of values from one field from the found set of records.

Average rating: 5.0 (1 vote) Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

FoundSet_List ( Contacts::nameFirst, 1 )

Sample output:

James
John
Judy
Kyle
Michael

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

/*
Author:  		Kyle Williams
CreatedDate:	9/24/2019
Updated:		5/21/2025 to use the While function
Purpose: 		To pull all values (or unique values) of one field from the current found set
Dependencies: 	None
*/

While ([
        _field = field;
        _isUniqueList = isUniqueList;
        _foundCount = Get ( FoundCount );
        _loopCount = 1;
        _resultList = ""
    ];

    _loopCount <= _foundCount

    ;[
        _currentValue = GetNthRecord ( _field ; _loopCount );
        _resultList = If (
            IsEmpty ( _currentValue );
            _resultList;
            If (
                IsEmpty ( _resultList );
                _currentValue;
                _resultList & ¶ & _currentValue
            )
        );
        _loopCount = _loopCount + 1
    ];

    // Final result processing after the loop
    Let (
        [
            _finalList = If ( _isUniqueList ; UniqueValues ( _resultList ) ; _resultList );
            _finalList = If ( _isUniqueList ; SortValues ( _finalList ) ; _finalList );
            _finalList = If ( _isUniqueList and Left ( _finalList ; 1 ) = ¶ ; Right ( _finalList ; Length ( _finalList ) - 1 ) ; _finalList )
        ];
        _finalList
    )
)

Create either a List or a Unique List of values by referencing one field from the found set of records.
NOTE: Founds sets of 10,000 or more records may take a long time to complete...

Comments

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

FoundSet_List ( field, isUniqueList )

Comments

Support this website.

Support this website.