PostgreSQL Server Connect Form boolean not showing in DB

Wappler General Need Help
, ,
1

I've connected my PostgreSQL database to my Wappler Project and I can successfully get data from the database and post to it. However I have a Boolean column in the DB and a Server Connect form that posts either a true or false value when I submit the form. The record is created in the DB however the Boolean column shows as empty and the value of true or false is not being created.

Does anyone know how to pass a Boolean value from a Server Connect form to a PSQL database?

2

Perhaps the form values for the boolean field being posted are in a string format. This can be checked in dev console under Payload in the Network tab after submitting the form.

You can also try by posting 1 or 0 value for the boolean column.

3

Just tried that and it's still not working.
image

The values are indeed strings, however I just changed them to 0 and 1 and the database is stilling showing "[null]" for the value

4

A couple of things.

  1. Check whether the posted form id is the same as allowSupplierPricing in the database.
  2. Set the allowSupplierPricing to no null allowed field type. As a boolean, only allow 1 or 0 values in the database.
5

I just figured out the mistake. It seems like the Database Query action had pulled another field and was not submitting the allowedSupplierPricing field, so when the user kept submitting to the API an empty field was being sent in the Database Insert query.

1 Like