Quote:
Originally Posted by davidfor
|
Thank you, 'lookup' did the trick.
If anyone interested, this is what I use,
Code:
{#folder1:lookup(Non Fiction, , authors)}
I have a custom column folder1 with fiction/nonfiction (You could use collections as well most probably). Lookup will return nothing if it is nonfiction else it will return author name.
Complete save template
Code:
Books/{#folder1}/{#folder2}/{#folder3}/{#folder4}/{#folder1:lookup(Non Fiction, , authors)}/{series:re(([^\s])[^\s]+(\s|$),\1)} {series_index:0>2s|| - } {title}