# For "hide entity view rule" - allow relation "contains/does not contain" on formula fields

**URL:** <https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512>\
**Category:** Ideas & Features\
**Tags:** entity-view, formulas\
**Created:** [March 9, 2026, 11:10am UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512 "2026-03-09T11:10:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Ichter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michael_ichter/32/9931_2.png) [@Michael\_Ichter](https://community.fibery.io/u/Michael_Ichter)\
**Post date:** [March 9, 2026, 11:10am UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512/1 "2026-03-09T11:10:26Z")

</div>

I’m loving the “hide entity view rule” feature! It’s been a great QoL improvement for us. I’m just facing one limitation. I’m trying to hide a couple entity views based off of users’ membership in departments. Users can be in multiple departments (many-to-many relation), so the relation field does not appear as an option for filtering. I have a formula field that lists the departments a user is a part of, but I can only use “is” or “is not” for hiding the entity view based off of this formula field. Having “does not contain” would resolve this.

E.g. Samantha is a part of Recruitment and Onboarding, and Rich is only a part of Onboarding. They have access to the same database, and each department has their own relevant entity view. Samantha should see both views, and Rich should only see the onboarding view. So I want to hide the recruitment view for Rich (hide when User.DepartmentFormula does not contain “”).

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [March 9, 2026, 12:50pm UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512/2 "2026-03-09T12:50:50Z")

</div>

> [@Michael\_Ichter](#):
>
> Users can be in multiple departments (many-to-many relation), so the relation field does not appear as an option for filtering.

we will allow to use many-to-many relations in Hide View rules

---

<div class="post-metadata">

**Author:** ![Michael\_Ichter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/michael_ichter/32/9931_2.png) [@Michael\_Ichter](https://community.fibery.io/u/Michael_Ichter)\
**Post date:** [March 9, 2026, 2:59pm UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512/3 "2026-03-09T14:59:24Z")

</div>

Sorry, I just realized that the field in question is actually a look up field, not a m2m relation. Would a look up field also work for this use case?

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [March 12, 2026, 1:33pm UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512/4 "2026-03-12T13:33:29Z")

</div>

M2M support added in latest release

> [@March 12, 2026 / moon\_viewing\_ceremony Better file support in Table View, Block reordering in text editor, History API](https://community.fibery.io/t/march-12-2026-better-file-support-in-table-view-block-reordering-in-text-editor-history-api/10537):
>
> moon_viewing_ceremony Better file support in Table View Working with files in Table View just got easier. You can now upload files directly in table cells: click +, press Enter, double-click on focused cell, or simply drag and drop a file into a cell. Files can be previewed or downloaded right from the table. We’ve also added new ways to display files, including Compact List, Count, and Gallery views. smiling_face_with_sunglasses Block reordering in the Editor Moving paragraphs, …

---

<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:** [March 12, 2026, 7:47pm UTC](https://community.fibery.io/t/for-hide-entity-view-rule-allow-relation-contains-does-not-contain-on-formula-fields/10512/5 "2026-03-12T19:47:39Z")

</div>


