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 06-13-2012, 11:15 AM   #1
seaquay
Junior Member
seaquay began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Feb 2011
Device: Kindle
Need help with programming a column based on previous data in the same column

I have two columns section and subsection. When I add new books, I first fill in the section (e.g. 'psychology', geography etc.). While entering new books, when I type a letter, I get all the previously entered unique data, which is great. I then proceed to fill in the subsection. I get all the previously entered data in this column, BUT I want only a subset of data that belongs to a particular section. For example, if under 'psychology', I have two subsections - 'Abnormal' and 'Clinical', and under 'geography', I have two subsections - 'Africa' and 'Asia'; then if I type 'Psychology' as the section for a new book and in the subsection I type 'A', I wish to see only 'Abnormal' and not 'Africa' and 'Asia'.
So I want the column 'subsection' to have data based on column 'section'.
Before someone points out, yes, using tags is a great idea, but I feel that I have better control here.
seaquay is offline   Reply With Quote
Old 06-13-2012, 11:25 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: 14,859
Karma: 5654321
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by seaquay View Post
I have two columns section and subsection. When I add new books, I first fill in the section (e.g. 'psychology', geography etc.). While entering new books, when I type a letter, I get all the previously entered unique data, which is great. I then proceed to fill in the subsection. I get all the previously entered data in this column, BUT I want only a subset of data that belongs to a particular section. For example, if under 'psychology', I have two subsections - 'Abnormal' and 'Clinical', and under 'geography', I have two subsections - 'Africa' and 'Asia'; then if I type 'Psychology' as the section for a new book and in the subsection I type 'A', I wish to see only 'Abnormal' and not 'Africa' and 'Asia'.
So I want the column 'subsection' to have data based on column 'section'.
Before someone points out, yes, using tags is a great idea, but I feel that I have better control here.
Would Text with a fixed set of permitted Values work (is not conditional on another column and I am not sure of how big a list it supports)
theducks is offline   Reply With Quote
Old 06-13-2012, 12:19 PM   #3
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,636
Karma: 857074
Join Date: Jan 2010
Location: France
Device: Many android devices
Calibre does not support what you want to do. There is no way to link the legal contents of one column to the content of another.

The closest you can get is hierarchical items as described here. Yes, these are tags, but it isn't clear whether you included hierarchical tags when you said "Before someone points out..."
chaley is offline   Reply With Quote
Reply

Tags
columns

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get {size} data in a User Column? CCarrot Calibre 16 06-26-2012 11:39 AM
Trying to colourize column based on size ... and failing Gary_M_Mugford Library Management 4 03-18-2012 05:46 PM
Column coloring based on the languae Joanna Library Management 2 02-19-2012 07:26 AM
Q: multi-column PDF to single column mobi format converstion auburn1975 Calibre 7 01-28-2012 06:11 PM
Metadata Plugboard Data in a Custom Column nynaevelan Library Management 2 01-10-2012 12:54 PM


All times are GMT -4. The time now is 11:10 AM.


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