Basically these 4 columns manipulate shelves and tags. In tags I have 102 items, shelves about 118. That's why I created these other columns to make it neater. I categorize all items in tags and shelves into a few categories:
genre (40 items),
character (58 items),
mode (22 items),
and whatever is left (84 items).
GENRE:
Code:
program:
list_union(
list_intersection(field('tags'), '40 tags&shelves listed', ','),
list_intersection(field('#shelf'), '40 tags&shelves listed', ','),
',')
CHARACTER:
Code:
the same as above just different tags,shelves listed. Total 58 items
MODE:
Code:
the same as above just different tags,shelves listed. Total 22 items
LEFTOVERS

:
Code:
program:
list_sort(
list_difference(
list_union(field('#shelf'), field('tags'), ','),
list_union(
"delete",
strcat(field('#genre'), ',',
field('#mode'), ',',
field('#character'), ',',
field('#length')),
','),
','),
0, ',')
I just changed this one to, #length wasn't needed here, only word Short:
Code:
program:
list_sort(
list_difference(
list_union(field('#shelf'), field('tags'), ','),
list_union(strcat('Short', ',',
'delete'),
strcat(field('#genre'), ',',
field('#mode'), ',',
field('#character')),
','),
','),
0, ',')
And I have a few more columns like tags but they are simple columns.
Length has 4 values, status-6,managing-22, anthology-18 and a few more. But nothing major and with very few values.