I have a doubt if it can be done or not. I explain the problem.
I have created a calendar where different people can enter reservations based on room availability with a check on the dates.
I would like to make the calendar visible to all people who use the app but everyone can only see and modify the data entered by themselves while the admin can do everything.
It allows you to identify each user and the rows they create individually, from then it becomes a simple task of making the views for your users based on slices with expressions like:
[createdBy]=INDEX(currentUser[email],1)
Do give that post a look, it will change your AppSheet life.
but I don’t understand if by implementing that function I limit the user to access with his email entered in the database, but it does not limit access to the non-data view of the calendar shared by other users.
If you have a user system you can just make slices for all your views that allow users to see only the rows that have their email on it, but in case they are an administrator, they can see everything, something like this could be your slice expression:
yes correct as regards the Admin part , which sees everything .
I explain the problem better so you can understand … I have a shared room reservation calendar where 3 people can enter reservations but between they must not see the data entered for privacy.
The risk is that by limiting the display I find myself having multiple calendars for each referent and no longer just one. In the sense.
The calendar is unique for everyone.
-Everyone can check the availability of the room if it is free or already booked
-only admin sees all fields.
-individual referents only their data but at the same time the availability of the rooms on the shared calendar.
Yeah bro, I understand the problem, and my answer still stands, you just need to show each user their own entries of the calendar, and when they try to book a room that information is available to everyone.
Place your faith in the user system and give it a shot and you might understand it better
When you open any view that is not system generated you can choose the table on which the view is based on, use this to select the slice that you have created and give it a test with your own email to see if the slice expression works
