Stephen_Ehmann:
Is there a way to set a view title through the URL?
Nope.
Stephen_Ehmann:
Is there an appsheet help doc about defaults= syntax?
Nope.
2 Likes
Has anyone used Deep Links & URL Parameters in a Dashboard View?
I’m looking for a way to control what data is presented in the views that are part of a dashboard. Without the need of slices.
[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/9) Questions
That’s a very nice idea thank you. 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.
Im not perfectly sure what you want to achieve. This should be silly question to you (for you with deep knowledge about Appsheet), but the deeplink action with linktorow([Id], “YourDashboard”) does not help you at all?
Hi @tsuji_koichi this is no silly question
I thought that maybe there are more parameters we could add.
Something @Marc_Dillon postet here:
[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/8) Feature Requests
Since I’ve been thinking about this request recently trying to help out in another thread, I came up with a syntax for an expression that I think could work here. LINKTODASHBOARD( view-name, table, row_key [, table, row_key]… ) As there can be one or more Tables represented in an interactive dashboard, and you would need to specify exactly which records in each Table to be selected.
But I see that actually there are no url parameters in an interactive dashboard view. The url is not changing when you select a row.
2 Likes
Yes that’s possible:
[Bulk Select Multiselect Select All](https://community.appsheet.com/t/bulk-select-multiselect-select-all/60092) Tips & Tricks ?
We can do Bulk Select in Table, Deck and Gallery View. [Multiselect] We can even navigate to a view that’s already in Bulk Select Mode. (My Table View is called “Text”) This is the expression for the Action type “App: go to another view within this app” LINKTOVIEW(“Text”) & “&selected=” & ENCODEURL(“”) [Multiselect2] Or even navigate to a view that’s in Bulk Select Mode and items preselected. Like Select All. (My Table is also called "Text) LINKTOVIEW(‘Text’)&‘&selected=’&ENCODEURL(…
&search=
This one will enable the search bar with cursor ready to enter search text.
&userfilters=
Sadly this won’t open the filter window directly. But you can use it to pre-configure the filter. That’s like LINKTOFILTEREDVIEW() but the user can see what kind of filter is active and can change it.
In this example I have a Number column called “Amount” and set the filter to 1:
&userfilters=[[“attribute”,“Amount”,{“start”:1,“end”:1}]]
6 Likes
&group=
and
&sort=
4 Likes
Is it possible to show the GROUP AGRREGATE (COUNT) along with the "&group=“column_name”
Hi @Fabian_Weller I am not able to implement the &userfilters= . I tried but the data is not getting filtered although the filter is showing at top. Can you please give a sample expression.
Hi @jyothis_m this is working in my Test App. The filter is working as expected.
https://www.appsheet.com/start/187ffd57-1704-4bc3-9725-57e513a57bbb#appName=Test-549987&table=Products&view=Products_Inline+2&userfilters=[[%22attribute%22,%22Amount%22,{%22start%22:1,%22end%22:1}]]
1 Like
Hi @jyothis_m can you please explain what you mean? Maybe with an screenshot?
1 Like
Hi @Fabian_Weller can you give the expression which was entered in the expression field in the app editor along with Linktoview()
Hi @Fabian_Weller I was referring to this
I had asked the same in the other Post regarding Deeplinks and @Marc_Dillon has replied that group aggregate is not possible through URL but directly in UX Views.
1 Like
Finally got it working. I was using Action Goto Another View within App with the following expression
CONCATENATE(LINKTOVIEW([VIEW]),“&userfilters=”,ENCODEURL(‘[[“attribute”,“Status”,{“Pending”:true}]]’))
However, this resulted in navigating to the view with FIlter showing at Top, but actually data not filtered.
I found that i had to add the following also with the expression
“&table=TableName”
Deeplink created with LINKTOVIEW() does not contain “&table=” parameter and thats why the filter was not working. Once I added it, everything is working fine. So my final expression is
CONCATENATE(LINKTOVIEW([VIEW]),“&userfilters=”,ENCODEURL(‘[[“attribute”,“Status”,{“Pending”:true}]]’),“&table=”,ENCODEURL([Table]))
4 Likes
Good finding thank you @jyothis_m
2 Likes
Hi @jyothis_m,
I am trying to use this URL approach, but I am missing something regarding the syntax… I have a Task column (text) and would like to filter it for rows that contain “Leaks”, my URL: https://www.appsheet.com/start/88f14e5c-b056-4522-ae7f-7f05517bdf9d#appName=tasksapp-99999&table=Tasks&view=Tasks&userfilters=[[%22attribute%22,%22Task%22,{%22Leaks%22:true}]]
Please, do you have any suggestions or a doc/link where I can find more about the &userfilters syntax for matching text?
Thank you
Paulo
Hi @Paulo_Negrao Your URL looks fine. What is the exact problem? When you use the App in Desktop view, you can use the filter and then check the URL. Your LINKTOVIEW() expression should produce the same URL. Then it should work.
1 Like
Hi @Fabian_Weller,
Here go some more details about the issue…
Any ideas how to use &userfilters to filter for a string in a text column will be very welcome.
Thank you, cheers!
Paulo
Hi @jyothis_m and @Fabian_Weller
After some trial&error process… I’ve got a working syntax…
I wonder why is so difficult to have a basic documentation about the AppSheet URL options and syntaxes!!!.. kind of weird…
Anyway… thank you guys for the insights and help!
Cheers,
Paulo
2 Likes
Hi @Paulo_Negrao Sorry for the late reply. I saw your post just now. Great that you found the solution. You are correct. The appsheet documentation can be updated with all these points. I also struggled getting my url with filter working.
1 Like