View Single Post
Old 11-20-2021, 01:07 PM   #2330
Skydog
Wizard
Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.Skydog ought to be getting tired of karma fortunes by now.
 
Skydog's Avatar
 
Posts: 2,286
Karma: 7409537
Join Date: Mar 2009
Location: Circling Earth @ Mach .83
Device: Elipsa 2E, Sage, Libra Colour, Libra 2, Clara 2E, Oasis3, Voyage
Question Two conditions for one column?

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.
Skydog is offline