View Single Post
Old 11-10-2022, 11:53 AM   #7713
dailyalice
Geek of All Trades
dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!dailyalice rocks like Gibraltar!
 
dailyalice's Avatar
 
Posts: 55
Karma: 100878
Join Date: Aug 2012
Location: Minneapolis
Device: Kindle Oasis (3rd gen)
Status column question

I've generally created a column type of "Text, but with a fixed set of permitted values" for use as a status column with the permitted values being "Completed,In-Progress,Abandoned,Unknown" and that's worked well for me. I set "Abandoned" manually usually for some works and I've set "Unknown" as the "Default Value" for cases where an archive doesn't give me a status.

I've been assuming most (all?) sites give a status of Completed or In-Progress or that FanFicFare interprets things that way, but wanted to make sure I had this right. Are there other statuses supported for other sites? I've mostly been focused on work with AO3 lately so don't have a lot of experience.

I'm just wondering if there's any reason I should use a different column type (or offer it as an option in that FanFicFare/calibre guide I'm working on). Would a text column or tag column offer more flexibility? I mean, obviously you could then add your own data, but I'm wondering about what data archives typically provide and what FanFicFare accounts for.

(I've searched this thread a bit but didn't have much luck finding info, which may entirely be search failure on my part.)

Attached is a screenshot of how I usually set up my status column.
Attached Thumbnails
Click image for larger version

Name:	status column.png
Views:	274
Size:	33.7 KB
ID:	197646  
dailyalice is offline   Reply With Quote