I have a library of comic books and graphic novels. I have created custom columns for all of the various artists that may be involved (Artist, Penciller, Inker, Colorist, Letterer, Cover) and am trying to create a different custom column (Art) that will take all of those columns and make one list of everyone involved in art for the comic.
I have figured out how to pull all the columns into Art:
Code:
{#artist}{#pencil:| & |}{#ink:| & |}{#color:| & |}{#letter:| & |}{#cover:| & |}
However, if there are multiple people in any one category, they are treated as one. I tried to use the "sublist" function, but it doesn't work the way I thought it did (never did manage to get it to actually separate items in the Art column). Also, if one artist fills more than one role, they'd be repeated in Art, which is less than ideal. And the separators aren't perfect, since if some but not all of the sub-columns are filled in, extra separators are likely to appear.
I think there's probably a better way to be doing what I'm doing, so I came here for help.