Reference tables

Bianca_Baias · 07-19-2021 04:49 PM

I have the following hierarchy of parent to child table relationships:

-Project
– Project Plan
— Project Task
---- Project Task Assignee

EDIT Each project task assignee is a relationship of one assignee to one task, and there are as many rows as there are assignees.

I would like to know if it is possible to 1 list each project assignee from each task that relates to a project in one single table, each only showing up once.

I then would like to be able to search that list and show the details of a project only if they are listed as an assignee in that project.

How should I be organizing the data, what formulas do I need to use?

Lynn

Hi @Bianca_Baias
Have you had a look at the sample apps. I think there are some project Apps in there.

Bianca_Baias

I have, and they are significantly less detailed than what we are working with. We have multiple assignees per one task.

Steve

I’d think the easiest approach would be to roll-up the sets from below:

In the Project Plans table, add a virtual column named Project Task Assignees with an App formula expression of UNIQUE([Related Project Tasks][Related Project Task Assignees]).
Then, in the Projects table, also add a virtual column named Project Task Assignees with an App formula expression of UNIQUE([Related Project Plans][Project Task Assignees]).