Please fix datepickers and "" vs. null

[MiguelOrtiz]

Hey there @ben_inkana,

Yeah, I completely get you.

I don't think this would change any time soon, see this post from a retool member some time ago:

Saving Empty Date Fields to Retool Database (Revisit 2)

Hello @Ross_Coombes, Thank you for this feedback. I completely agree, it should be as easy has passing in {{myForm.data}} and in a perfect world, users should not need to sanitize their data to replace "" with null values. I believe the root cause of this problem is stemming from some very old and deeply embedded code from the early days of Retool, that to replace would involve a massive overhaul of the Form component. For update queries to Retool DB, Joe's solution in the linked thread, of a…

Something you could do is create a global function (if you have beta functionality enabled in your account) so you can recicle that each time with a simple function and not having to write inline js or transforfmers.