I have a dashboard with three views, a detail view of user filters, a table of records, and a detail view for each record of the table. Currently, when you load the page, it starts without a record selected and, thus, the record detail view is blank. Any way to have it select the first row by default?
(I’ve searched the community pages for an answer and, ironically, the only thing I’ve found is wanting the opposite behavior, sorry to be ‘that guy’)
So I assume as you update the user filter it then updates the detail view? What does the user filter table look like? Are you resetting it back to blank or something? It sounds like you need to setup the user filter default to select the record you want to start with. If you share some screenshots of how your user filter and detail view are setup together I can help with a more specific answer?
I also have an interactive Dashboard. It’s a Primary View. When I open it, nothing is selected. The Ref Detail views show a random row. This is confusing.
How can I preselect the first row? Since it’s a Primary View I can’t use LINKTOROW().
It is showing the first record. But “first” can be different based on your data source. For GSheet, it is the topmost record on the sheet. For SQL it is the record whose key value comes first alphabetically. I’ve used this fact to setup a “blank” record to show in the Detail view at first, typically with a generic graphic and/or text that says “please select a record”.
There’s another question:
I have 3 Tables in my interactive dashboard: Parent, Child, Grandchild.
Like: Customers, Orders, Items.
When I click on a customer, the first Order shows up in the interactive dashboard. But the Order’s Items are not showing up. I have to first open another Order (via the arrows ⏴⏵) to see the Order’s Items.
Is this the normal behavior?
In the Items Table I’ve even added a VC to have the Ref to the Customer Table.
When you select a Customer, the Order Table gets filtered. Similarly, the Items Table won’t get filtered until you select an Order, but just because the first Order is being shown, doesn’t mean anything was yet selected.
I was just doing some experimenting with your situation to try to understand it better, and I stumbled across something weird. What I said above was based on actual app-building for clients:
But in my experimenting just now, with an interactive dashboard consisting of just a Table and Detail view of the same Table, the Detail is displaying as blank if nothing is selected, which is exactly opposite of what I experienced previously. I have no idea why.
I was hoping to replicate what you were seeing with your Customer-Order-Items 3-table dashboard, but then I ran into that, so let me ask exactly what you’re seeing. First, how exactly do you have your dashboard set up? In my tests case, with 3 tables, I set up 6 views, a Table and a Detail for each Table, where the user can select records in each Table to filter the other Tables and Detail.
Here is a screenshot where a customer is selected but nothing else. You can see the orders are filtered down, however none are yet selected (and order detail is blank). However the items table is still showing the full list, the interactive filtering obviously only applies 1 level away.
Yes there are multiple orders per customers. When a Customer is selected, the first Order should be seen in the Order Detail. That’s the desired setup. The user can then switch between orders by using the arrows.
I found the reason why this was not working: As I said I already had a Ref connection between the customer table and the items table. But this was an Enum with type Ref.
Now I changed this to a real Ref column and it is working!!!
I select a customer and the first order and this order’s items are shown.