[dailyalice]

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.