I'd like to merge some columns I'd created, based on some criteria.
I had been keeping track of the books I've finished by putting a date in #read. Then I got a Kobo and used KoboUtilities to populate #kobopct (the pct of the book I've read on Kobo) and #kobolastread (when I last read the book on Kobo). If #pct = 100, #lastread is when I finished the book.
I'd like to create a new #whenfinished. I think the basic logic would be as follows:
Code:
if #kobopct == 100:
#whenfinished = #kobolastread
else:
#whenfinished = #read [date or blank]
What would be the best way to implement this?