Book list template question

[HunterRose]

I am trying to update my custom book list template to show if a book has the Completed tag or not.

{tags} works fine, but I'm not interested in seeing the whole string, especially as it make take multiple lines.

I have tried

{str_in_list(field('tags'),',','Completed','Incomplete')}

and

{contains(field('tags'),'Completed','Completed','Incomplete')}

and nothing is appearing in the generated output. I have also inserted 'program:' inside the first bracket with the same non-results.

What nuance am I missing here?

[HunterRose]

P.S. Hey, the word 'Incomplete' does not have spaces in it in either instance that I typed, but the forum software apparently knows better.

[BetterRed]

Originally Posted by HunterRose

P.S. Hey, the word 'Incomplete' does not have spaces in it in either instance that I typed, but the forum software apparently knows better.

Solution: put code-like text in code blocks

The '#' icon in the advanced mode toolbar will do it for you.

BR

[davidfor]

Originally Posted by HunterRose

I am trying to update my custom book list template to show if a book has the Completed tag or not.

{tags} works fine, but I'm not interested in seeing the whole string, especially as it make take multiple lines.

I have tried

{str_in_list(field('tags'),',','Completed','Incomplete')}

That looks like you are trying to search for the tag "Completed" and return something. There are two problems. Firstly, the structure of the call is incorrect. The other is that you are missing a parameter. The "str_in_list" requires at least five parameters. The list to check, the divider to use, the item to search for, the result to return when it is found, and the result to return when it is not found.

What you probably want is:

{:str_in_list(field('tags'), ',' ,'Completed', 'Complete', 'Incomplete')}

But, as you mention adding "program:", I would use:

program:
str_in_list(field('tags'), ',' ,'Completed', 'Complete', 'Incomplete')

and

{contains(field('tags'),'Completed','Completed','Incomplete')}

and nothing is appearing in the generated output. I have also inserted 'program:' inside the first bracket with the same non-results.

There is a similar issue with that one. I would use something like:

program:
contains(field('tags'), 'Completed', 'Completed', 'Incomplete')

But, I would use the first "str_in_list" as to me that is more obvious as to it's intention.

[HunterRose]

davidfor, thank you for your assistance, I am trying out your suggestions.

(It appears that my original post was edited to improve formatting and one of the 'Completed's was dropped along the way.)

[HunterRose]

OK, my major difficulty was trying to place the formula in the book list template itself - checking one of the 'related' threads reveals that the book list template does not evaluate expressions.

The solution is to create a custom column that evaluates to the desired value and putting the name of the column in the book list template:

#status column contains template

{tags:in_list($,', ',Completed,Complete,Incomplete)}

book list template contains

{#status}

This appears to be generating correct results, although I see the occasional single quote mark returned instead of Complete or Incomplete. No idea what's up with that, gonna stop beating my head against the table for tonight.