Using templates for file names, plugboards, composite columns, searches, tooltips

[Reader4106]

Thank you for your answer chaley

First I should say, I have absolutely no talent for programming (unfortunately).

If #genre_rg is a "column built from other columns then you fill it in using "subitems()" function in a template to select the second and third values from a hierarchy.

Yes, it's a "column built from other columns."
I tried to get help from ChatGPT, but we couldn't get that to work either.

I would appreciate any help.

[chaley]

Originally Posted by Reader4106

Thank you for your answer chaley

First I should say, I have absolutely no talent for programming (unfortunately).



Yes, it's a "column built from other columns."
I tried to get help from ChatGPT, but we couldn't get that to work either.

I would appreciate any help.

Use this template for the column "#genre_rg":

{#genre:subitems(1,3)}

or

program:
	subitems($#genre, 1,3)

The second is marginally faster than the first.

[Reader4106]

Dear Chaley,
Eureka.

Thanks to your help

"subitems()"

and the trial and error method, I found the solution "{#genre:subitems(1,3)}".
That's perfect.

Thanks again.

[Reader4106]

I used your second approach.
It seems to be the better one, and I'll use it.

[sornay]

Hi. How can I add thousand separator to this template:

{identifiers:select(grvotes)}

[Comfy.n]

Originally Posted by sornay

Hi. How can I add thousand separator to this template:

{identifiers:select(grvotes)}

{identifiers:,d:select(grvotes)}

Spoiler:

thanks, Grok

[Comfy.n]

good idea, BTW. I changed mine

More resources here:

https://www.mobileread.com/forums/sh...d.php?t=245647

[sornay]

Originally Posted by Comfy.n

{identifiers:,d:select(grvotes)}

Spoiler:

thanks, Grok

Thanks. You have helped me a lot.

[dunhill]

Originally Posted by Comfy.n

{identifiers:,d:select(grvotes)}

Spoiler:

thanks, Grok

That template changes the values ​​a lot for me.

[Comfy.n]

Originally Posted by dunhill

That template changes the values ​​a lot for me.
[IMG][/IMG]

Welp. there must be some region/localization setting interfering.

Here it works correctly:

[dunhill]

solved in spanish

program:
v=select(field("identifiers"), "grvotes");
if v then 
re(format_number(v, "{0:,.0f}"), ",", ".")
fi

I had to adjust my templates because some depend on Goodreads votes, like the first one (Popularity), which tells you if the book is very famous, and the Top column, which also gives an order based on votes.

[JSWolf]

@dunhill, please attach all of your images. The problem will be when others come to read this thread and some of your images are gone because they've expired the image host.

[dunhill]

Originally Posted by JSWolf

@dunhill, please attach all of your images. The problem will be when others come to read this thread and some of your images are gone because they've expired the image host.

[tsumtsum9]

I have a huge library that I'd like to organize and reduce some redundancy from the raw metadata and tags for shelving in KOReader. One example is for fandoms. I've got some with many fandoms that I'd like consolidated in name, and then for the unchanged names to be returned as part of the list for tags.

Example:
Raw metadata fandom tags for 1 fic: The Avengers, Harry Potter - J. K. Rowling, Marvel Cinematic Universe, Lucifer
Cleaned up fandom tags: Marvel Cinematic Universe, Harry Potter, Lucifer

I've tried the code below which DOES do what I want but it gets tedious because I have to repeat the same block of if... then and else list_item for each potential item number. This would also need updating if new names need to be changed in each repeating segment or the list number increases.

program:
list_join(', ',
if 'Avengers' in list_item($#sourcefandom,0,', ')
then 'Marvel Cinematic Universe'
else
if 'Harry Potter' in list_item($#sourcefandom,0, ', ')
then 'Harry Potter'
else
list_item($#sourcefandom,0,', ')
fi fi
,', ',
## if...then and list_item statements repeated with item numbers 1, 2, 3... etc.
,', ',
)

I also considered the below code which is a bit easier if new changes are added, but I can't figure out how to include the unchanged tags in the list as well. I've also tried to fiddle around with list_re but couldn't create a list with the replaced + unchanged tags.

program:
sf = field('#sourcefandom');
list_join(', ',
if list_contains(a, ', ', 'Harry Potter', '1', '')
then 'Harry Potter'
fi
,', ',
if list_contains(a, ', ', 'Avengers', '1', '')
then 'Marvel Cinematic Universe'
fi
,', ',