02-01-2013, 12:30 PM | #46 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
Hey Chaley. If you can do the today thing that would be terrific. I'll keep checking in to grab that update. I swear this is the most fun feature in Calibre. Purely visually pleasing.
|
02-02-2013, 03:11 AM | #47 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
It will be in next weeks release. The rule definition is shown in the following screenshot. Days are really 24 hours, not midnight to midnight.
|
Advert | |
|
02-02-2013, 12:00 PM | #48 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
Thank you Chaley. You are amazing!
|
02-08-2013, 12:59 PM | #49 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
Hey Chaley so I just installed the update and it doesn't seem to work.
This is what I tried: If the <Release Date> column is not more days ago than <0> - this put the icon in every single row including the ones that the Release Date column is blank and the one that says 2 Apr 2013 If the <shelves> column has value <to-be-release> If the <Release Date> column is not more days ago than value <0> - this put the icon in every row that had to-be-release in the shelves column including one that says 2 Apr 2013 If the <shelves> column has value <to-be-release> If the <Release Date> column is not more days ago than value <1> - this put the icon in every row that had to-be-release in the shelves column including one that says 2 Apr 2013 Am I doing something wrong? |
02-08-2013, 01:14 PM | #50 | ||
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
Blank dates are a problem, because the answer is undefined. But I agree, they shouldn't return "true". I will look at how to fix that. Quote:
What happens if the release date column actually has a date in it? |
||
Advert | |
|
02-08-2013, 04:45 PM | #51 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
I have added code to check for empty dates, making them "infinite" days ago. Should be in the next release.
|
02-09-2013, 12:20 PM | #52 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
If the release date actually has a date in it:
If the <Release Date> column is not more days ago than value <1> - it puts the icon in in all of the one that have not been released yet so 2 Apr 2013 and 13 Nov 2013 but the one that has been released 7 Feb 2013 doesn't get the icon. how do you put pics in so i can give you more detail? Last edited by tarisea; 02-09-2013 at 12:22 PM. |
02-09-2013, 12:34 PM | #53 | |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
What is it that you want to happen? |
|
02-10-2013, 12:19 PM | #54 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
Chaley the wording is seriously misleading and almost impossible to work with. I have run a few tests and this is what I figured out.
The condition is defining "not more days ago than" as any time in the future up to x number of days in the past from today. The conditions needed is one that will equal any time in the past. Very simply "is less than today" So basically on February 10, 2013: 4/2/2001 =IF(A1<TODAY(),true,false) TRUE icon 2/2/2012 =IF(A1<TODAY(),true,false) TRUE icon 11/10/2012 =IF(A1<TODAY(),true,false) TRUE icon 5/5/2013 =IF(A1<TODAY(),true,false) FALSE no icon 2/8/2013 =IF(A1<TODAY(),true,false) TRUE icon |
02-10-2013, 12:58 PM | #55 | ||
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
I do see that it doesn't do what you want, and doesn't do what you originally asked for. Quote:
I have added several more conditions that permit building ranges. The conditions are:
Edit: changed the discussion to describe more precisely the matching rules. The "(and equal to)" clauses were added. Also note that the matching was changed from "24-hour days" to "calendar days". Only the date is used when matching. The time of day is ignored. Last edited by chaley; 02-10-2013 at 03:37 PM. Reason: edit: more accurate matching rules description |
||
02-10-2013, 02:45 PM | #56 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
That's great. Looking forward to playing with it.
|
03-07-2013, 12:23 PM | #57 |
Zealot
Posts: 114
Karma: 6288
Join Date: Dec 2012
Device: iphone
|
Hi Chaley. First I want to thank you again. I love this feature. Also I wanted to ask a question: the choice is icon or icon with text, I don't notice a difference, there is no text.
I would like to create a separate column with just text for it just to do some filtering but i can't seem to get a column to work. I would like a column - if there is a checkmark in read put checkmark. Any ideas? |
03-07-2013, 03:11 PM | #58 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
I am not in a place where I can test, but from memory the "with text" option works for columns that do not have "use checkmarks" checked. I remember testing adding icons to the author column keeping the display of the name. I added checkmarks and other icons.
I am not sure what you are saying about the read column. You should be able to add an icon to any column you want if read is true assuming it is a yes/no column. |
03-13-2013, 06:49 AM | #59 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
OK, I can run some tests now. Things seem to work as I intended.
I have two columns "Text with a fixed set of values" with "Show checkmarks" unchecked. The permitted values for each column are blank and "yes,no,one,two,three". I put the same value in each column for 5 books. I then created identical icon rules for each column except that one has "with text" and one has "with no text". The result: The first column has the text along side the icons with the text aligned. The second column has no text where there is an icon, and the text and icons are aligned. For completeness, the rules: |
03-13-2013, 08:33 AM | #60 |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Thanks for that bit of detail. I missed it and had two rules, one with text and one without for the same column.
While fixing that, I realised I could have multiple conditions. But, they all have to be true. Is there any way to do an OR? I suppose that's really an enhancement request. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to move value(s) of tag column to a custom made column | zoorakhan | Library Management | 0 | 12-08-2012 03:53 AM |
custom date column from two state column | Dopedangel | Library Management | 7 | 01-03-2012 08:20 AM |
Can custom book data be displayed in a custom column? | kiwidude | Development | 9 | 03-02-2011 05:35 AM |
Custom Icons not Honored in 0.7.18 | edbro | Calibre | 1 | 09-10-2010 09:15 PM |
Custom Icons for Your ePub Files | Zero9 | ePub | 1 | 06-09-2009 07:45 PM |