Number field values unintentionally changed

Classic Servoy
1

It seems that if you click in a number field with a specified display format, Servoy overwrites the actual value with the displayed value as soon as you click out of it.

This is a problem for us because we use Servoy for 21 CFR Part 11 compliance, and it causes unintentional data changes and audit trail records.

Ideally the display format should be independent of the stored value. Other applications handle this by showing you the actual value when you click in the field to modify it. Could this be done in a future version of Servoy?

2

Hi Sammy,

The formatting can have a display and edit format. When you don’t give the edit format it will use the display format for that.

Syntax: displayformat|editformat

In your case you want to use edit format ‘raw’ for no formatting whatsoever.
So just add |raw to your format.

Hope this helps.

3

Excellent, thanks!