This is my challenge.
I have a 3 tables –
- Fund Raising Round
- Fund Raising Round Kanban Status
- Investor Prospects.
I have multiple rounds. Each round can have different statuses as it depends on the nature of the round. The available statuses are defined in the second table and have a lookup to Round. An investor prospect has a lookup to the round and to the status.
I am trying to create a page that has the Kanban Board with investor prospects in it. The user selects the round at the top of the page. This filters the prospects perfectly. Also, if I select a status with a dropdown this is filtered so I can only choose a status associated with the round in question. (This is done in lookup options in the investor prospect table)
The Problem The Kanban columns (grouping) on status show all rows of the status table those that are assocaited with the round and those that are not. Is there any way to have the tha kanban columns update when the round is selected to show only the rounds that are associated with the selected round.