Users
hi, I have a database shared with several users.
I would like to protect the privacy of each single user, means not disclose its own work on the platform at the other.
What is the best way to do it?
Thanks in advance.
Max
14 replies
-
This is currently possible by placing the following into the "Is Readable" formula..
_cu = user()
This is called out in the user manaual here..
then search for "Readable If"
-
many thanks, this formula allowed to read the table or the records?
What if I would like to share the table with all the users but I would like to allow to read only the records each users created?
-
yes.. while the manual says "table".. in my testing, it is referring to the table ROW. So the above logic will PREVENT a user from seeing a row they did not create.
-
Hi many many thanks for your support, you were right and the formula works properly.
What if I would like to apply it at a single field record?
-
Similar logic.. put it in the "Display field only, if:" formula.
-
Thanks a lot, this about the formula field, and about the choice field?
-
sorry, got it and solve it, thanks.
as administrator could I have a full disclosure of teh records present in the db?
-
applying the _cu = user() formula at the "Display field only, if:" field this field disappear from the db structure if I access as a different user.
Is it possible to save the structure of the db and to hide only the record?
-
try:
userIsAdmin()
-
hi Alex, I tried:
1. add the userIsAdmin() in the "Display field only, if:" alone, before and after the _cu=user() using ; between the first and the second part of the formula
2. substitute the _cu=user() with _cu=userIsAdmin
no positive result. any other idea?
-
This seems to work for me.
user() = _cu or userIsAdmin() -
Many thanks Mike, it works for me too.
What if I would like to see who create the record?
-
create a formula and return _cu or 'Created by'
-
You are amazing, many thanks
Content aside
- 6 yrs agoLast active
- 14Replies
- 4869Views