MobileRead Forums - View Single Post

davidfor · 06-02-2020, 05:38 AM

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

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.

06-02-2020, 05:38 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 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','') 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.