View Single Post
Old 06-04-2026, 05:21 PM   #14
whiteowl
Enthusiast
whiteowl began at the beginning.
 
Posts: 40
Karma: 10
Join Date: Jan 2020
Device: none
Quote:
Originally Posted by thiago.eec View Post
I think the problem is that the template is returning a string when you choose 'percent'. I have a custom column with my reading percentage, but it was created as a 'Floating point number' and I added this formatting: {:.0f}%. It sorts just fine.
Sorry, I do not understand how you did it.

When I click on "Read Progress" template - it creates a "Column type: Column built from other columns". There is no field for formatting.
Attempt to change that column type to Float, adds a field "Format for numbers", but removes the "Template" field with the function.

So: how do you format the "Column built from other columns"?

Quote:
Originally Posted by thiago.eec View Post
For now, you can use the template below to activate sorting:
Code:
program:
	format_number(reading_progress($id, '', 'pos_frac')*100, '{:.0f}')
You will get the same as using 'percent' minus the '%' symbol. And now you can sort.
Again: How? What should I click in the UI to get to the field where I would be able to type that expression?
whiteowl is offline   Reply With Quote