AppGini Community Forums

I've defined DECIMAL type fields. The value that is to be entered should be with a Comma (,) instead of the standard point (.)
So: I want :123,45 but has to be inputed as: 123.45.

Is this to be changed ?

The App settings are: Ron

Hi,
Ithought that I found the solution
At every field definition you can set de Data Format, I set that to a comma setting (The last option)
Then I put a value in the field, the value of course with a comma, no problem
However, after saving the result was... comma became period AND the given value was truncated So, what goes wrong?

Hi,
Anyone a solution for a Decimal comma?

Ron

Hi,

you can change the data formats in "dataFormats.cfg" in AppGini\add-ons folder.

i SkayyHH ,
Thank you for the reply, however
The field is not a currency field, so I've selected Points for Thousands and Comma for 2 decimals

The value given in the field has to be (I want) with a decimal point instead the wanted decimal comma

Oh, i understand.

Sorry, i can´t help with this. This need to be coded from a professional

Have you ask chatGPT? It can help with code and know how to place the it.

Hi Skayyhh,
Thank you for your reply, however I’m not going to program my self.
If this functionality doesn’t work well then it is up to AppGini to modify
Ron

Hello Ronp

Add this line to the dataformats.cfg file:

DESCRIPTION IN MENU ( Sample 21.345,67); CONCAT(' ', FORMAT(%%FIELD%%, 2, 'de_DE'))

It solves the problem when displaying the field, but it does not display when the field is being edited.

There may be problems with fields where "Show column sum" is checked, AG sometimes cannot display the field correctly, but I believe it is a bug in AG because it does not occur in all tables.

I hope this helps and good luck.

Hi Marcelo,

Great, it works. Unfraternally not on the Total field, but I can live with that
Thank you

Ron