Is it possible to have red colour for number fields?
Is it possible to have red colour for number fields? Requested for overdrawn or over committed inventory. I cannot see anyway of doing this.
The number fields are used in many calculations and there are many of them so converting to text and using Styled would be meesy.
3 replies
-
I'm not sure which would be messier, styled(), Formula field or CSS, but I think those are your only options at this time.
-
You could add a formula field to test for the overdrawn condition on your number field(s) and have the formula field itself set a colour change null of okay or red for overdrawn or show an icon etc.
Not ideal. but this is how i do if for jobs that are overdue the despatch date etc. another variation is a combo box that you set "overdrawn" on as combos can have colour!
But wouldn't it be great if we could a colour directly on a data entry field. (are you listening Ninox?)
-
It does seem like a big oversight not to be able to format number like text.
@phillipsloper, you don't have to change your other number fields or any of your calculations you can just use the new formula field when you want to display the data.
Content aside
- 3 yrs agoLast active
- 3Replies
- 262Views