I would like to get the older project entries from the same client in my projects Database, but when I create the relation to the same projects database, many-to-many, it creates two relation fields. Am I doing something wrong? Is there maybe an easier way to achieve this?
THanks!
Hi,Eva!
You’re not doing anything wrong - this is how self-relations work in Fibery. When you create a many-to-many relation from a database (like Projects) to itself, Fibery automatically creates two fields: one for each “end” of the relation. This is necessary so you can distinguish between the two sides of the relationship (for example, “Related Projects” and “Projects Related To This One”; “Projects that are blockers for” and “Projects that are blocked by”).
You can rename these fields to make their purpose clearer
But if your goal is to get all older projects for the same client, you might not need a self-relation at all. Instead, you can:
- Make sure each Project has a relation to a Client.
- Use a filtered view or a formula to show all other Projects for the same Client where the creation date is before the current Project.
Does that make more sense?
I want to be able to compare all the projects by the same client. I have automated the self-link for the client. And it works, But, the problem is that I have already deleted the database, 2 times, thinking that it’s doubled…I guess I will have to put a don’t delete in the title
I want to be able to see this from inside the view of the entity, so the filter thing does not work.
I have tried with the lookup list, but it’s a mess, since I can not order the fields that are shown…
What does it mean “Blockers for and blockers by”?
To be honest, the relationships are a bit complicated to understand, too many types…I guess I just have to get used to it.