I have got table project, tasks, resources,re...

(Taran Bhagat) #1

I have got table project, tasks, resources,reports,photos? I can display tasks of a project using the condition project[email ID]=USEREMAIL() which

Now I want to create a slice (named Abstract) to display selected columns from task table , belonging to the specific project created by the same UESREMAIL(). I am not finding a proper solution. Is it possible to create a slice from task

which can display tasks of a project created by a user?

(Taran Bhagat) #2

#ERROR!

(Bellave Jayaram) #3

If you have a Ref column to Project in Tasks table, and you have a column called CreatedBy in Project table, use the filter USEREMAIL() = [Project].[CreatedBy]

(Taran Bhagat) #4

@Bellave_Jayaram i dnt have a column CreateddBy in the project table. Do I have to create it?

(Bellave Jayaram) #5

I just gave CreatedBy as an example. If you have any column that saves the email of the user who created that project row, you can use that. If not, you will have to create a column, yes.

(Taran Bhagat) #6

I already have a column [email ID] in table project. Hence I wrote USEREMAIL()=[project].[email ID]. But when I view the slice “Abstract” it is displaying all the columns which are not created by me. I am sending screen -shots please.

(Taran Bhagat) #7
(Bellave Jayaram) #8

Add project to the slice.