If an SQL floating point number is displayed as “Currency” type in a text box input it divides the number by 100. This doesn’t make a lot of sense to me. Changing the display type in the text box to “Number” does not divide it but then it loses the comma formatting, etc.
I have now cast the number as a Money type in the SQL query. It still divides the number by 100 when I ask it to display it as “Currency” in a text input field for a form. I don’t see any other way to format it with commas and decimal points. This makes viewing large numbers in a form very awkward (it also left justifies).
Hi Paul. Thanks for pointing this out. I’m logging this.
Visually the currency text box works great but as reported by @pdamato the value
property doesn’t correspond to the visual data. Also, calling setValue
doesn’t work either.
The value is save and comes from a Postgres numeric(10,2) field.
Hi @davidls! It looks like the currency type on the text input is expecting a value in cents. Certainly a strange behavior, and I’m bringing this back up with the team.