[BetterRed]

Originally Posted by chaley

@BetterRed: fundamental problem. Apparently you checked the "Contains Names" box for the tags-like columns, making the item separator an ampersand instead of a comma. This option does not exist for composite columns. Their separator is always a comma. Your template must take that into account.

Something like the following will give you a comma-separated list of authors in the composite column. To avoid unhappiness when resplitting the column later to make tag browser entries, I turn first all commas in names into semicolons. You would need to change the parameters to the field function to be your column lookup names.

program: 
	l1  = re(field('#people'), ',', ';');
	l2  = re(field('authors'),  ',', ';');
	list_union(
		re(l1, '&', ','),
		re(l2, '&', ','),
		','
		)

chaley - at least I was on the right track with list_union

I unchecked Contains Names on the two source columns and put the following into the Collaborator template - voila it works

program:list_union(field('#dramaturg'),field('#translators'), ',')

I did that because the Custom Column dialogue only gives me one line for the template!

I've since read that if I double click on a Composite cell value I get the Edit Template dialogue. Which assumes the Composite column is shown in the spreadsheet, and in this case it isn't - seems a bit 'odd' - but I can overcome with a Collaborators View

I found the Tweak for rearranging the Tag Browser - I can't recall how many times I've wished for something and then been able to find it, more often that not right where I would expect to find it

BR