Link to specific row on dashboard view

[FREDY_ORTEGON]

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?

help.appsheet.com

App Column Type (Deep Link)

Learn how to use deep links to navigate to another view in the same app, or in another app.

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:

[Steve]

I don’t believe there is a way.

[GreenFlux]

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”).

[FREDY_ORTEGON]

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.

[Jonathan_S]

Is this Working Yet?

[GreenFlux]

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

Dashboard View Behavior - Table starts blank, how to start with first row selected? 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…

[The_Oaks_Admini]

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.

[GreenFlux]

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.

[The_Oaks_Admini]

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?

[GreenFlux]

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.

[The_Oaks_Admini]

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).

[GreenFlux]

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.

[The_Oaks_Admini]

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.

[GreenFlux]

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().

[Jonathan_S]

This is Seriously Something that needs to get implemented.

[GreenFlux]

Related Feature Requests

Pre-selected interactive dashboard view via expression 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? 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 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]

[The_Oaks_Admini]

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!

[Marc_Dillon]

@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!

[Jonathan_S]

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?

[Jonathan_S]

We Really need this Functionality.

[pravse]

Thanks for flagging it @Jonathan_S

Will get some eyes on it to see what we can do. Yes, you do want a “deep link” into any state of the app, including to some state within the dashboard.

@macastan @Arthur_Rallu @morgan FYI

[Jonathan_S]

Hey @praveen,

I wasn’t on the call but if I was I would have mentioned this. Is it to Late? ha

[Adam-google]

A fix for this is rolling out now.

[Rafael_ANEIC-PY]

Hello @Adam , could you share more information about the fix? I’m very interested in using this in my apps, particularly with multi level dashboards.

[Jonathan_S]

yes but will this also fix the freezing dashboard problem? Link to specific row in dashboard has always worked for me and have it in several apps, the problem is the dashboard is frozen and the user cannot click any other rows, they need to navigate away from the dashboard and back in manually to unfreeze it.

[ryanseamons]

I have hit this issue as well. Wanting to link to a dashboard with a specific row selected using a URL. Any news on the fix?

[Arthur_Rallu · Accepted solution]

The fix was released. It should be working fine now.

[FREDY_ORTEGON]

Helo,

Could you please explain to me how the function works?

[Koichi_Tsuji]

Yes I m not sure which part of this chained post, the last post from @Arthur_Rallu is covering…
What is now possible?

[Steve]

I believe this now works (though I’ve not tested it):

LINKTOROW(key-column-value, dashboard-view-name)

[Markus_Malessa]

@Steve solution has worked for me for at least a few months now, I think possibly since at least December.

[Koichi_Tsuji]

thanks Steve, I will test it out, but tomorrow jobs…

[Pointer]

Why is this feature not working? What should I do?

[Pointer]

Why can’t I run this, the whole table is opened, I just want the dasboard for the key column I clicked on. can you help me please?

[john_charlie14]

i have a problem with this, when i refreshed the whole page, it'll get the whole table view not only the key-column-value.

[Rafael_ANEIC-PY]

IT WORKS !  I use this expression to go to the newest row on a table on a dashboard view:

LINKTOROW(MAXROW("Transactions","_ROWNUMBER"),“General”)

Coupled with an action that adds a new row, you can smoothly create a row to a parent or child record in a dashboard and have it inmediately selected as well. 

@Steve I think it is worth a edit or two in the LINKTOROW() and App Column Type (Deep Link) documentation pages hehe, everyone should know about this !

[Steve]

Attn @lizlynch 

[Connor_Mooney]

Can you describe a bit more how you got this to work?

I think I'm trying to accomplish the same thing as everyone else here, but just to reiterate: I have an interactive dashboard with a main records table view, 1 main record detail view, and 2 views to child tables from that main record.

When I manually select a record from the main records table view, the other views in the dashboard update as expected.

The problem is preselecting a row in the main records table view when loading the dashboard. With no rows selected there, the related views show orphaned data that is confusing to the users.

I've used all of the recommendations from this chain to add the LINKTOROW formula as an action that is called by the row selected behavior of the main records table view, and added the LINKTOROW formula as my starting view, but nothing is working for me.

[JPAlpano]

I am only able to make this LINKTOROW() wok if the first view in my dashboard is a Detail View.   

[Pointer]

What is the latest situation on this subject, can anyone help?