Well the columns I have defined are as follows:
Code:
Lookup Name: readstatus
Column Heading: Reading Status
Column Type: Column built from other columns
Template: {#koboreadpct:'cmp($, 100,cmp($, 0, '', '', 'Reading'), strcat('Finished_',format_date(field('#kobolastread'), 'yyyy')),'')'}
Sort/Search column: By Text
Show in tags browser: Checked
Lookup Name: koboreadloc
Column Heading: Kobo Reading Location
Column Type: Text, column shown in the tag browser
Lookup Name: koborating
Column Heading: Kobo Rating
Column Type: Integers
Lookup Name: koboreadpct
Column Heading: Kobo Read Percentage
Column Type: Integers
Lookup Name: kobolastread
Column Heading: Kobo Last Read Timestamp
Column Type: Date
Lookup name: monthadded
Column heading: Month Added
Column type: Column built from other columns
Template: {:'strcat('ZZ_Added_',format_date(field('date'), 'yyyy'),'_',format_date(field('date'), 'MM'))'}
Sort/Search column: By Text
Show in tags browser: Checked
then in the Device driver, the shelves are set to
Code:
#myshelves, #readstatus, series, #monthadded, authors