Hi!
I have a table named WORK which has two Ref Columns named OP_UID & PO_UID respectively. Each one is a reference to a row from a different table. Now in my WORK tableโs view in the UX tab, it shows each item in the work table as expected by showing some of the column values in the primary and secondary header and clicking on an item reveals the rest of the columns. You can also click on an action that takes you to the referenced rowโs details view of the respective table.
My client has asked me to directly show the referenced rows (all their info) of those two different tables (pointed to by OP_UID & PO_UID) in the WORK View. Is that somehow possible?
Solved! Go to Solution.
Remove the related records (inline view) from your detail view. They should be their own table view, added separately to the list of views for the dashboard.
The Dashboard list should look something like:
Make sure you turn on Interactive Mode for the dashboard.
Selecting a record in WORK_TableView should update WORK_DetailView and filter the two child tables.
Yes, you can combine multiple views into a Dashboard View, and turn on โInteractive modeโ, so that selecting a record in one section will update the other views.
Hi and thanks for the answer! The thing here is that the WORK table is used in a Dashboard view already but still the client wants to be able to view each WORK tableโs row details as if you were in the referenced table. Am i missing something here?
Remove the related records (inline view) from your detail view. They should be their own table view, added separately to the list of views for the dashboard.
The Dashboard list should look something like:
Make sure you turn on Interactive Mode for the dashboard.
Selecting a record in WORK_TableView should update WORK_DetailView and filter the two child tables.
Hi and thanks for the reply. Iโm implementing what you just mentioned but i think i only need the WORK_TableView and the detail views for PO/OP items since the client wants to simply select a work item and then view the refโs details in another panel. The thing is that, if no work item is selected, the OP & PO detail views still show some random (i guess?) itemโs details. Is there a way to show nothing if no item is selected? Furthermore, i noticed that although some work table entries have no PO_UID value (since they have an OP_UID one) , when selected, a PO itemโs details are shown in the PO panel along with the correct OP panelโs item. Is that a possible issue with the unique ids matching?
Yes, I have noticed that, as well. Thereโs no direct way to hide the detail view until a row is selected, but you could experiment with the viewโs Show_If condition and use a button to set a value in the parent record that shows/hides the detail view.
Iโm not sure if this is a dashboard bug or a problem with your relationship/key values. Again, you may want to try using the Show_If condition for that view.
Iโm trying to use a Show_If on the PO_Details custom view but despite the WORK table having only OP items (that means that their PO columns are empty) the PO View is still shown. Any ideas on that?
Hereโs the expression:
ISNOTBLANK(WORK[PO_UID])
Try basing the Show_If on a count of the child records, and hide when it equals zero.
Show_If: COUNT([Related POs])>0
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |