Help with a template

[dunhill]

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', '')

[davidfor]

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):

program:
raw_field(list_item(field('#mm_progress'),1,'.'),0,'','Yes','')

Which I really don't like. Because I am treating the number as a list using a dot as the separator, taking the second element and then comparing it to zero. It seems to work, but I don't like it.

[dunhill]

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', '')

[davidfor]

Originally Posted by dunhill

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', '')

I assume the comma is a locale thing. But, there shouldn't be a space after the "#".

If that isn't it, is there an error message?

[dunhill]

Originally Posted by davidfor

I assume the comma is a locale thing. But, there shouldn't be a space after the "#".

If that isn't it, is there an error message?

Hello Davidfor The space appeared in the message when writing the code, in calibre it is not.
I leave screenshot with the error it gives.
Thank you !!

[davidfor]

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:

program:
cmp(list_item(field('#gr1'),1,','),0,'','Yes','')

The alternative is:

program:
cmp(list_item(raw_field('#gr1'),1,','),0,'','Yes','')

The possible advantage of that is that the value of #gr1 doesn't go through any formatting specified for the column. Though I don't know if the decimal point will be locale specific, so it could be a comma or a dot.

[chaley]

Originally Posted by davidfor

The possible advantage of that is that the value of #gr1 doesn't go through any formatting specified for the column. Though I don't know if the decimal point will be locale specific, so it could be a comma or a dot.

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.

[dunhill]

Originally Posted by davidfor

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:

program:
cmp(list_item(field('#gr1'),1,','),0,'','Yes','')

The alternative is:

program:
cmp(list_item(raw_field('#gr1'),1,','),0,'','Yes','')

The possible advantage of that is that the value of #gr1 doesn't go through any formatting specified for the column. Though I don't know if the decimal point will be locale specific, so it could be a comma or a dot.

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.

[davidfor]

Originally Posted by dunhill

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.

The use of comma or dot is a locale thing. Australia and I think most English speaking countries use a dot with the comma as the thousands separator. And from memory, most European use a comma for the decimals and spaces for the thousands.

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.

My quick and dirty cheat is to return a value that triggers the appropriate response if the column is empty.

program:
cmp(list_item(ifempty(field('#gr1'),'0,1'),1,','),0,'','Yes','');

That should work assuming I changed from my test version to yours properly.

@chaley: I tried the raw_list, but, it gave me the error "is not a list".

[chaley]

Originally Posted by davidfor

@chaley: I tried the raw_list, but, it gave me the error "is not a list".

Ahh, you are right. Looking at the first post, #gr1 is a floating point number. Sorry about the noise.

[dunhill]

Originally Posted by davidfor

The use of comma or dot is a locale thing. Australia and I think most English speaking countries use a dot with the comma as the thousands separator. And from memory, most European use a comma for the decimals and spaces for the thousands.


My quick and dirty cheat is to return a value that triggers the appropriate response if the column is empty.

program:
cmp(list_item(ifempty(field('#gr1'),'0,1'),1,','),0,'','Yes','');

That should work assuming I changed from my test version to yours properly.

@chaley: I tried the raw_list, but, it gave me the error "is not a list".

Yes now!!!! Genius thank you very much !!!
Thanks also to @chaley for the suggestions