View only particular user task

AppSheet AppSheet Q&A
,
1

Hello.

I have 2 views in my app

  1. “Tasks”(Task name, description, Projects, assigned to, status, start and end date, budget).

  2. Projects(Project name, description)

  3. I want a third view as “My Tasks” where an employee has to see only his tasks.

Please help. Thank you.

@Steve

2

look at the formula select()

3

You can make use of Security Filter for this

https://support.google.com/appsheet/answer/10104977

1 Like
4

in points 1 and 2, employees can also see all tasks ?

5

Sorry security filter will be applied to all views

Other options that i find are

  1. LINKTOFILTEREDVIEW() https://support.google.com/appsheet/answer/10107338?hl=en

  2. Creating a Slice from Original Table with Filtered Data and Linking last view with this Slice

  3. Using IF(CONTEX(“View”)=“Third_View”,[Employee]=Usersettings(Name),TRUE) in SECURITY FILTER

3rd option i am not sure whether it will work but can try it. If it works then I guess Its the best choice among the 3

2 Likes
6

it seems to me the simplest thing is to add a colum to task column email and then select where is usermail() = email

2 Likes
7

Limit users to their own data - AppSheet Help

1 Like