How to Pass Multiple Groups Using Deeplink in AppSheet

AppSheet AppSheet Q&A
1

I am using an expression with Deeplink to create a group. By setting two columns in GroupBy, I’ve created a UI where the group is displayed in the left sidebar in desktop mode.

I want to create a mechanism where the sidebar groups can be dynamically changed using Deeplink.

The following expression allows me to change the group:

CONCATENATE(LINKTOVIEW(“Sales”), ‘&group=[{“Column”:“Status”,“Date”:“Ascending”}]’)

However, I can only apply one group with this formula.

Since I want to change the groups in the sidebar, I need to write an expression that passes two groups.

Could you please explain how to pass multiple groups using Deeplink?

2

Please try the following.

LINKTOVIEW("View Name")& "&group=" & 
ENCODEURL('[
  {"Column":"Column Name1","Order":"Ascending"},
  {"Column":"Column Name2","Order":"Ascending"}
]')

However, as far as I can tell, running multiple groupby deeplink works fine in non-desktop mode, but does not work well in desktop mode.
In fact, I have posted a similar issue in the past. I too would like to know about the solution here.

My past posts

3

Thank you for your response.

You’re right, it’s possible to change two GroupBy settings when not in Desktop mode. However, I would like to see this functionality become available in Desktop mode as well.

4

Attn @Arthur_Rallu