kallehval

Comma separeted list in a field?

Discussion created by kallehval on Aug 30, 2012
Latest reply on Sep 2, 2012 by beverly

Hi FileMaker ninjas

 

Is it possible to make a comma seperated list in a field based on another field.

This is for a songbook, where I need to list the writer, and a commasepareted list of all the songnumbers he has written.

Also... between the 2 last entries in the list, there should be an "&"

ehm... also... they should be sorted nummeric

 

Example records

Field 1 - Field 2

Peter Jackson - 452

Tom Sawyer - 987

Peter Jackson - 123

Peter Jackseon - 985

Peter Jackson - 98

 

Result:

Field 1 - New calculation field

Peter jackson - 98, 123, 452 & 985

Tom Sawyer - 987

 

Can this be done?

 

Thanks in advance...

 

Kasper

Outcomes