Decimal place for MDA fields

  • 7
  • Idea
  • Updated 4 days ago
  • Implemented
On-behalf of Customer: To be able to add decimal places in numeric MDA fields.

 
Photo of Raymond Obidegwu

Raymond Obidegwu, Employee

  • 268 Points 250 badge 2x thumb

Posted 5 months ago

  • 7
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb
To be clear, this is a "System" type MDA table but a custom that I want to update :)
(Edited)
Photo of Sumesh

Sumesh, Employee

  • 4,474 Points 4k badge 2x thumb
Hi Kate,

Not sure if i understand the use case here. Can you please elaborate?

Thanks,
Sumesh
Photo of Kate Green

Kate Green, Champion

  • 5,652 Points 5k badge 2x thumb
Hi Sumesh - we require our CSM team to document and track their time in hour increments, and so I want to add a custom field to all Activity Types in Timeline called "Hours".  In order to make the time tracking accurate, we have had numerous requests to allow for .5 increments of hours.  

We do not want to use the "Duration (mins)" field, because that will cause our team to get too granular with their time tracking.  Half-hour increments is as granular as we want them to be.  Additionally, we can't simply re-name it to "Hours" because it doesn't allow for decimal places.

Since the new field I am adding (through the Activities and Timeline configuration page) is custom, even though it exists on a System-generated MDA table, I'd like the ability to allow for decimals (perhaps through editing the field characteristics on the Data Management > MDA table configuration shown in Raymond's screenshot above).

Thanks!
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb
Here is an example of a System type MDA table that allows for Schema Editability.  This is what I want for custom fields on Activity Timeline. 

Thanks!

Photo of Sumesh

Sumesh, Employee

  • 4,474 Points 4k badge 2x thumb
Thanks for the clarifications, Kate! I've routed your request to the Product manager of Timeline for further action.
Photo of Nitisha Rathi

Nitisha Rathi, Employee

  • 14,556 Points 10k badge 2x thumb
Hi Kate,

Thanks for the detailed use-case, completely makes sense. I have added it to the roadmap and will update ETA here soon.

Thanks,
Nitisha
Photo of Chris Mudd

Chris Mudd, Employee

  • 3,550 Points 3k badge 2x thumb
Is there any update on when we might be able to expect this? Currently we can make the entry into timeline, but when we pull it into a report it rounds up.  Example .5 turns into 1


Photo of Venkatesh Vangaveeti

Venkatesh Vangaveeti, Employee

  • 228 Points 100 badge 2x thumb
Hi Chris,

Did you tried configuring decimal places for that field in report builder as shown in below screenshot.

 
Photo of Rajesh Gande

Rajesh Gande, Official Rep

  • 3,140 Points 3k badge 2x thumb
Hi Chris, 

This feature is already out. You can now configure decimal places for timeline fields (while adding the field or at layout level for fields that are already added).

Also as Venkatesh indicated, you need to make changes in report builder as well to see the decimal values.

Thanks,
Rajesh 
Photo of Kate Green

Kate Green, Champion

  • 5,706 Points 5k badge 2x thumb
Thanks all - I totally missed this step on the report fields.