I am creating a form view for my team to log their hours on various projects. The current setup includes a table with rows for team member name (linked to another table), project name (linked to a ‘projects’ table), task description (text), and time (duration). However, there is an issue: when team members enter their time, the dropdown menu for project names displays all company projects, not just the ones they are assigned to. How can I modify the table and form so that team members only see the projects they are involved in when selecting a project name? In the projects table, each project has a multi-select field listing the names of the team members assigned to it. Thanks in advance (TIA).
Hey @pdhym, this feature should address your use case: Filter linked table records by a field (#1242) · Issues · Baserow / baserow · GitLab. It’s expected to be released in the next few months.