Compare two cuolumns (boolean) to fill new custom columns

Angel Crawford · 12-04-2016, 12:42 AM

Hello there!

First of all: English is not my native language, sorry. But I hope, you understand what I am trying to say/write

Explanation: I sorted half of my eBooks at the moment into the Software and I created two custom columns.
1. #bought:yes/no (eBooks I bought from several publisher)
2. #onleihe:yes/no (eBooks I can borrow from my library)
But than I found out that some of my series are not complete, because I don't get the information that the author wrote new books

Question: Instead of creating a third column (#wishlist), which I have to fill every time, I want a custom column which will fill based on the first two custom columns.
Case 1: #bought:yes AND onleihe:yes = #wishlist:no
Case 2: #bought:no AND onleihe:yes = #wishlist:no
Case 3: #bought:yes AND onleihe:no = #wishlist:no
Case 4: #bought:no AND onleihe:no = #wishlist:yes
So, is this possible? Can I fill a third column based of the values of the two first columns?
Hint: Yes, I can create a virtual library and work with the search. #onleihe:no and #bought:no. But I want a column

Problem: I create a third custom column and choose "build from other columns", to get the template field. Than I read trough the Template Lang Manual and approached to my result... and failed, for hours

I don't get it! I can do fancy stuff now, but I don't need this. I don't find out, how to get the value of the yes/no field and than return the result. I'm not even close.

Can someone help me? Searched the forum for one and a half hour, searched Google for about three hours now (I was so desperate, I even got to Page six of Google Search!) and I am confused now.

In hope, Angel

nabsltd · 12-04-2016, 04:19 PM

Quote:

Originally Posted by Angel Crawford

Case 4: #bought:no AND onleihe:no = #wishlist:yes

Do you really need another column? Just create a saved search with exactly what you listed here, and clicking on that search will give you all your "Wishlist" books.

Angel Crawford · 12-05-2016, 05:31 PM

Hey, thanks for the reply. At the moment I created a Search with a virtual library. But I don't want to change my view or search every time.
But if it's not working, than I will live with it

12-04-2016, 12:42 AM	#1
Angel Crawford Enthusiast Posts: 31 Karma: 10 Join Date: Dec 2016 Location: Germany Device: PocketBook Touch HD 3	Compare two cuolumns (boolean) to fill new custom columns Hello there! First of all: English is not my native language, sorry. But I hope, you understand what I am trying to say/write Explanation: I sorted half of my eBooks at the moment into the Software and I created two custom columns. 1. #bought:yes/no (eBooks I bought from several publisher) 2. #onleihe:yes/no (eBooks I can borrow from my library) But than I found out that some of my series are not complete, because I don't get the information that the author wrote new books Question: Instead of creating a third column (#wishlist), which I have to fill every time, I want a custom column which will fill based on the first two custom columns. Case 1: #bought:yes AND onleihe:yes = #wishlist:no Case 2: #bought:no AND onleihe:yes = #wishlist:no Case 3: #bought:yes AND onleihe:no = #wishlist:no Case 4: #bought:no AND onleihe:no = #wishlist:yes So, is this possible? Can I fill a third column based of the values of the two first columns? Hint: Yes, I can create a virtual library and work with the search. #onleihe:no and #bought:no. But I want a column Problem: I create a third custom column and choose "build from other columns", to get the template field. Than I read trough the Template Lang Manual and approached to my result... and failed, for hours I don't get it! I can do fancy stuff now, but I don't need this. I don't find out, how to get the value of the yes/no field and than return the result. I'm not even close. Can someone help me? Searched the forum for one and a half hour, searched Google for about three hours now (I was so desperate, I even got to Page six of Google Search!) and I am confused now. In hope, Angel

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Columns	docmartn	Library Management	3	08-30-2016 03:18 PM
How can I boolean OR several tags into one custom column?	bmix	Library Management	3	01-09-2015 04:57 AM
Custom column auto fill in	wawasteele	Calibre	4	11-18-2013 04:35 PM
Boolean custom column values	sengian	Library Management	4	01-05-2012 06:39 PM

12-05-2016, 05:31 PM	#3
Angel Crawford Enthusiast Posts: 31 Karma: 10 Join Date: Dec 2016 Location: Germany Device: PocketBook Touch HD 3	Hey, thanks for the reply. At the moment I created a Search with a virtual library. But I don't want to change my view or search every time. But if it's not working, than I will live with it