In my app, as a admin I can approve or reject client request. I want to filter so that user can see only own post/submission not others but admin user can see all post. When I apply filter ‘signed in user’ then i am also treated as user not admin, I am using single app for submission and approval. Here i have customized edit option to approve/reject any submission.
I have to make some assumptions here as can’t see your App:
Assuming under sheet=users , there is a column called “Role” - and for each user row, this column is Admin or empty (empty means not-admin)
Assuming also you have a column in the sheet capturing submission info to store posted_by_user, hence ownership -
In your form, the User’s email form this special form value will go to this “posted_by_user” column.
Now, under the inline list of all submitted records, going to visibility set two OR conditions
Condition 1: when posted_by_user = Sign-in User
Condition 2: User_Role=Admin
You helped to fix it almost, but I like to share something about my app.
In my app, there are two sheets one is user and other is user submission. As u suggested, it works for both admin and other user. But I need to know that when admin user can see all submitted data via inline list not directly from submission sheet where only signed in user can see not other. Is it possible to see all data from submission sheet as admin.
Here is my problem details: I have two sheet called Employee list and leave application. As admin I can edit data posted by other user and view them from User tab with help of inline list. That,s enough for now but how i can apply filter on second tab(leave application) so that admin can see all record from second tab but other users only their own.
First Pic:As admin I can see all data for respective user from ‘Employee list’ tab whereas user can see own data not others. (Working properly)