The only references I have found to this sort of problem are ...
... none of which answer the question.
For me it is not important whether commas or dots are used.
What is important is to be able to to use the numeric keypad to write the decimal point instead of being obliged to use the ','.
I guess you don't need to enter dot for thousand, then use auto-enter calculation (replace existing value) for the number field
Substitute ( Self ; "." ; "," )
will replace all dot entered from num pad to comma then used as decimal point.
Thank you user19752.
That seems to work very well using "." for the thousands separation > 1.000.000,00
I had the same problem (on Windows, Dutch number format (i.e. comma as decimal symbol), working with keypad with International Keyboard Layout). When entering € 123,45 (one hundred and twenty-three euros and forty-five cents), Filemaker registered € 12.345,- (twelve thousand three hundred and forty-five euro).
The provided solution does its trick. When I enter a decimal via the keypad, Filemaker registers a 'period', that is substituted by a 'comma'. In other words, when entering € 123,45 Filemaker converts it to € 123.45 and stores it in the database. By configuring the Data Formatting-settings of this specific field, Filemaker displays the value as "€ 123,45".
My question is: Is this really the only solution to this problem?? It implies that I have to remember to use ' Auto-enter calculation' for EACH number field in my database.
The strangest thing is, that only Filemaker acts in this way. For example Excel correctly 'sees' the decimal-button on my keypad as a comma (since that is the Region settings of my operating system).