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

💬 App Building
, ,
1

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!

2

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

3

Yes, that looks like the same issue.

4

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

5

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

6

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.