Avatar

Level 4

Hi @nitesh_anwani ,

A field of type Integer will not let you store a NULL value in the database table. However, depending on your use case, you could create an input form for data visualization and code it in a way to display nothing in case the value stored is 0.

P.S. This workaround is suitable only if the data to be stored in the table does not have any "0" value records.

 

Alternatively, you can change the field type from Integer to a String to work it out. It will come with some downsides, such as query responses based on this field, etc.

 

Thanks,

Ishan