View only particular user task

[swetha27]

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 

[koma25]

look at the formula select()

[jyothis_m]

You can make use of Security Filter for this

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

[koma25]

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

[jyothis_m]

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

[koma25 · Accepted solution]

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

[Steve]

Limit users to their own data - AppSheet Help