Number custom field
there are inconsistencies when creating a Number type custom field.
The comboBox "Decimal places" doesn't select number of digits to the right of the decimal point. It sets DB Precision which is the number of digits allows for this number. So for set scale we have to made it in Advanced section.
Also "DB Precision" field are not use when column is created, it's automatically set to 20 in precision.
This field can allow empty value, but if you don't fill it. It's initialized to 0 in database.
Actually the field does initialize itself with a null value, but since OpenAccess doesn't support int?(nullable) type, it puts an int(regular) in the view-model and this is why when you republish the item, it gets the value from the view model and puts it in the database - if you check the database before you republish the item, you will see that the value is null.
As for the inconsistencies - this really seems a little confusing by design, so we will consider changing it for our future releases. Thanks for the suggestion.