I think I figured it out.
I changed my series column to this:
{author_sort:.1}/{author_sort}/{series:ifempty ({#DD})||/}{series_index:0>2s|| - }{title} and it works.
Columns cc and dd are as follows:
Lookup Name: cc
Column Heading: Stand Alone Novels
Column Type: Text, column displayed in tag browser
Example of data:
Novels - Brandon Sanderson
Lookup Name: dd
Column Heading: Stand Alone Save
Column Type: {#CC:shorten(6,,0)}
Example of Data:
Novels
so by combing the series and stand alone template I get these results:
Book in a series:
P/Patterson, James/Alex Cross/20 - Cross My Heart
Book that is stand alone
S/Sanderson, Brandon/Novels/Legion
I still think I could accomplish everything I want to do in one column, but I am not savvy enough in the scripting to do it.
|