Numeric Text Field & Null Values

Ignition
1

I have a window that edits numeric entries in a database table that allows NULL values. I can’t find any way to use Numeric Text fields and still allow NULL values. The only way I can think of is to use a text field but then I lose all of the built in numeric validation. Any suggestions?

2 
try({Root Container.Data}['ColumnName'], 0)
1 Like
3

Thanks Tim but I must be missing something. How does this help me enter nothing into a numeric text field?

4

Sorry thought you wanted to handle reading null values. you could use a formatted text field with the formatted mask pattern set to #. This would be equivalent to a text field which only allows numerical entries. But, if you want it to set your value to null you’d probably need to handle that in scripting your update statement.