Request: Filter Data Scope of Selection Fields Based on Other Filter Selections (e.g., Filter Assignees by Department)

Currently, NocoBase does not allow data scope to be filtered based on the values selected in other filter fields.

For example, I would like to filter the available options in the “Nhân viên thực hiện” (Assignee) selection field based on the selection made in the “Phòng ban” (Department) filter.

Currently, when I select a specific department in the “Phòng ban” filter, the list of users available in the “Nhân viên thực hiện” selection field still shows all users across all departments.

I would like the “Nhân viên thực hiện” selection field to dynamically update and only show users belonging to the department selected in the “Phòng ban” filter.

This would greatly improve the user experience and efficiency when assigning tasks within specific departments.

Is there anyway to do it?

Currently, it does not adequately address this scenario.