MobileRead Forums - View Single Post - column from other columns with hierarchy and names

DBorG · 10-01-2018, 03:23 PM

I created several custom columns that i use for my comics collection.
Like #letterers, #illustrators, #colorists.
Now I am trying to create column #artists that will contain all those
columns sorted hierarchically by occupation.
Closest I got was with the template:
illustrators.{#illustrators}, colorists.{#colorists}, letterers.{#letterers}
this way it creates hierarchy, but I end up with two problems.

All entries that does not have entry in these columns are still in artists column under illustrators. or colorists. or letterers. How to not include such entries?

Second problem is if my custom columns have more that one name. The #artists column counts all the names as one entry.

Tried several versions of in_list() but can't figure the right formula.

Would appreciate any help I can get.

10-01-2018, 03:23 PM	#1
DBorG Member Posts: 11 Karma: 10 Join Date: Jul 2015 Device: Android tablet	column from other columns with hierarchy and names I created several custom columns that i use for my comics collection. Like #letterers, #illustrators, #colorists. Now I am trying to create column #artists that will contain all those columns sorted hierarchically by occupation. Closest I got was with the template: illustrators.{#illustrators}, colorists.{#colorists}, letterers.{#letterers} this way it creates hierarchy, but I end up with two problems. All entries that does not have entry in these columns are still in artists column under illustrators. or colorists. or letterers. How to not include such entries? Second problem is if my custom columns have more that one name. The #artists column counts all the names as one entry. Tried several versions of in_list() but can't figure the right formula. Would appreciate any help I can get.