Create a custom column labelled, for example "Collections" or "Kobo collections" or whatever you like. You can add a set of fixed values to it or just leave the values empty, so you can add whatever you want. Now if you edit the metadata for a book, enter one (or several) of those values that you currently have in many separate columns (Abandoned, Partly Read, Nonfiction and so on) to that column you just created, in the Edit Metadata window.
And in the driver options just enter the column name, not its values (for example, #collections).
In short, don't create a column for each entry; create one column which can have all those entries and then choose which of those entries to add to a book.
I've added a couple of screenshots of my settings.
|