It’s unclear what user experience you are building, maybe you could share more in detail.
Without knowing the details, I would suggest you use action components (such as a button) in a collection (collections are a component type in the Layout Editor) or on details screen (the screen you can navigate to after clicking on a collection item).
It’s a simple portal application with a single button and two types of user: admin and a user. Created a button. That button only affects the admin and NOT the user.
Summary: set a visibility condition on the button or condition on the action by pointing to a column in the Users table.
When you select the button component, on the right you can configure it. Head to the second tab called “Options”, and there you can set a visibility condition which you set by pointing to the Users table and column where you set the roles.
Alternatively, the button triggers an action. You can also set conditions at the action level when you choose the action in the Layout Editor. Same as above, you would set the conditions a column in the Users table.
If you’re wanting to make a button that is only visible to admins, make sure you have a boolean column in the Users table (Call it “Admin?” or something), and you simply check the boolean for users you want to make admin. This item is for the item you’re looking at. If the button’s on a detail screen, it will be for the item that detail screen is for. If it’s inside a collection, it will be for that item you click the button from. You should use User Profile > User Profile Row all the time, that is always gonna be for the row of the signed in user in the Users table. So just set your button’s visiblity condition to User Profile > User Profile Row > Admin? is checked.
What I am trying to achieve is hide all normal users on some screen (I rely on Visibility) once the admin sets a boolean value from a different screen?
You use a Single Value > first in your Users table and point it to the “helper” table above. “Cast” means getting that value to show up in all rows.
If you need to access to write to single row table from user table, so one of the way is use silgle value whole row and use it in set column action or open edit screen using Single value from whole row