Can someone suggest a calculation or script to concatenate text of multiple records into one string in a single field.

I need to concatenate the description field of all records with the same Year_OrderNumber in a single field.

I attach a sample

Thanks for your support

Test.fmp12

6 minutes ago, anteas1998 said:

concatenate the description field of all records with the same Year_OrderNumber

Sort your records by Year_OrderNumber. Place a summary field defined as List of [ Description ] in a sub-summary by Year_OrderNumber part. This will show all descriptions of the Year_OrderNumber as a return-separated list. If you want another separator, add a calculation field such as =

Substitute ( GetSummary ( sListOfDescriptions ; Year_OrderNumber ) ; ¶ ; ", " )