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 03-01-2013, 06:07 AM   #1
chemi
Member
chemi began at the beginning.
 
Posts: 18
Karma: 10
Join Date: Jan 2013
Device: Sony Reader PRS-T2
Deleting a date

I have a date field. By default it is blank.
Once I enter a value... I haven't found a way to remove it. I mean, I want to have a date for some books but for others the date field should be blank or unknown.

Is this possible?

Thanks in advance,

Chemi
chemi is offline   Reply With Quote
Old 03-01-2013, 06:19 AM   #2
JimmyR
Ebook Enthusiast
JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.JimmyR ought to be getting tired of karma fortunes by now.
 
Posts: 207
Karma: 839738
Join Date: Jun 2011
Device: Kindle Keyboard, Touch, PW
Select a book, Click "Edit Meta Data". To the right of the meta data fields, you'll see green recycle icons. Clicking those will clear the associated field, the Date field included.
JimmyR is offline   Reply With Quote
Old 03-01-2013, 06:30 AM   #3
chemi
Member
chemi began at the beginning.
 
Posts: 18
Karma: 10
Join Date: Jan 2013
Device: Sony Reader PRS-T2
Thanks!
chemi is offline   Reply With Quote
Old 03-01-2013, 06:35 AM   #4
chaley
"chaley", not "charley"
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: 5,516
Karma: 855450
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by chemi View Post
I have a date field. By default it is blank.
Once I enter a value... I haven't found a way to remove it. I mean, I want to have a date for some books but for others the date field should be blank or unknown.
I assume that the date is a custom column.

Three ways to clear a custom date:

1) In edit metadata (single), click the "Clear" button under the box for the date.

2) In edit metadata (multiple), click the "Apply changes" box leaving the date empty.

3) In the spreadsheet view, change the date to year: 0101, month: 01, day: 01. (And no, there isn't a way to add a "clear button" here).
chaley is offline   Reply With Quote
Old 03-01-2013, 09:05 AM   #5
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: 14,697
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
'Unassign' a custom Number field

Since you had the answer to Date.

How do you blank (Not just set it to Zero) a Custom Column number field (in my case #pages) ?
theducks is online now   Reply With Quote
Old 03-01-2013, 09:50 AM   #6
chaley
"chaley", not "charley"
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: 5,516
Karma: 855450
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by theducks View Post
Since you had the answer to Date.

How do you blank (Not just set it to Zero) a Custom Column number field (in my case #pages) ?
set it to -1000000, or use the process described in the thread Reset book's numeric field to blank.
chaley is offline   Reply With Quote
Old 03-01-2013, 12:03 PM   #7
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: 14,697
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by chaley View Post
set it to -1000000, or use the process described in the thread Reset book's numeric field to blank.

I had missed that one
theducks is online now   Reply With Quote
Old 03-01-2013, 09:08 PM   #8
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: 3,504
Karma: 2177990
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by chaley View Post
...And no, there isn't a way to add a "clear button" here).
If that situation were to change, it would be cute to have a "today's date" button too

BR
BetterRed is offline   Reply With Quote
Old 07-07-2013, 04:35 PM   #9
HFC3
Enthusiast
HFC3 began at the beginning.
 
Posts: 29
Karma: 10
Join Date: Apr 2013
Device: Kindle Touch
This doesn't work for custom date fields. The "date" field clearly visible in the Metadata window appears to be an Calibre record create date. Clearing that with the recycle icon works, but doesn't help with the same issue on other, custom, date fields.

I noticed the "Tag" metadata drop down. This is showing some of my custom fields, but not all. I know why a column built from another column wouldn't appear - I purposely didn't pic the option that indicated the new field would behave like a tag.

But, but there are is one date and number custom field type, neither of which specify "behave like tag". So, no column created as a date or number types are appearing in the tag list.

Where do you access them that has a recycle icon to clear the value?

???
HFC3 is offline   Reply With Quote
Old 07-07-2013, 05:17 PM   #10
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: 14,697
Karma: 5643643
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by HFC3 View Post
This doesn't work for custom date fields. The "date" field clearly visible in the Metadata window appears to be an Calibre record create date. Clearing that with the recycle icon works, but doesn't help with the same issue on other, custom, date fields.

I noticed the "Tag" metadata drop down. This is showing some of my custom fields, but not all. I know why a column built from another column wouldn't appear - I purposely didn't pic the option that indicated the new field would behave like a tag.

But, but there are is one date and number custom field type, neither of which specify "behave like tag". So, no column created as a date or number types are appearing in the tag list.

Where do you access them that has a recycle icon to clear the value?

???
Custom Date columns come with a 'Clear Date' button in the metadata editor

You can't have a 'date' list tag . Tags lists are TEXT (includes digits)
theducks is online now   Reply With Quote
Old 07-07-2013, 05:30 PM   #11
HFC3
Enthusiast
HFC3 began at the beginning.
 
Posts: 29
Karma: 10
Join Date: Apr 2013
Device: Kindle Touch
Ah. That's in the "Custom Metadata" tab.

Thanks again!
HFC3 is offline   Reply With Quote
Old 07-07-2013, 08:40 PM   #12
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: 3,504
Karma: 2177990
Join Date: Mar 2012
Location: NSW Australia
Device: none
You can clear a date in the spreadsheet by highlighting the field, then press F2-enter

You can set a date in the spreadsheet to today by highlighting the field, then press F2=enter

Much easier than clicking buttons in metadata edit.

BR
BetterRed is offline   Reply With Quote
Old 07-07-2013, 11:47 PM   #13
HFC3
Enthusiast
HFC3 began at the beginning.
 
Posts: 29
Karma: 10
Join Date: Apr 2013
Device: Kindle Touch
No true, if by "Spreadsheet" is the main Calibre display table - F2 and blanking the date just replaces the original value when you press >Enter<. That was the first thing I tried.

If that's not what you mean, then why would modifying spreadsheet have any effect on the Calibre table?
HFC3 is offline   Reply With Quote
Old 07-08-2013, 02:21 AM   #14
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: 5,518
Karma: 5446900
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
BetterRed meant: Press F2, make sure all the text is selected, press the "-" key and then press enter. That will clear the date. Pressing the "=" key with set it to the current date.
davidfor is online now   Reply With Quote
Old 07-08-2013, 04:39 AM   #15
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: 3,504
Karma: 2177990
Join Date: Mar 2012
Location: NSW Australia
Device: none
Quote:
Originally Posted by davidfor View Post
BetterRed meant: Press F2, make sure all the text is selected, press the "-" key and then press enter. That will clear the date. Pressing the "=" key with set it to the current date.
BR meant exactly what he wrote

After I press F2 on ANY editable cell in the spreadsheet the content of the cell is always selected - to un-select it I must press home, end, left arrow or right arrow.

There is no need to check anything. To clear a date just press the F2 key, followed by the '-' key, followed by the Enter key; use the '=' to set to today. If you change your mind exit the cell edit with Escape.

BR
BetterRed 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
Publication Date or Copyright Date or ??? hd_cal_dave Library Management 8 05-25-2012 01:50 PM
Date Added vs. Date Modified aglaia761 Calibre 5 11-28-2010 05:34 AM
Bulk Changing Published Date To Date hmf Calibre 4 10-19-2010 10:19 PM
Up-to-date candy teacher (date being 1921) kacir Deals, Freebies, and Resources (No Self-Promotion) 0 06-16-2010 04:18 PM
new official shipping date / US invitation date R2D2 iRex 18 07-06-2006 02:32 PM


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


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