How to preserve null values in tables

[MiguelOrtiz]

Hi there @kt727, and welcome to the forum!

So, for null values there are 2 things you can do:

1- Number inputs have a "Validation" rule where you allow nulls
2- For strings and dates, you can transform the object to update in your query applying something like what is explained here

Unable to create a function that turns form values from empty strings into nulls

Hey there @Alen_Ramic and welcome to the forum. So, the way I usually approach this is to manipulate the changesetObject within my insert query, i do something like: {{ ({ ...form8.data, delivery: date1.value === "" ? null : date1.value }) }} In the same you can define all of your date values.

Hope this helps keeping null values persistent!