How to limit user to fill the fields in the form, but not see the list of records in that table
Hello!
I searched for the solution, but cant find it.
I have a tablet that i give to a client so he can fill the form in the table Clients. But i dont want him to be able to see other records in that table if he closes the form view.
I have two users - admin and client. The tablet accesses the db with client account. So i can restrict tables and fields.
But if i go to Edit fields... and put only admin in 'Allowed to read' field of table options, when i Create new record on the tablet i dont see any field. Even if i put Client in the rest of the üser rights' fields.
Is there a way?
1 reply
-
More details and thoughts:
All records created on the tablet are created by Client user. So if i put 'Created by' = user() in Readable if field, all recoreds created on the tab will be shown.
While writing the question i understood that if there is a way to hide all records in table view but being able to create a new record, then in the case when the clientunintentionally closes the form in the middle he can not return to it to complete it because it will not be shown )).
May be there is an option to show only the last record some how, like (not sure if code is right):
let CurRecId:=thisid=CurRecId.idAnd it will be shown until a new record is created??
Content aside
- 2 yrs agoLast active
- 1Replies
- 362Views