I have an interactive dashboard made up of several views for data tables that are all related through references.
Everything seems to be working fine up to a point. I can click on certain records and it will correctly highlight the related rows in the adjoining views.
As you can see in the picture below, when I select “section A”, the corresponding search term appears in the “search term” view. This then highlights the related row in the “index table” view
Then when I click a record that does not contain a related value in the other views, for example when I use the arrow keys to view “section b”, this has no related search term or index so these views come up empty. This is expected because as previously mentioned “section b” has no related search term to filter the index table with, so when selected, the result is a completely blank index table (Although I’m not sure why the index table doesn’t still show values just with no highlighted row? But that’s not what this post is about so whatever..)
However, when I click back to “section a” and click the same related search term as before, the data does not come back.
Normally I would expect the index table to look the same as in the first picture, where the index table contains rows with the relevant row highlighted in grey, but I can’t get the index table data back without refreshing the browser tab. Even doing a force sync within the app doesn’t bring the data back, only refreshing the entire webpage which makes searching through the index table very slow.
I’d like for the index table to stay responsive even after a row has been selected that doesn’t have a referenced index. If the table goes blank due to lack of relationship, it should re-populate when I click a search term that does actually reference the index table right?
That’s not what’s happening and I’d like to fix this. Any help would be much appreciated
