I have several custom fields for tagging my audio books.
Book Author = text field
Book Series = text field
Book Series Volume = text but is a number like 1
Book Title= text field
Display Book Title = calculated field
*Display Book Title* is a field that uses the other fields to make a pretty title for example if it's not a part of a series it will only use the book title field but if it's part of a series it uses book title, book series, and the book series volume field.
example no series : See Spot Run
example series : See Spot Run - Spots adventures - Book 1
Here is the Display Book Title expression
If(IsEqual([Media Sub Type],Audiobook),If(IsEqual([Book Series],),[Book Title],[Book Title] - [Book Series] Book [Book Series Volume]),)
The problem I am having is in the file rename move & copy tool with the expression for the file name
If(IsEqual([Media Sub Type],Audiobook),PadNumber([Track #],3) - [Display Book Title],If(IsEqual(Left([Name], 1),0),[Name] - [My Album Title],PadNumber([Track #],3) - [Name] - [My Album Title]))
In this case the book I am tagging is a non series book
the calculated value of the display book title field is "The Return Of Moriarty"
The file name I am getting as a product in the rename move & copy tool is as follows
011 - The Return Of Moriarty - unknown book series book unknown book series volume.mp3
In the file name expression I don't use the book series field or the book series volume field at all. I would appreciate any and all help figuring out what is going on here. I have been using this expression for years with out a problem, I did just upgrade to the latest MC17 .185 tho so possibly a bug ?