Basic data formatting

Joe Reazor
Joe Reazor Member Posts: 4
in App Designer

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.

Best Answer

  • Joe Reazor
    Joe Reazor Member Posts: 4
    Answer ✓

    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.

Categories