# Making a quicker filter

**URL:** <https://forums.knack.com/t/making-a-quicker-filter/17851>\
**Category:** Tips & Tricks\
**Created:** [September 6, 2024, 2:07pm UTC](https://forums.knack.com/t/making-a-quicker-filter/17851 "2024-09-06T14:07:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GSH](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/gsh/32/2669_2.png) [@GSH](https://forums.knack.com/u/GSH)\
**Post date:** [September 6, 2024, 2:07pm UTC](https://forums.knack.com/t/making-a-quicker-filter/17851/1 "2024-09-06T14:07:04Z")

</div>

Is there any way that you can have a drop-down populated with a particular field - like Clients - and then the display updates accordingly.

So I have a table that shows campaigns. I select the client and the table updates with those campaigns assigned to those clients. I want something dynamic and don’t have the patience to update manually filters each time clients are on the system so this would be helpful if someone knew how.

Thanks

---

<div class="post-metadata">

**Author:** ![John\_Prescriptive.Solutions](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/john_prescriptive.solutions/32/1420_2.png) [@John\_Prescriptive.Solutions](https://forums.knack.com/u/John_Prescriptive.Solutions)\
**Post date:** [September 11, 2024, 9:48pm UTC](https://forums.knack.com/t/making-a-quicker-filter/17851/2 "2024-09-11T21:48:09Z")

</div>

I would also like to be able to do this. A quick easy filter from a drop-down list would be great.

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [September 12, 2024, 11:15pm UTC](https://forums.knack.com/t/making-a-quicker-filter/17851/3 "2024-09-12T23:15:37Z")

</div>

@GSH I may not quite understand what you mean, but a simple way is to have the following:

- A connection to the Customer table in your Accounts table
- Add a form to ‘update the logged-in user’, which contains that Customer field, with a submit rule that redirects to the same page
- Add a grid view below which shows ‘campaigns connected to same customer as logged-in user’  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/3/369f9748d8937fb5f79767f176adf8aed43a8241.png)

This way you have a field which will be preset with the customer you viewed as previously, and it’s a simple matter of updating the Customer field, and waiting for the page to refresh with the updated results in the grid.

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

The alternative is using some JS which checks for a form field updating and auto-updates the grid, but for the effort to do this, you may as well use the above method or a search view.

Let me know what you think!

---

<div class="post-metadata">

**Author:** ![GSH](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/gsh/32/2669_2.png) [@GSH](https://forums.knack.com/u/GSH)\
**Post date:** [September 14, 2024, 6:20am UTC](https://forums.knack.com/t/making-a-quicker-filter/17851/4 "2024-09-14T06:20:07Z")

</div>

Thanks for sharing this, I have parked this code and will test it out, thanks.