Show if only to user

AppSheet AppSheet Q&A
1

I had copied the Project Management App from the sample app.

In the status view I want to show the status as per Assigned To. The user should see only the task which they are assigned and i also want two users to see all the task as they are Managers.

2

To be able to do that on the sample app, you need to do the followings:

  1. Add a new column to the Marketing project plan table to identify the email for the assigned to column, let’s call this as [Email]

  2. Create a slice with row filter condition:

	OR(
		IN(USEREMAIL(), LIST([Email])),
		IN(USEREMAIL(), LIST("manager1@test.com", "youremail@gmail.com"))
	)
  1. Change “By Status” View to point to the new created slice.
2 Likes
3

I had created the slice, but now it is showing the status of all the assigned email but not showing the “manager1@test.com” (i had changed to my managers id)

4

LISIE_CENTERAL_TRUST:

but not showing

It’s not clear to me, maybe the manager’s email is not available on the [Email] column?

Would you share a screen shoot of the emulator to clarify what the issue is?

5

LISIE_CENTERAL_TRUST:

(i had changed to my managers id)

If you did this in the emulator in the app editor, it may be that the emulator’s ability to fully present an alternate email address to the app is buggy. You may do well to contact support@appsheet.com for help with this problem.

2 Likes
6

I believe the emulator is buggy regarding using an inputted email address. It has gotten better in the five months I’ve been using it but I have multiple places that reference the USEREMAIL() and pulls info from my USERS table based on that value. It often pulls the value for my record in the USERS table instead of the data associated with the email address showing at the top of the emulator.

2 Likes