# Formula fields that are filtered by the context they're viewed in

**URL:** <https://community.fibery.io/t/formula-fields-that-are-filtered-by-the-context-theyre-viewed-in/6623>\
**Category:** Ideas & Features\
**Created:** [September 10, 2024, 7:55pm UTC](https://community.fibery.io/t/formula-fields-that-are-filtered-by-the-context-theyre-viewed-in/6623 "2024-09-10T19:55:56Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![Sev](https://avatars.discourse-cdn.com/v4/letter/s/90db22/32.png) [@Sev](https://community.fibery.io/u/Sev)\
**Post date:** [September 5, 2025, 12:05am UTC](https://community.fibery.io/t/formula-fields-that-are-filtered-by-the-context-theyre-viewed-in/6623/8 "2025-09-05T00:05:57Z")

</div>

@danielbmarsh for anybody who reads this, I am linking my [answer](https://community.fibery.io/t/relationship-properties/887/33) to your similar three-table [scenario](https://community.fibery.io/t/relationship-properties/887/32), which you had explained. It may help future readers that want to expose the fields of an entity that is only related to the current entity through a middle/junction entity.

Though if you do not need to edit, you should be able to use lookup fields or formulas that return the related entities, such as emails in this case.

---

_[View the full topic](https://community.fibery.io/t/formula-fields-that-are-filtered-by-the-context-theyre-viewed-in/6623)._