Save to Disk help

[Dethmaul]

OK Please help me!

I am trying to get my save to disk to save my books correctly.

I have all my books in Collections

My collections help me sort my books (obviously) into categories defined by me.
My categories help me separate books into 3 distinct groups:
1. Books that are a part of a multiverse - Can span many authors, series, and stand alone novels.

2. Series - This basically just duplicates the series already defined in the metadata

3. Stand alone novels - Novels by a given author that do not belong in a multiverse or book series.

So right now I am using several composite columns to save my books.

If it is part of a collection, it uses these templates:
{#readorder:||/}{#readorder_index:|Book | - }{title}{series:| - | - }{series_index:|Book |}
and
{#readorder_index:| [ | ] }{title}
Example: New Republic Era/Book 54 - The Lost Ones - Young Jedi Knights - Book 3


If the book is part of a series, it uses these templates:
{author_sort:.1}/{author_sort}/{series:||/}{series_index:0>2s|| - }{title}
and
{series_index:| [ | ] }{title}
Example: A/Archer, Alex/Rogue Angel/44 - Blood Cursed

To achieve this, I have my Save to Disk template set to:
{#readorder:lookup(.,#BB,#AA)}

This does not work well for stand alone novels. It saves these out under the author name fine, but these aren't in a novels folder.

I created a new composite column to define Stand Alone Novels.
I want these to save out as well. How do I accomplish this and still maintain my current functionality?

Template for Stand Alone Novels:
{author_sort:.1}/{author_sort}/{#CC:shorten(6,,0)}/{title}
Example: S/Sanderson, Brandon/Novels/Legion

While I am asking for help, how do I get each template to ONLY output data if the field exists?

I can give a list of all my custom columns if need be.

[Dethmaul]

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.