created a column built from other columns, behaves like tags. I'm not great at code, but so far I have:
Code:
program:
if (ifempty(field('#chars'), ''))
then list_union(field('#chars'),(first_non_empty(field('#universe'), field('series'), field('title'))), '.') fi
Its almost correct except I cant figure out how to make it apply the part starting with (first_non_empty) to item with the possible list that is (chars). The end goal is, I can type main characters names into (chars) and calibre will automagically put the highest level category followed by a '.' followed by each char name into the charsort column. The above catches the first category and populates correctly, all the rest of the chars are just the name itself.
goal would be: universe.char1, universe.char2, etc
What am I missing? Or is it not possible?
Any help would be appreciated