GetSelectionƒ ( _fieldName ; _recordCount )

Akin to SelectionToArray in other programs, returns all values of a specified field from a given count of found records.

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

Michael Rhodes
Allied Data Service
http://allieddataservice.com

Sample input:

GetSelectionƒ ( "id", get ( foundcount ) )

Sample output:

"1¶2¶3¶4¶"

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

/*
  Created by Michael Rhodes
  mike@allieddataservice.com
  updated 2017-03-17

  This function is deprecated with the faster performing and non-recursive List option for summary fields.
*/

If (
  _recordCount > 1 ;
  GetSelection ( _fieldName; _recordCount - 1 )
)
& If (
  _recordCount > 0 and GetAsNumber ( _recordCount ) ≤ Get ( FoundCount ) ;
  Let (
    _fieldContents = GetNthRecord ( GetField ( fieldName ) ; _recordCount ) ;
    If (
      not IsEmpty ( _fieldContents ) ;
      _fieldContents &¶
    )
  )
)

Recursive. Only use on fewer than 1,000 records.

Mimics list option in Summary field. Useful for older version of FileMaker.

Comments

		Grubber, UK Apr 27, 2009
Thanks but doesn't seem to work?. Returns list of question marks? Tried returning list to Global Var, Global Field and standard text field? WinXP/ FMA10.

		Grubber, UK Apr 27, 2009
Opps, my mistake. Didn't spot it needs quotes around the field-name. Thanks. very useful.

		Michael Rhodes, Colorado Springs, USA Mar 17, 2017
Fixed long-standing error with this function in that _recordCount needs to be converted to numeric value when comparing to FoundCount, lest â‰¤ be based on alphanumeric value. The new'ish list option in Summary fields makes this function unnecessary.

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

GetSelectionƒ ( _fieldName ; _recordCount )

Comments

Support this website.

Support this website.