Use Record Picker to filter records in related Grid

Hi, I looked for something similar, but could not find it, so I guess I’ll ask :slight_smile:

Let’s say I have a two tables: [Projects] and [Tasks] where each Task has a “Project” linked field.

What I want, is to make an interface where I select a Project from a Record Picker and it will show me a grid with related tasks, where I can edit and add new tasks for this particular project.

I tried using a Filter, but since “Project” it’s a linked field - it does not allow the user to pick a project from the dropdown but it forces them to type in project name. So this will not fly. I would love any suggestions.

4 Likes