I’ve recently encountered a problem when editing a table field of type boolean in Retool, which maps to a BIT column in MS SQL.
When I edit the field, the changesetArray looks like this:
[
{
"Zamek": true,
"ID": 90789
}
]
However, Retool sends NULL to the database in the Zamek column instead of 1. This definitely worked in the past, but I can’t pinpoint when it stopped working.
Has anyone experienced something similar or knows a workaround?
Yes, same issue. I just created an account to report this issue. We have a similar issue with Postgres boolean field. A user is attempting to uncheck a checkbox.
Retool previously would correctly send a boolean value "false" when the user removed selection from checkboxes, and instead started sending "null", which causes an error (since all boolean fields in our db are not nullable).