View Single Post
Old 06-21-2019, 01:46 PM   #1
Vaesse
Zealot
Vaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolateVaesse is generous with chocolate
 
Vaesse's Avatar
 
Posts: 107
Karma: 33020
Join Date: May 2011
Device: Kindle Paperwhite
Exclamation Merged Custom Column of Names

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.
Vaesse is offline   Reply With Quote