Filtering in a form

Hi Glide Community,

I’m working on building a form to add new tasks in my app, and I’ve hit a roadblock with filtering a choice component. Here’s what I’m trying to do:

  1. I have a Tasks table and a Client Processes table.

  2. In the form to add a new task, I want to first select a Client for the task.

  3. After selecting the client, I want to filter the options in the Client Processes choice component based on the selected client.

However, I’m only able to filter the choice component based on fields in the Tasks table, not on the Client Processes table. This is problematic because not all client processes are displayed in the Tasks table, so filtering this way doesn’t work for me.

Is there another approach or workaround to filter the Client Processes choice component based on the selected Client ID/name? Any advice would be greatly appreciated!

In the screenshot - the Client Process should be filtered for “Jono”

Thanks in advance!

Check your filter. You should have an option to filter based on Screen Values, so you should be able to filter based on the selected client value.

1 Like