In some forms we want the open text field to be overwritten when the values are blank.
How can we achieve that?
with some mktoForm js you could change the field values to be "NULL" on submit if the field value is empty
The problem with simply setting the value to NULL using JS (and it's even more obvious if you set a default value) is the user sees the word NULL, which looks unprofessional IMO.
I have a blog post coming out next week where I show how to set the value to NULL while the field still looks empty to the end user (and no, it doesn't use a hidden field!).
In other words, instead of this confusing experience:
This smoother one:
Ah yes, I admit I forgot that the form field is still visible for a split second when you change values that way.
I would then probably just use js to add hidden fields for the fields that are empty and set the values of those to NULL. It might be hacky but I think it should work.