Link to specific row on dashboard view

AppSheet AppSheet Q&A
1

Hi everyone,
Does anyone know how to build an action that goes to a dashboard view and opens a detail view in a specific ID?

Here I found something but does not speak how to do the action when the view is a dashboard ?. Thank you very much for your help.

for example:

2X_f_fae29f6ea0d363e0de4f928a8e69fb2acc61d475.png
2X_f_fae29f6ea0d363e0de4f928a8e69fb2acc61d475.png952×587 67 KB

1 Like
2

I don’t believe there is a way.

1 Like
3

LINKTOROW([Key],“DASHBOARD_VIEW”) kind of works, but there’s a bug. I think they are still working on this feature because it’s not documented.

The action will work, and it will actually pull up the dashboard view with the row selected. But from there, the dashboard stops responding to mouse clicks to select other rows.

The dashboard is locked on that row, and in the browser, the URL ends in:
#control=Dashboard&row=mXH3lPkA&page=dashboard

You have to refresh or go to another view to get the dashboard working again.

So I’d say this is not possible for now, but once the feature is finished, the format should be LINKTOROW([Key],“DASHBOARD_VIEW”).

5 Likes
4

It would be a good option, I wonder what would happen where the dashboard had more than one detail view of more than one table.

5

Is this Working Yet?

6

No, but I’ve found a workaround for certain use-cases.

