Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 12-07-2018, 10:33 PM   #1
dunhill
Member
dunhill began at the beginning.
 
dunhill's Avatar
 
Posts: 19
Karma: 10
Join Date: Sep 2017
Device: moon+ reader
Column related according to the State column

Hello people, I have a State column where I put if the book was read, I am reading it or if it is next to read.
I would like to have a column that if the state is reading, put the date of the day as the reading start date, and if it was read, put the date as the reading end.
They could guide me. I already have the State column, what syntax should I use in the columns of Start date and end date ????
From already thank you very much.
dunhill is offline   Reply With Quote
Old 12-08-2018, 02:03 AM   #2
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 11,493
Karma: 10584684
Join Date: Mar 2012
Location: Sydney Australia
Device: none
You will need two Date custom columns, #start/Start and #end/End - but you probably know that. Off hand I can't think of a way to automate updating those columns with current date on change of #state/State, other than writing your own plugin.

FWIW: this is what I'd probably do:

I would position Start, State and End as three adjacent columns in the book list.
  • When I added a book I would set State to Unread.
  • When I started a Book I'd press F2 on Start, press '=' to get today's date, Tab into State, select Started, and press Enter.
  • When I finished a book I'd press F2 on State, selected Finished, Tab into End, press '=' to get today's date and press Enter

Note: I do all metadata editing in the book list and I avoid using the mouse, so the above fits into my usage of calibre. If you prefer using the Metadata Edit windows and clicking things with the mouse the above may not suit.


Added: Maybe you don't need a State column, you could use Rules based on the two dates to set a column icon (or colour) - roughly
  • If Start and End are not set, then set icon to transparent.png,
  • If Start is set and End is not set, then set icon to open-book.png,
  • If Start is set and End is set, then set icon to closed-book.png,
  • If Start is not set and End is set, then set icon to question-mark.png.

I prefer icons to colours, as it's easier to figure out what they mean. You'll have to download icons - Browse Icon Packs


But you won't get anything in tag browser if you use column icons/colours for the different States. You could create a Saved Search for each combination of Start and End set and not set, they will appear in the Tag Browser.


Or maybe you could make State a column based on other columns and set it in an Advanced template that interrogates the start and end dates. See User-defined template functions

BR

Last edited by BetterRed; 12-08-2018 at 06:01 AM.
BetterRed is offline   Reply With Quote
Old 12-08-2018, 01:09 PM   #3
dunhill
Member
dunhill began at the beginning.
 
dunhill's Avatar
 
Posts: 19
Karma: 10
Join Date: Sep 2017
Device: moon+ reader
BetterRed
Thank you very much for the prompt response and clarity in the explanations. I have friends who recommend the use of Caliber and these are your doubts.

https://ibb.co/YpNMfhv
dunhill is offline   Reply With Quote
Old 12-08-2018, 06:28 PM   #4
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 11,493
Karma: 10584684
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by dunhill View Post
BetterRed
Thank you very much for the prompt response and clarity in the explanations. I have friends who recommend the use of Caliber and these are your doubts.

https://ibb.co/YpNMfhv
Yeah, that's using calibre's column colouring feature - my brain isn't very good at associating colours with a semantic states - apart from the state of my bank balance

Here's a sample of calibre's column icons feature from my test library

Click image for larger version

Name:	1.JPG
Views:	15
Size:	95.2 KB
ID:	168238

BR
BetterRed is offline   Reply With Quote
Old 12-09-2018, 11:37 AM   #5
dunhill
Member
dunhill began at the beginning.
 
dunhill's Avatar
 
Posts: 19
Karma: 10
Join Date: Sep 2017
Device: moon+ reader
Quote:
Originally Posted by BetterRed View Post
Yeah, that's using calibre's column colouring feature - my brain isn't very good at associating colours with a semantic states - apart from the state of my bank balance

Here's a sample of calibre's column icons feature from my test library

Attachment 168238

BR


BetterRed here I leave you how to do it.

To begin we must go to the preferences button (it is in the top toolbar when it is displayed by pressing the arrows at the top right).
The next thing is to go to visual aspect.
And inside the colored tab of column you give to add rule.
-it dark green if the LEED value appears in the status column.
-it red title if the PROXIMA READURA value appears in the status column.
-Blue title and in the status column the value READING appears.
-author color chocolate if in the comments column appears the value Bibliografia completa.
Very important, do not forget to accept or do not keep it. And of course the green button to apply that in the image above is clearly seen. In the event that the rule created is not to your liking or does not work, you can modify it by pressing twice on it.
Considerations to take into account. When rules are created they are valid for the library in which they are created.
Well, I'm satisfied that at least it's useful to someone.

a greeting.
Attached Thumbnails
Click image for larger version

Name:	reglas.png
Views:	6
Size:	65.1 KB
ID:	168258  

Last edited by BetterRed; 12-09-2018 at 05:36 PM. Reason: OVERSIZE IMAGE _
dunhill is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Single column ePUB becomes 2 column when converted to Kindle (mobi) rmcape Conversion 0 09-21-2013 01:52 PM
Using "Build column from other column" custom-column type HFC3 Library Management 3 07-07-2013 04:11 AM
Q: multi-column PDF to single column mobi format converstion auburn1975 Calibre 7 01-28-2012 07:11 PM
custom date column from two state column Dopedangel Library Management 7 01-03-2012 09:20 AM
Question about series_index, and related column type ElMiko Calibre 3 10-14-2011 10:10 AM


All times are GMT -4. The time now is 09:53 AM.


MobileRead.com is a privately owned, operated and funded community.