Conditional Formating is not working properly for non-admin user

Hello ,

I am Kuntay a new bubbler. I have been creating my idea on bubble since two months. It is almost as good as live applications with no expertise in creating something in IT , very glad to have bubble. I always trying to solve things one way or another. However , i stuck at this situation and thought maybe another users have this kind of problem so i want to share my experience.

I am creating user roles in my application. Main idea is disappearing the items,buttons etc. when that current user’s user permission to that group is no. It is working for the first user , also it is admin user however when admin user changes other users data on database to no , it disappears first then no toggling.

At first , What did i do ? , How is it working ?

  • There is a field called “user permissions” refers to a new table.
  • There is a table called “user permission”. In this table , there are group names(functions) field type is yes/no (no is default)
  • I have a “permission” page , a repeating group show users and their permissions.
  • When i click a user’s permission on that page , it changes the permission yes/no on database.

What is not working ?
When i create another user and set permissions for that user , group disappears ones and not coming back unless i clear all condition , it is true or false no matter. This is just for other users , that one admin user group visibility works as expected.

What have i checked ?

  • The data changes when i click on users permission on “permission” page.
  • When i do this with the one user (admin) , which i created at first to test every progress , it is working. I am turning groups and buttons on and off.
  • I did create another users to test the function , every other user has problems about visibility. When a group is disappear , i can get it back when clear all conditions.

Notes :
There is no workflow item for this functionality. I did try to overcome situation with workflows but no success , again it is ok with the admin user. (Triggering action , page load action)


While i was creating this post , i have solved it :smiley:

Solution.
-Privacy-
However , it is not what first comes mind. I did a privacy option first i created the table. It was : “Current user is the creator of user permission” ,so only administration is able to see the data behind user permission. That was what i thought. However , it is the reason why system acted bad. It just can’t reaching the data when other than created want to access the table. It is strange though , it applies privacy rule once loaded. I will change the rule safer but accessible.

Have a good bubbling everyone!