# Filter table results by user's address \> state

**URL:** <https://forums.knack.com/t/filter-table-results-by-users-address-state/19807>\
**Category:** Get Answers\
**Created:** [September 2, 2025, 12:49pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807 "2025-09-02T12:49:49Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brady](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Brady](https://forums.knack.com/u/Brady)\
**Post date:** [September 2, 2025, 12:49pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807/1 "2025-09-02T12:49:50Z")

</div>

Is there a way to setup filtering table results by a user’s address \> state? I want to automatically only show table results to a user where their address \> state matches a state field for a product. I’m not seeing a way and maybe it’s just too complex of a need for this solution.

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [September 2, 2025, 9:25pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807/2 "2025-09-02T21:25:31Z")

</div>

Hi

Try creating a text formula using getAddressState see [Text Formula Functions](https://learn.knack.com/article/z2uiemxq8t-text-formula-functions)

Dean

---

<div class="post-metadata">

**Author:** ![Brady](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Brady](https://forums.knack.com/u/Brady)\
**Post date:** [September 2, 2025, 11:04pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807/3 "2025-09-02T23:04:00Z")

</div>

Thanks, it looks promising but I’m not seeing where a text formula can be set as a filter. Do you know where?

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [September 2, 2025, 11:49pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807/4 "2025-09-02T23:49:30Z")

</div>

Hi

Here’s what I quickly knocked up.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/d/ddb68f9091b30ead282618c2dd309500e6b98112.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/6/662ff7d13b886793986e8f2a6115e9b5e2729d4d.png)

Dean

---

<div class="post-metadata">

**Author:** ![Brady](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@Brady](https://forums.knack.com/u/Brady)\
**Post date:** [September 3, 2025, 1:37pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807/5 "2025-09-03T13:37:05Z")

</div>

Thanks, I understand how to extract the _State_ from an address using a formula. My actual question, though, is about _using that State value to dynamically filter access to records_ — so that a user with `State = X` only sees records where `State = X`.

From what I can tell, there doesn’t seem to be a way to do this kind of **automatic, dynamic filtering** based on the user’s value — at least not natively. Let me know if I’m missing something that enables that.

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [September 3, 2025, 9:45pm UTC](https://forums.knack.com/t/filter-table-results-by-users-address-state/19807/6 "2025-09-03T21:45:31Z")

</div>

Hi

Maybe try using [User Roles & Permissions](https://learn.knack.com/article/d825xqgg0f-manage-roles-permissions) to achieve this.

Dean