Unable to update checkbox field

[jdamrau]

Hi

I am having difficulties updating a checkbox field in my database table, golfers. What I have tried to do is follow the online demonstrations and on the community for a solution and found many ways to do it but everything I tried does not update the database field.

I built a very simple form with two checkboxes labeled golfer1_paid and golf2_paid. In the database golfer1_paid is a boolean field and golfer2_paid is varchar field. A query is done on the field (payee_email), included in the URL. This query is used to call the database record to update.

A snapshot of my Wappler window shows the code used to build the form. My problem is when I submit the form the checkboxes do not update. Can please let me know what I am doing wrong?

Screenshot 2021-08-01 110051|690x492

box fields

[jdamrau]

[sitestreet]

I always do checkboxes as number fields in the database update instead of boolean. Not sure if that is either a good way or will fix it but I’ve not had any problems.

[Antony]

Have you tried working through this post?

(Can’t paste the url from my iPhone! )

Search for this title…

Read and Write Boolean Values to Checkboxes

[Sorry_Duh]

Read and Write Boolean Values to Checkboxes

Wow… I’ve just spent forever working out how to do this and reading lots of posts that seemed very confusing for quite a while… So here, while it is fresh in my head, is the bullet point summary of how to read and write boolean values to Checkboxes. Background Information In following why it is done this way, there are a couple of things to be aware of: The result of an HTML <checkbox> tag’s setting isn’t the “value” attribute like HTML <input> tags, they have a value representing their …

@Antony’s link for you

[mebeingken]

Your condition in the update is using a GET variable but you are using a POST method.

[jdamrau]

Thank you Anthony. I must have reviewed that article 4 times and did not find the problem. What I was doing wrong was with the bind statement.

dmx-bind:checked=“sc_get_golfers.data.query[0].golfer3_paid.value”>

I was not including the .value phrase to the end.

Problem has been resolved.