Data Grid Does Not Null Numbers

Team ID: https://go.glideapps.com/o/2RW8azIPl2eRpRjIOAWV

App ID: https://go.glideapps.com/app/SAQAgCirLfiMdKmi8Zl6/layout

Description

  • When deleting a number value in a Data Grid, it makes the number 0 instead of null. This is an issue as in many cases, the number 0 represents an accurate user input (in our case, the temperature of a freezer)
  • However, when you delete the value in the Glide Table, it indeed nulls the value and does not make it 0
  • This causes us issues as we base logic to assure the user inputted a value in the data grid. If it is null, the app knows that the user needs to put in a value. If it is 0, the app will register that as the value that the user entered

What if you make it a text column instead of numeric?

Unfortunately I am using the value in a Math calculation once it’s entered. It would have to be a numeric column to be able to be taken as a number value in a Math column, right?

Not necessarily.

1 Like