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 11-21-2012, 11:24 AM   #1
da_jane
Evangelist
da_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enough
 
Posts: 405
Karma: 692
Join Date: Sep 2006
Device: Samsung Galaxy Note 3 | Kindle Paperwhite | iPad Mini
Help wanted on created a plugboard formula for date

I use calibre to update data to my releases.dearauthor.com site and as I was entering books today, I realized that some of my fields could easily be populated by a column from other columns, but I lack the knowledge on how to figure this out.

I'd be happy to pay someone to do this for me but essentially what I want to do is create a plugboard formula that takes the date published and populates another field called pub month. Therefore, if a book is published on August 13, 2013, the pub month field becomes 2013-Aug or something akin to that.

Can anyone help a girl out?
da_jane is offline   Reply With Quote
Old 11-21-2012, 11:46 AM   #2
theducks
Grand Sorcerer
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: 13,606
Karma: 5126946
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by da_jane View Post
I use calibre to update data to my releases.dearauthor.com site and as I was entering books today, I realized that some of my fields could easily be populated by a column from other columns, but I lack the knowledge on how to figure this out.

I'd be happy to pay someone to do this for me but essentially what I want to do is create a plugboard formula that takes the date published and populates another field called pub month. Therefore, if a book is published on August 13, 2013, the pub month field becomes 2013-Aug or something akin to that.

Can anyone help a girl out?
If that is all, No need for a custom column
Preferences: Tweaks:

find the "# Control how dates are displayed" tweak in the List
set this one as shown

gui_pubdate_display_format = 'yyyy-MMM'
theducks is offline   Reply With Quote
Old 11-21-2012, 12:17 PM   #3
da_jane
Evangelist
da_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enoughda_jane will become famous soon enough
 
Posts: 405
Karma: 692
Join Date: Sep 2006
Device: Samsung Galaxy Note 3 | Kindle Paperwhite | iPad Mini
I still want to keep my regular date column so it looks like I need to build a column from a column and I used {pubdate:format_date(yy-MMM)}

Thanks for the lead. That was helpful.
da_jane 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
Troubleshooting Kindle and math formula DrShakalu Amazon Kindle 12 12-11-2011 07:25 AM
Piracy, the new formula for success? ImogenRose General Discussions 27 05-21-2011 08:56 PM
Formula Plots PuxyYunm General Discussions 9 05-15-2011 04:19 AM
Plugboard for Pub Date needed crossi Library Management 2 02-10-2011 12:46 PM


All times are GMT -4. The time now is 04:44 AM.


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