# Hierarchy challenge

**URL:** <https://community.fibery.io/t/hierarchy-challenge/5093>\
**Category:** Get Help\
**Created:** [September 7, 2023, 8:04am UTC](https://community.fibery.io/t/hierarchy-challenge/5093 "2023-09-07T08:04:21Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)\
**Post date:** [September 7, 2023, 8:04am UTC](https://community.fibery.io/t/hierarchy-challenge/5093/1 "2023-09-07T08:04:21Z")

</div>

I have a question kinda the simular to [this topic](https://community.fibery.io/t/challenges-with-hierarchy/4875). But since our structure if different I can’t seem to solve the puzzle with the solution in the previous post.

I have 3 databases. Product, Task and Phase

- Product has a many - one relation with Tasks
- Tasks has a many - one relation with Phase

Sometimes a product has a phase with tasks  
Sometimes a product has just tasks.

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/33ba478c5cfe6a7b88151ceeec50f1ce77252be8.png)

If possible, I would like to show in 1 grid view the products with tasks and products with phases and tasks.  
And from that same view users should also be able to create new tasks (with or without phases). See image below where Tasks C actually belongs to product B.

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/41d08c84043249d2c4ceba91c69b519c50415c67.png)

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [September 7, 2023, 3:20pm UTC](https://community.fibery.io/t/hierarchy-challenge/5093/2 "2023-09-07T15:20:48Z")

</div>

> [@Marloes](#):
>
> Sometimes a product has a phase with tasks  
> Sometimes a product has just tasks.

Does your Product DB have a relation to Phase and a separate relation to Tasks?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 7, 2023, 3:23pm UTC](https://community.fibery.io/t/hierarchy-challenge/5093/3 "2023-09-07T15:23:36Z")

</div>

Judging by the images, it must be linked to both

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 7, 2023, 3:29pm UTC](https://community.fibery.io/t/hierarchy-challenge/5093/4 "2023-09-07T15:29:38Z")

</div>

This is actually a specific example of a more general request for databases to be able to be present at multiple locations within a hierarchy.  
In this instance, the need is

> Product

> > Task

> > Phase

> > > Task

(i.e. Task db exists as a second level and a third level)

We have features in the backlog (for lists, smart folder and grid view) but no ETA

---

<div class="post-metadata">

**Author:** ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)\
**Post date:** [September 8, 2023, 6:30am UTC](https://community.fibery.io/t/hierarchy-challenge/5093/5 "2023-09-08T06:30:00Z")

</div>

> [@Chr1sG](#):
>
> (i.e. Task db exists as a second level and a third level)

Indeed, this is basicly what we want. The ability to show items from a database no matter what level they are in. Atm they are crossed out.

Untill then, is there a workaround to make it act the same? For example with formula’s (recursive??) or automations?

> [@Matt\_Blais](#):
>
> Does your Product DB have a relation to Phase and a separate relation to Tasks?

On top level (Product) I have a relation with both.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/9b9deaa6117031e61a4ffe13d89bfcbc935ddcfb.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [September 8, 2023, 6:45am UTC](https://community.fibery.io/t/hierarchy-challenge/5093/6 "2023-09-08T06:45:46Z")

</div>

> [@Marloes](#):
>
> is there a workaround to make it act the same?

Unfortunately not. Until support for a db appearing in two places is added, there’s nothing that formulas/automations can help with, sorry.

---

<div class="post-metadata">

**Author:** ![Marloes](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/marloes/32/5926_2.png) [@Marloes](https://community.fibery.io/u/Marloes)\
**Post date:** [September 8, 2023, 7:19am UTC](https://community.fibery.io/t/hierarchy-challenge/5093/7 "2023-09-08T07:19:34Z")

</div>

Thanks Chris. I will look for a different setup!
