Boolean Update Bug After Bulk Edit in Retool Table Component
The Issue
When I perform a bulk update operation on a table and try to subsequently update a boolean value, the system fails to update the boolean correctly. Instead, it seems to be using the value from the last edited attribute before the boolean.
Steps to Reproduce
- Open a table (I'm using a bookingsTable component)
- Do a bulk edit operation on any field
- Click save to apply those changes
- Try to update a boolean field immediately after
- The update fails
Error Details
Looking at the console, I can see this error:
bulkEditBookings failed (0.884s): update "world_discovery"."bookings" set "is_vip" = $1, "updated_by" = $2 where "id" = $3 - invalid input syntax for type boolean: "booked"
It looks like it's trying to assign "booked" (which was likely the value I was just working with) to a boolean field instead of a proper boolean value.
The error happens in the bookingsTable save event handler, according to the logs.
Has anyone else run into this issue?
Thanks!
