Hi,
when I send a form with an empty field for timestamp with time zone, I get an error - invalid input syntax for type timestamp with time zone: ""
the PostgreSQL field is defined as
1 Like
Same problem for me.
There was a similar article where it was solved previously, but I can't get it to work with my form as well. Maybe you might have better luck than me.
https://community.retool.com/t/problem-saving-empty-date-fields-to-retool-db/17754/4
My solution to this same problem was to not use the K/V pair form, but instead use Object and created my own transformer form_to_row to produce the sanitized row from the form data.
