Basic data formatting

Joe Reazor · 2024-11-11T16:32:29+00:00

There was an error rendering this rich post.

Is there any idea of when the Page/Widget designer will have basic data formatting available? Like for Dates or Currency specifically. The default look of these is pretty bad and just looking for the basics. If there is a way to do this that I am missing, please let me know.

Find more posts tagged with

Accepted answers

Joe Reazor

Going to answer my own question just in case it helps others. I found a way to do this sort of. It's a workaround, but it does work. In CSI, I added new derived properties to my IDO as String types and in the Implementation for those derived fields I did something like this for currency for example:
(SELECT FORMAT(<source decimal property here>, 'C2'))

This changed a currency value that would look like this 18925.5000000 to be $18,925.50. So much better. You could do similar for dates, just use something like this

(SELECT FORMAT(<date_field>, 'MM/dd/yyyy'))

Hope this helps you if you were struggling with this one too. And maybe actual formatting will get added to the OAD soon.

All comments

Joe Reazor

This changed a currency value that would look like this 18925.5000000 to be $18,925.50. So much better. You could do similar for dates, just use something like this

(SELECT FORMAT(<date_field>, 'MM/dd/yyyy'))

Hope this helps you if you were struggling with this one too. And maybe actual formatting will get added to the OAD soon.