array.cellValueByColTitle ( array ; rowName ; column ; delimiter ; useTitle )
A function to return the cell value from an array by specifying the row name and column title
Average rating: 4.4 (36 votes) Log in to vote
Tim Anderson Group
array.cellValueByColTitle ( array ; "row3" ; 1 ; "§";0 )
where array is
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
A function to return the cell value from an array by specifying the row name and column title. Row names must be unique or only the first occurrance will be returned.
A more complex version of array.cellValueByColNum, this gives you the option to specify column Titles (headers) rather than by number. However you can also specify the column number (the row name is zero) as long as you set useTitle to 0.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.