# Update a boolean field in DB : does not work

**URL:** <https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227>\
**Category:** Get Help\
**Created:** [June 13, 2022, 12:54pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227 "2022-06-13T12:54:07Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 13, 2022, 12:54pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/1 "2022-06-13T12:54:07Z")

</div>

Hello Adalo team,

I am really struggling with a simple update of the boolean field “aboard” in users table. The button “Passer” is supposed to launch this update but I keep getting the same standard error message during my tests, see below :  
Can you please help?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/7/e/7ee4f20bfa0ff7ee233b8cb26ef4c657d972cb35.jpeg)

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [June 13, 2022, 12:57pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/2 "2022-06-13T12:57:40Z")

</div>

Hi @Sonic1,

Welcome to the community 🥳

You are trying to update logged in user record or another user’s record?

Thank you

---

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 13, 2022, 12:59pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/3 "2022-06-13T12:59:12Z")

</div>

Thanks for your reply Dilon.

No, it is the same logged in user we are trying to update.

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [June 13, 2022, 1:00pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/4 "2022-06-13T13:00:33Z")

</div>

Can you record a video and it here showing the setup and preview?

And also are you on the free plan or paid plan?

---

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 13, 2022, 1:03pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/5 "2022-06-13T13:03:34Z")

</div>

I am on the paid plan.

To get the error, just launch the app, click “Consultation libre” then “OK” in the modal then click “Passer”

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [June 13, 2022, 1:22pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/6 "2022-06-13T13:22:58Z")

</div>

> [@Sonic1](#):
>
> I am on the paid plan.

👌

> [@Sonic1](#):
>
> To get the error, just launch the app, click “Consultation libre” then “OK” in the modal then click “Passer”

Could you record this and add it here? And include the setup in that recording too!

---

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 13, 2022, 2:08pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/7 "2022-06-13T14:08:21Z")

</div>

Sorry, I am unable to produce a webp file.

Here is the link to the video :  
[https://we.tl/t-jAEYoyBgyW](https://we.tl/t-jAEYoyBgyW)

---

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 13, 2022, 4:24pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/8 "2022-06-13T16:24:26Z")

</div>

Also, I tried setting that update on the logged in user in the actions of the screen, still did not work out, with same error message : “action cannot be completed”

---

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 13, 2022, 4:31pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/9 "2022-06-13T16:31:57Z")

</div>

Okay, I found the issue : permissions in database, edit was disabled for that field.  
Now it works.

Reference to Victor’s post : [Users record is not able to update](https://forum.adalo.com/t/users-record-is-not-able-to-update/20254)

Thanks for your help guys

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [June 14, 2022, 4:16am UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/10 "2022-06-14T04:16:14Z")

</div>

Hi @Sonic1,

Sorry for the late reply!

After watching the video,

1. For the Login form do you have conditional actions? Check this post by Victor : [My app is making me enter login details twice - #4 by Victor](https://forum.adalo.com/t/my-app-is-making-me-enter-login-details-twice/22237/4)

2. For the Action Cannot be completed issue you have update that true/false property permissions to Nobody? And then you have changed it to Record creator and working?  
Happy that you have found the Victor’s post and it’s solved your issue!

Thank you

---

<div class="post-metadata">

**Author:** ![Sonic1](https://avatars.discourse-cdn.com/v4/letter/s/dbc845/32.png) [@Sonic1](https://forum.adalo.com/u/Sonic1)\
**Post date:** [June 14, 2022, 12:50pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/11 "2022-06-14T12:50:22Z")

</div>

hello Dilon, thanks for the trick regarding the login page (point 1), it works perfectly now!

Have a good day Sir.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [June 24, 2022, 12:50pm UTC](https://forum.adalo.com/t/update-a-boolean-field-in-db-does-not-work/28227/12 "2022-06-24T12:50:54Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
