Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 11-27-2019, 11:32 AM   #1
dunhill
Guru
dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.
 
dunhill's Avatar
 
Posts: 893
Karma: 810834
Join Date: Sep 2017
Location: Buenos Aires, Argentina
Device: moon+ reader, kindle paperwhite
year column

I had a question about how I could have a custom column that only gives me the year, depending on the date of publication and that can be seen on labels?


Enviado desde mi ONEPLUS A3000 mediante Tapatalk
dunhill is offline   Reply With Quote
Old 11-27-2019, 01:27 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,057
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Some tweaks, that may (or not) help
The first controls how dates APPEAR in the columns

The Second makes behave as seen (a normal sort still considers the stuff you can't see)

Code:
ID: gui_pubdate_display_format
-----
# Control how dates are displayed

gui_pubdate_display_format = u'MMM yyyy'

gui_timestamp_display_format = u'dd MMM yy, hh:mm'

gui_last_modified_display_format = u'dd MMM yy hh'
Code:
# Choose whether dates are sorted using visible fields

sort_dates_using_visible_fields = False
Labels? You can use the Python formatting rules i some of the Advanced templates
theducks is offline   Reply With Quote
Advert
Old 11-27-2019, 01:29 PM   #3
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 13,473
Karma: 239219543
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Quote:
Originally Posted by dunhill View Post
I had a question about how I could have a custom column that only gives me the year, depending on the date of publication and that can be seen on labels?


Enviado desde mi ONEPLUS A3000 mediante Tapatalk
You can customize the publication date column to display only the year, in Preferences -> Tweaks -> Control how dates are displayed.
Sirtel is offline   Reply With Quote
Old 11-28-2019, 09:37 PM   #4
dunhill
Guru
dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.
 
dunhill's Avatar
 
Posts: 893
Karma: 810834
Join Date: Sep 2017
Location: Buenos Aires, Argentina
Device: moon+ reader, kindle paperwhite
Thank you both for the comments, I tell you what I wanted to do, instead of having to make libraries per year of publication (Example: Library 2018 - Library 2019, I wanted to appear in the category part
dunhill is offline   Reply With Quote
Old 11-28-2019, 11:02 PM   #5
BetterRed
null operator (he/him)
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: 21,725
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@dunhill - I think you'll have to extract the year from the date into a custom column of type: Column built from other columns, behaves like tags.

BR
BetterRed is online now   Reply With Quote
Advert
Old 11-29-2019, 05:27 AM   #6
dunhill
Guru
dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.
 
dunhill's Avatar
 
Posts: 893
Karma: 810834
Join Date: Sep 2017
Location: Buenos Aires, Argentina
Device: moon+ reader, kindle paperwhite
Quote:
Originally Posted by BetterRed View Post
@dunhill - I think you'll have to extract the year from the date into a custom column of type: Column built from other columns, behaves like tags.

BR
Could you help me with the formula?

Enviado desde mi ONEPLUS A3000 mediante Tapatalk
dunhill is offline   Reply With Quote
Old 11-29-2019, 06:29 AM   #7
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
I think you want a column built from other columns without the "behaves like tags". The column contains exactly 1 value, the publication year. "Behaves like tags" is for a column containing multiple values.

The template is
Code:
{pubdate:format_date(yyyy)}
The column definition is something like this:
Click image for larger version

Name:	Clipboard01.jpg
Views:	186
Size:	43.9 KB
ID:	175217
chaley is offline   Reply With Quote
Old 11-29-2019, 09:44 AM   #8
dunhill
Guru
dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.dunhill ought to be getting tired of karma fortunes by now.
 
dunhill's Avatar
 
Posts: 893
Karma: 810834
Join Date: Sep 2017
Location: Buenos Aires, Argentina
Device: moon+ reader, kindle paperwhite
Quote:
Originally Posted by chaley View Post
I think you want a column built from other columns without the "behaves like tags". The column contains exactly 1 value, the publication year. "Behaves like tags" is for a column containing multiple values.



The template is

Code:
{pubdate:format_date(yyyy)}
The column definition is something like this:

Attachment 175217
thank you very much, grateful

Enviado desde mi ONEPLUS A3000 mediante Tapatalk
dunhill is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using "Build column from other column" custom-column type HFC3 Library Management 3 07-07-2013 03:11 AM
Rounding to nearest integer in Custom Column - Hijri Year oelgamal Calibre 2 03-28-2013 07:12 PM
Rounding to nearest integer in Custom Column - Hijri Year oelgamal Recipes 0 03-28-2013 02:58 AM
''Month Year'' possible only ''Year'' + ''uri'' to ''url'' chaot Recipes 2 11-30-2012 12:06 PM
Q: multi-column PDF to single column mobi format converstion auburn1975 Calibre 7 01-28-2012 06:11 PM


All times are GMT -4. The time now is 01:41 AM.


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