[Dashboard View Behavior - Table starts blank, how to start with first row selected?](https://community.appsheet.com/t/dashboard-view-behavior-table-starts-blank-how-to-start-with-first-row-selected/29353/4) Questions

To expand on what @Austin_Lambeth said, LINKTOROW() does not work with Interactive dashboards. IF Interactive mode is OFF, LINKTOROW([Key], “Dashboard ViewName”) will select a row in the table view and pull up the same record in detail view. [Screen Shot 2020-08-14 at 12.24.13 PM] However, LINKTOROW([Key], “Dashboard ViewName”) will break the dashboard with Interactive mode ON. The dashboard stops responding and you have to refresh the page to fix it. TIP: To get LINKTOROW() working AND ke…

2 Likes
7

So, I can understand the work around. Set Interactive Mode off. Then where am I supposed to add the LinkToRow()? Under which object behavior? Parent? or Child? And then where do I call the Action from? Once set does this work like interactive mode so that when a new parent is selected the inline and detail children are selected as well.

1 Like
8

The_Oaks_Administrat:

Then where am I supposed to add the LinkToRow()? Under which object behavior? Parent? or Child?

  1. Create an Action in the parent table, to ‘go to another view in this app’.
    • Target: LINKTOROW([Key],"Dashboard")
      • Links to same view, but forces dashboard to update with that row selected.
      • Otherwise, default behavior with Interactive Mode OFF would navigate to Detail View.
  2. Set this action as the ‘row select’ behavior for the table view of that parent table (the view used to list parent rows in the Dashboard).

The_Oaks_Administrat:

Once set does this work like interactive mode so that when a new parent is selected the inline and detail children are selected as well.

Kind of. It’s not fully interactive but it works when you just have one parent table and one child table with a basic dashboard. I haven’t tried with grandchild relationships or many-to-many. For that, I just use Interactive Mode.

1 Like
9

Thank you for your prompt reply.

So, that is why I can’t get it to work. This workaround only works for one Parent and Child. Correct? So, what if we have several Children Tables linked to Parent? Does having other Children tables which have the same Parent Key break this work around?

10

Yes, I think it only works with one parent and one child table. It’s a workaround for some cases, but it sound like it won’t work in your case.

11

Is there anything that I can do to make it work? I really like the app that I built, it solve all our needs at the Office. But for it work well, I need to be able to click on the parent and then all children in both Inline and Details views will be selected to a Top Child for example, or a Min or Max Child another example. Also, what I notice is that I loose the search capability as well. Currently Interactive Mode works well, with the exception that it only allows me to select one Parent and display all the different Children Tables. So sync is working well. Two things are missing: 1. No Inline or Detail items are selected and Searching capability is lost. For example, when I type Gloria, I do get Gloria filtered, however when I select Gloria none of the Children are selected, not even the inline. So, I guess what I would like to know is, is it even possible to create a dashboard with the functionality that I am looking for? Thank you much for your help! Very much appreciated. I feel that yes appsheet does have the functionality needed (since when I select a Parent in interactive mode, it does display all the children tables on every inline view, however, I lack understanding to know how to set up appsheet correctly so that when I add a behavior it doesn’t cancel out other behavior (ie. Searching) or selecting Max( from each of the children tables for example).

12

I don’t think you can do much about which rows get selected. It’s all or nothing with Interactive mode (ON/OFF). You could try removing the Inline view from your Detail view, and display it as a separate Table view. That may help with the row highlighting.

The search behavior can be adjusted in the Data>Columns>{ColumnName}>Searchable setting. Make sure the column you want to search is set as searchable.

13

This is Seriously Something that needs to get implemented.

14

Table view? The Dashboard has the Parent Inline View and then all the Children Inline Views are populated with all children automatically. All the Children Detail Views are blank. Only when I select one of the Children shown on the Children Inline View that the Children on the Detail View will show. I figure that there has to be a work around to this issue. So, if I turn off interactive mode, then could I build up a new custom interactive mode which is specific to this app, or I simply don’t have a good understanding on appsheet limitations? If I don’t understand appsheet limitations then that is good to know as I will have to figure out what to do, since I need to have a fully working app sooner than later. However, if there are no limitations within appsheet, but I have to develop this functionality then that is great news! Where would you start to build a custom interactive mode for my App? At the parent level using the LinktoRow() and other Link() commands using Actions to Parent object? Any help on where to start will be appreciated.

15

The_Oaks_Administrat:

Where would you start to build a custom interactive mode for my App? At the parent level using the LinktoRow() and other Link() commands using Actions to Parent object?

I think you’re going to have to change your requirements. The workaround isn’t a fix for all cases.

There are limitations with Dashboards and LINKTOROW() that prevent what you are trying to do. Your best bet is probably to use Interactive Mode, and give up on using LINKTOROW() for now. Hopefully a future update will make Interactive Dashboards compatible with LINKTOROW().

3 Likes
16

Related Feature Requests

[Pre-selected interactive dashboard view via expression](https://community.appsheet.com/t/pre-selected-interactive-dashboard-view-via-expression/13083) Feature Requests

We have a LINKTOROW() expression that we can use to direct the user to a specific detail view of a specific record. I’d like to see a way to direct a user to an interactive dashboard view, with a specific record already having been selected. I propose an easy way to solve this problem is to add an optional third argument to the LINKTOROW() expression where we can specify the name of the dashboard view.

[Deep link to bring up interactive dashboard view with pre-selected records?](https://community.appsheet.com/t/deep-link-to-bring-up-interactive-dashboard-view-with-pre-selected-records/11384) Feature Requests

One can write a deep link expression to a certain record (linktorow), or a deep link expression to a certain dashboard view (linktoview), but can they be combined so that a certain record is already selected in the targeted dashboard view? If not, you can change this thread to a feature request. A possible workaround, pointing LINKTOFILTEREDVIEW() to the dashboard view. But does the context of the condition work on records of the first element of the dashboard?

[Enable LINKTOFILTEREDVIEW() for Dashboard](https://community.appsheet.com/t/enable-linktofilteredview-for-dashboard/29537) Feature Requests

I LOVE the Dashboard view and want to utilize it in more places in my App but the fact that you can’t filter the views limits where I can apply it. Understood that you can filter if you enable interactive mode but the use case is to click on a client row (for example) and have that take you to a filtered dashboard for that client. Screenshots below: [Dashboard Filter 1] [Dashboard Filter 2]

3 Likes
17

All these is great! How simply will it be to add a parameter to LinkToRow() or even better add this functionality to Interactive Mode via an expression builder window. Are we talking weeks, months, years? Just so that know what to do with my App. Again if I can’t make it work then I will have to figure out what to do, because my App doesn’t make sense without this functionality. It kindy su… because just now I am getting the hang of Appsheet, but it is what it is. Please let me know if this is a simply addition for you guys. Another suggestion, might be to make certain portions of Appsheet “open source” so that maybe I could built in this additional functionality. You guys keep up the good work!

18

We Really need this Functionality.

19

@The_Oaks_Administrat , well, the feature requests are over a year old, so probably shouldn’t wait for it to finish your app.

And did I really make two feature requests for the same thing? Oof!

2 Likes
20

Don’t worry man, pretty sure I made a request on it to a while ago. Everyone Wants this. @praveen What do you think about this?