explain one of the column types

[Fynjisx]

in the list of allowed column types is "a column composed of others and acting as tags". In what cases can it be applied? Example please

[BetterRed]

Shows virtual libraries in which a book appears.

BR

[ownedbycats]

This template will display hierarchical tags as separate items and remove any duplicate items. Nonfiction.Biographies, Nonfiction.Music will become Nonfiction, Biographies, Music.

program: 

split_tags = re($tags, '\.', ',');
list_join(',', split_tags, ',')

This additionally sorts the entries—the above example will become Biographies, Music, Nonfiction.

program: 

split_tags = re($tags, '\.', ',');
list_sort(list_join(',', split_tags, ','), 0, ',')

[Lys]

Originally Posted by ownedbycats

This template will display hierarchical tags as separate items and remove any duplicate items.

To remove duplicates, I'm using this code (#genre is my custom hierarchical column):

list_remove_duplicates(re($#genre, '\.', ','), ',')

But I'm not sure if there's any setback in using list_remove_duplicates function instead of yours


Back to OP question, I'm also using a composite column to set the reading status (Reading, DNF, Finished) from the reading % returned from KoboUtilities plugin:

{#percent_read:'cmp($, 100, cmp($, 0, 'DNF', '', 'Reading'), 'Finished', '')'}

[ownedbycats]

Oops, I forgot about list_remove_duplicates

[Fynjisx]

Originally Posted by Lys

Back to OP question, I'm also using a composite column to set the reading status (Reading, DNF, Finished) from the reading % returned from KoboUtilities plugin:

{#percent_read:'cmp($, 100, cmp($, 0, 'DNF', '', 'Reading'), 'Finished', '')'}

can you elaborate on how it works?

[Fynjisx]

Originally Posted by BetterRed

Attachment 198602
Shows virtual libraries in which a book appears.
BR

what else?

[BetterRed]

Originally Posted by Fynjisx

what else?

what else would you expect

BR

[Lys]

Originally Posted by Fynjisx

can you elaborate on how it works?

With the usual caveat that I'm in no way a template language expert and I got the basis of that template thanks to other members here on MR:

#percent_read is the column where I store the % and it's referred inside the formula as $
cmp(x, y, lt, eq, gt) is a the function that compares x to y (after converting them to number) and returns lt value if x<y, eq value if x=y, and gt value if x>y

My formula basically means: compare the percent read column value ($) to 100.

#percent_read:'cmp($, 100,

If the percent read is minor to 100, compare again its value to 0 and if it's minor to 0 set the column value as "DNF", if it's equal to 0 leave it blank, if it's greater to 0 set it as "Reading".

cmp($, 0, 'DNF', '', 'Reading')

if the first comparison to 100 returns "equal", set the value of the composite column as "Finished". If it's greater than 100 leave it blank.

[Fynjisx]

Originally Posted by BetterRed

what else would you expect

BR

Ah only sake of virtual libraries that-whether?

[Fynjisx]

Originally Posted by Lys

#percent_read is the column where I store the %

where do you get the percentage? Do you enter by hand?

[Lys]

Originally Posted by Fynjisx

where do you get the percentage? Do you enter by hand?

As I wrote in my first post:

Back to OP question, I'm also using a composite column to set the reading status (Reading, DNF, Finished) from the reading % returned from KoboUtilities plugin

If you have a Kobo, refer to the late davidfor's thread in the plugins forum.

If you don't have a Kobo, either enter the % manually or check if there are similar plugins for other devices (I've no idea if they exist).