Skip to main content
Solved

How to display specific number of decimals still storing a precise number?

  • November 21, 2024
  • 4 replies
  • 52 views

Ionut
Warrior
Forum|alt.badge.img+2

Hi!

We have for now some places in app where we do want some precision for our fields, usually we use type numeric with different specifications depending on the needs.

The problem that we have is that we don't always want to show all the decimals, we need them for some calculations still.

It is already something to do that and we just didn't find out what? Is weird to display that many decimals if the user doesn't need them but for background calculations are needed. (This example maybe is a bit to much, but for 6,8,10 decimals can be some situations and still are a lot to display)

If not, we don't want to fake with with a field of another type with some format and so, maybe we can have another setting on the domain for this situations where we can specify display decimals. (other cases can be for description fields for example if you want just a preview of description and maybe more uses).

Best answer by Arie V

@Ionut We currently don't support that, except for using different (Expression) fields, but it would indeed be valuable if we did. There's an Idea open on this topic, please make sure to add your vote and use case(s):

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

4 replies

Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 975 replies
  • Answer
  • November 21, 2024

@Ionut We currently don't support that, except for using different (Expression) fields, but it would indeed be valuable if we did. There's an Idea open on this topic, please make sure to add your vote and use case(s):

 


Freddy
Forum|alt.badge.img+16
  • Thinkwise Local Partner Brasil
  • 528 replies
  • November 21, 2024

@Ionut there are two solutions we use, besides that we all wait for formal field formatting options, the simplest is when you already have a view or don't mind having a view to have base table with high precision numbers, and the view with lower precision for users. 

The other one is to have a calculated field on db level with a different domain (low precision) that just looks at the base field with high precision. 

To be noted: The view field you can make editable for input (low precision), where the calculation fills the high precision field. The calculated field is always read only. 

But as said, looking forward to seeing custom display formats and pre-/suffix options to clarify on unit of measure. 


Ionut
Warrior
Forum|alt.badge.img+2
  • Author
  • Warrior
  • 26 replies
  • November 22, 2024

Ok.

Thanks both for answers, now is clear, until we have it we'll see which option is best.


Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 975 replies
  • November 22, 2024

FYI: I also decided to add the Idea I referred to the list of ‘Ideas to be 10X faster’:

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings