[meme]

Originally Posted by Nyssa

Two things I've noticed, however, for later consideration:

1. It doesn't seem to like multiple authors. I have a handful of collaborations, and they are skipped when creating collections:
(i.e. - There is a series by Eric Flint called Assiti Shards. The 2nd book was co authored bu David Weber, but the book was left out of the collection until I removed Weber's name)

It has no way of knowing that these 2 authors are really the same for your collection name.

If you want full control over your author and series names for your collection names without modifying the original author/series names then you can do this:

1. Create a custom column, type text, called "Short Author Sort" with lookup name "short_author_sort"
2. Add short/modified author names, to this column only if you want it to be different than the Author Sort column (e.g. make it 'Flint, Eric and friends' for all the books in a series he sometimes works with other authors)
3. Create a custom column, type text, called "Short Series" with lookup name "short_series"
4. Add short/modified series names to this column only if you want it to be different than the Series column (e.g. Poirot instead of Hercule Poirot]
5. Create a custom column, type from other columns, called "Collections" with lookup name collections
6. Enter this as the template - copy all 4 lines and paste into the template field:
   
   program:
   author = test(field('#short_author_sort'), field('#short_author_sort'), field('author_sort'));
   series = test(field('#short_series'), field('#short_series'), field('series'));
   strcat("[", test(series, strcat(author, " -- ", series), author), "]");
   
   
7. In the Kindle Collections plugin Customize screen set 'Create' for the custom field 'Collections'

2. I can not find a way to get certain series or authors ignored while using the template.

This should be a simple matter of putting ".*SERIESNAME.*" without the quotes into the Ignore field for your custom column.

Oh, I was originally going to try the first option:

series:'test($, strcat("[",field('series'),"]"), strcat(">(",field('author'),")"))'}

and noticed that you have to add the "{" before series: to get it to work.

Thanks - I've updated my post.

Thank you, again.

You're welcome.