Thread: [GUI Plugin] Kobo Utilities
View Single Post
Old 11-20-2021, 11:49 PM   #2334
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by Skydog View Post
Is it possible to combine metadata from two fields in order to create a custom column ("Finished") that will automatically enter the date when the device is connected and %read = 100 with the associated time stamp?

I currently have a "Finished" custom column for that purpose but I must enter the date manually via the custom metadata tab. I assume that a 100% read status (or desired %) plus Kobo Last Read TimeStamp must be referenced but have no idea how to go about it.

Thanks to a helpful MR contributor, this is what I currently have and would like to change/amend:

Code:
program:format_date(raw_field('#finished'),'dd MMM yyyy')
I've browsed through the thread back to 2013 but have not seen this specifically addressed, or I have missed it. And without programming knowledge, the tutorial is over my head.
I think what you want is for the "Finished" column to show the date last read from the device when the book is finished. But, not to show anything at other times. If so, you could use a template like:

Code:
program:
cmp($$#kobo_percent_read, 100, '', format_date($$#kobo_last_read,'dd MMM yyyy'), format_date($$#kobo_last_read,'dd MMM yyyy'));
That will show the last read date when the percent read reaches 100. The column names need to be changed to fit what yours.

If it is something else, then I can try. But, you might want to look at https://www.mobileread.com/forums/sh...d.php?t=343076 where I discuss doing something similar to I what I think you want but using icons instead of separate columns.
davidfor is offline