View Single Post
Old 06-05-2010, 03:36 PM   #40
riemann42
Zealot
riemann42 will become famous soon enoughriemann42 will become famous soon enoughriemann42 will become famous soon enoughriemann42 will become famous soon enoughriemann42 will become famous soon enoughriemann42 will become famous soon enough
 
riemann42's Avatar
 
Posts: 121
Karma: 506
Join Date: Jun 2009
Location: Spokane, WA
Device: eSlick,nook
Love the custom columns. It would be nice to have a way to pre-populate the data of a new custom field.

For example, I have added three new custom fields: Read, Store, and Date Read. For the Read field, it is trivial as a tag search made filling this in easy. Same with the Store. For the last read, I haven't been keeping track of this. I have been keeping track of purchase date (by using the date field). So it seems reasonable to pre-populate the Last Read field with a query such as:

if (#read:yes) then (value=date) else (value=undefined)

or even

(#read:yes)?(date)

or even

(#read:yes)?(date+1d)

I would then, of course, have to go through and change values such as for Peter Hamilton's Commonwealth and Confederation series which I read annually in a binge before the next book comes out (it's really a sick disease. I need help).

For now, my sql-fu is good, so it is not too much of an issue for me to do this, and I realize it would need a new language to do so it is a little complicated of a request.
riemann42 is offline   Reply With Quote