Comma Separated Related Values

[3guk]

Hey Guys,

 

I've using a checkbox set to assign people to an event, but the checkbox set is displaying Full Names and actually storing contactIDs.

 

What calculation would I need to display these full names separated by commas ?

 

I'm currently using Substitute ( id_contact ; ¶ ; ", " ) which gives me "C004, C007, C0991 etc..." what I'd really like is to be able to instead have "Name1, Name2, Name3..."

 

I'm sure it's just a case of using a slightly more complicated calculation but I can't work it out

 

James

 

 

[comment]

Assuming you have a relationship to the Contacts table based on the checkbox field, you can get the list of names from the Contacts table itself (they are not anywhere else - and that's a good thing). Try =

Substitute ( List ( Contacts::Name ) ; ¶ ; ", " )

--

Note: using a checkbox to assign contacts to an event  will work - but it is extremely limited. For example, you cannot record anything specific to an individual assignment, such as RSVP.  Reporting contacts by event is also impossible. Consider using a join table instead.