Multi devices is a problem; currently David's Kobo Utilities only support a single custom column for reading percentage, so all getting of info from the device(s) would go into the same column.
Let's make sure I understand the rest:
- Topic shelves: books with Topic in #myshelves are put in Topic shelves.
- Series shelves: books with Series field are put in Series shelves.
- Neither: books with no Topic or Series go in a shelf, Uncatagorized.
Now, books that are being Read are they to stay on their initial shelf as well as the Reading shelf, and the same for Finished books?
If so, I think the following two columns should suffice
Code:
Lookup Name: shelfname
Column Heading: Shelf Name
Type: Column built from other columns
Template:{:'first_non_empty(field('#myshelves'), field('Series'), 'Uncategorized')'}
Code:
Lookup name: readstatus
Column Heading: Reading Status
Column Type: Column built from other columns
Template: {#koboreadpct:'cmp($, 100, cmp($, 0, '', '', 'Reading'), 'Finished', '')'}
Then add both
#readstatus and
#shelfname to the fields listed in either the Kobo or Kobo Extended driver configuration.
So in this case books would be on both the corresponding
Topic / Series / Uncategorized shelf as well as either the
Reading or
Finished shelves.
If on the other hand you want to move books from the initial shelves onto Reading or Finished you would simply change the shelfname definitioin to
Code:
Template:{:'first_non_empty(field('#readstatus'),field('#myshelves'), field('Series'), 'Uncategorized')'}
and only use the
#shelfname in the driver configuration.
In this case books would be on both the corresponding
Topic / Series / Uncategorized shelf and then, once you have started them only appear on the
Reading shelf, and when finished only on the
Finished shelf.