Need help with programming a column based on previous data in the same column

seaquay · 06-13-2012, 11:15 AM

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.

theducks · 06-13-2012, 11:25 AM

Quote:

Originally Posted by seaquay

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)

chaley · 06-13-2012, 12:19 PM

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..."

06-13-2012, 11:15 AM	#1
seaquay Junior Member 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.

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

06-13-2012, 12:19 PM	#3
chaley Grand Sorcerer Posts: 12,318 Karma: 7975240 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	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..."

Advert