Brian Dunning's FileMaker Custom Functions

MultiValue_To_ReportLine ( Text_Field )

converts list to readable sentence

  Average rating: 4.7 (25 votes) Log in to vote

Robert Schaub   Robert Schaub
Robert Schaub

Share on Facebook Share on Twitter

  Sample input:
New York Yankees
New York Jets
Norwich University Cadets
  Sample output:
New York Yankees, New York Jets And Norwich University Cadets

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

Removes carriage returns and inserts a comma between values. In between last two values inserts the word and rather than a comma



Super   Super, Malaysia
May 11, 2013

There is an error.
Need to replace 'parent::field 1' with Text_Field

Otherwise, works great


Log in to post comments.


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

Under construction. Email me your wish list for improvements.