Problem with BIT field editing – Retool sends NULL instead of true/false

Hi,

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?

Thanks!

Seems we have a similar issue
Changeset Bug When Updating Boolean - :speech_balloon: App Building - Retool Forum

Yes, that looks like the same issue.

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).

Issue now fixed see this thread - Bug Report on Table Component Save - #3 by Darren

Thanks for spreading the word, @cah23! Welcome to the community. :slightly_smiling_face:

To everybody else, please let us know if you notice any lingering issues, but this should now be fixed as of Cloud version 3.185.0.