I just have an enumerated (fixed-value text) column with the fanfic status. If a book has the incorrect status I just manually set it to complete.
On the topic of keeping track of read chapters, though: Here's the composite column I use to display chapters:
Caveats: This depends heavily on two things:
1. You use FanFicFare (because the file structure depends on it)
2. You read with a Kobo and use Kobo Utilities' custom column feature. (As such, your column will only update when you connect the device; I do it on a daily basis, so not much a problem for me.)
Code:
program:
## You'll need to replace these column names with your own
input = $#kobobookmark;
status = $#fanficstatus;
# Misspelled this because 'count' is a function
ccount = $$#chaptercount;
if
## I check my 'fandom' column to see if a book is a fanfic
$#fanficcat
then
## This checks that the fanfic has a Kobo bookmark saved
if
substr(input, 0, 10) == 'OEBPS/file'
&&
## I ignore oneshots and FanFicFare anthologies
!status inlist 'Anthology,Oneshot'
then
## Extracts the 'current chapter' from the bookmarks, subtracts 1, and then formats them as 'currentchapno/totalchapno'
strcat(format_number(re(input, '.*\/file(\d+).*', '\1') - 1, '{0:,d}'), '/',ccount)
else
ccount
fi
## This is some other formatting stuff for other books
elif
ccount == 'None'
then
'Not Set'
elif
ccount >#1
then
ccount
fi
Note that I pause at the beginning of chapters. If you prefer to pause at the end of chapters, you'll prefer this for line 22 to remove the subtraction:
Code:
strcat(format_number(re(input, '.*\/file(\d+).*', '\1'), '{0:,d}'), '/',ccount)