I have my app set up in Portuguese (pt_br), which enables the number inputs to have a comma as the decimal separator.
However whenever the users save a number that contains decimals, this number is not stored correctly in the database. Even though the field type is set up as number, bubble does not seem to recognize these entries as numbers. They are not considered in calculations and charts.
This is clear because whenever the number is saved without decimal (ex: 500,00) is sits at the right side of the database field. However when it does have decimals (ex: 500,90) it sits at the left side, as shown in the image bellow.
This is really frustrating because my app is all about finance and this affects its core functionality.
Does someone know how to solve this?
Thank you.