View Single Post
Old 12-03-2016, 11:42 PM   #1
Angel Crawford
Enthusiast
Angel Crawford began at the beginning.
 
Angel Crawford's Avatar
 
Posts: 31
Karma: 10
Join Date: Dec 2016
Location: Germany
Device: PocketBook Touch HD 3
Question 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
Angel Crawford is offline   Reply With Quote