06-01-2020, 08:10 PM | #1 |
Guru
Posts: 723
Karma: 228142
Join Date: Sep 2017
Location: Argentina
Device: moon+ reader, kindle paperwhite
|
Help with a template
I have a custom column with decimal numbers for the book grade.
I would like to make a column that depends on it to tell me if all the data in the book is complete, if the decimal column has the column heading "V. Decimal" and the query name # gr1. What should the template be like? I tried with program: test (select (field ('V. Decimal'), '<> "0"'), 'Yes', '') |
06-02-2020, 05:38 AM | #2 |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
I'm not sure what you are doing. But, I can see some errors.
Firstly, you don't refer to a column by the column heading. You need the lookup name. For a custom column, this will always start with a "#". Then, "select" only works on identifier type columns. That means the value you are checking needs to have a ":" in it. Unless you are formatting the decimal with a colon instead of a dot, which I don't know how to do Or is the column a string that just happens to have a number? And the second parameter of "select" is the id name. So, basically what is to the left of the colon. If the column is actually a number, then the following might work (with your column's lookup name): Code:
program: raw_field(list_item(field('#mm_progress'),1,'.'),0,'','Yes','') |
Advert | |
|
06-02-2020, 06:50 AM | #3 |
Guru
Posts: 723
Karma: 228142
Join Date: Sep 2017
Location: Argentina
Device: moon+ reader, kindle paperwhite
|
Hi Davidfor
The column has a decimal number separated by "," I have made replacements to his formula with my names and he doesn't seem to like it. program: raw_field (list_item (field ('# gr1'), 1, ','), 0, '', 'Yes', '') |
06-02-2020, 07:53 AM | #4 | |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
If that isn't it, is there an error message? |
|
06-03-2020, 06:44 AM | #5 | |
Guru
Posts: 723
Karma: 228142
Join Date: Sep 2017
Location: Argentina
Device: moon+ reader, kindle paperwhite
|
Quote:
I leave screenshot with the error it gives. Thank you !! Last edited by dunhill; 06-03-2020 at 06:50 AM. |
|
Advert | |
|
06-03-2020, 08:33 AM | #6 |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Sorry, that was my mistake. What posted before was wrong. The first function should be "cmp", not "raw_field". I have no idea how I did that.
It should have been: Code:
program: cmp(list_item(field('#gr1'),1,','),0,'','Yes','') Code:
program: cmp(list_item(raw_field('#gr1'),1,','),0,'','Yes','') |
06-03-2020, 01:12 PM | #7 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
If the numbers come formatted with commas instead of dots then you might want to use raw_list instead of raw_field. That way you can choose an alternate separator, for example a colon.
|
06-03-2020, 10:11 PM | #8 | |
Guru
Posts: 723
Karma: 228142
Join Date: Sep 2017
Location: Argentina
Device: moon+ reader, kindle paperwhite
|
Quote:
Davidfor! We are close the two codes work half, let's say I don't know why because the "V. Decimal" column has no format or code. I leave catches. If the column has a value it is ok to put yes. And it is expected that if it is empty it will put No but yes. I don't want to be annoying, if you can't. I forget about those settings. Thank you very much for your time and for the prompt responses. |
|
06-04-2020, 01:43 AM | #9 | ||
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Quote:
Code:
program: cmp(list_item(ifempty(field('#gr1'),'0,1'),1,','),0,'','Yes',''); @chaley: I tried the raw_list, but, it gave me the error "is not a list". |
||
06-04-2020, 02:43 AM | #10 |
Grand Sorcerer
Posts: 11,741
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
|
06-04-2020, 06:34 AM | #11 | |
Guru
Posts: 723
Karma: 228142
Join Date: Sep 2017
Location: Argentina
Device: moon+ reader, kindle paperwhite
|
Quote:
Yes now!!!! Genius thank you very much !!! Thanks also to @chaley for the suggestions |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using built-in template functions in a custom template function | ilovejedd | Library Management | 4 | 01-28-2018 12:20 PM |
Help with template... or something else | Glottis | Library Management | 5 | 10-07-2015 12:55 PM |
need help with nested template | Jade Aislin | Library Management | 2 | 11-30-2012 02:04 AM |
Help with template language | Pepin33 | Calibre | 8 | 11-11-2012 08:32 AM |
Help with template | KALKITO | Library Management | 1 | 07-02-2012 02:54 PM |