Silly question: is there a way to format number fields in order to always show 2 decimals wihout having ".00" empty fields shown?
I tried several combination, but no one does the job...
Any suggestion?
Riccardino wrote:Silly question: is there a way to format number fields in order to always show 2 decimals wihout having ".00" empty fields shown?
I tried several combination, but no one does the job...
Any suggestion?
lvostinar wrote:Riccardino wrote:Silly question: is there a way to format number fields in order to always show 2 decimals wihout having ".00" empty fields shown?
I tried several combination, but no one does the job...
Any suggestion?
use a converter on the column ?
Joas wrote:Have you tried the format "0.00"? Then it will show "0.00" if the value is 0.
charles huff wrote:you could format the color of the zero value to be the same as the background of the field for that one case 0.00 making it invisible to the eye.
just a thought....
What about support for conditional formatting anyway?
I dropped a feature request for this in the support system as it would be very convenient to be able to change the fontsize/color etc. of content based on a value somewhere in a (related) column.
Besides, this would overcome the need to use html for just anything you want to have formatted. (And the need to get rid of the formatting again when exporting your records as discussed last week on the forum)
I don't know if this can be done by Servoy from a technical point of view.
mboegem wrote:Hmm, if you're thinking something similar to FileMaker's conditional formatting
Ron wrote:Is it possible to make the bgcolor of a field e.g. red in case the number = 100, with html.
I have 2 records in listview with only one numberfield, displaying 100 (in record1) and 50 (in record2).
I can get it to work in recordview, but not in listview and tableview.
Users browsing this forum: No registered users and 4 guests