URL parameter to preselect the filter by group buttons?

AppSheet AppSheet Q&A
,
1

Hi, is there a URL parameter to to open a table view with one of the group by buttons preselected?

i.e. i want it to open with ‘Available’ already selected:

image
image315×293 7.84 KB

(i’m aware of the &userfilters= parameter to apply a filter, but i prefer this if its possible)

2

Try adding this to the end of your deep link:

"&defaults="
& ENCODEURL(
    "[{'ColumnName':'"
    & "group-by-column-name"
    & "','ColumnValue':'"
    & "group-by-column-value"
    & "'}]"
)

Replacing group-by-column-name and group-by-column-value with the desired values:

"&defaults="
& ENCODEURL(
    "[{'ColumnName':'"
    & "Properties"
    & "','ColumnValue':'"
    & "Available"
    & "'}]"
)
3

Thanks Steve, but that seems to have the same effect as LINKTOFILTEREDVIEW()

I want the table to be prefiltered to ‘Available’ when I open it, but I need the ability to easily switch to a different group by or view All using the groupby filter buttons

4

Hi @PGold

Are you using a mobile framework? If yes, try disabling it first, because sometimes when you click it doesn’t want to move to another page (it freezes) or try refreshing (Sync)

5

Thanks @Syamsudin , I am using the desktop design. These filter by group buttons are only on the Desktop design

6

Hi @PGold

I frequently use group by and rarely encounter problems moving to previous data. I usually add a real column to the table to simplify grouping, so that Appsheet can simply read it. Here’s an example.

20260625_161351
20260625_161351575×1280 126 KB

20260625_161412
20260625_161412575×1280 102 KB

20260625_161439
20260625_161439575×1280 74.4 KB

7

Thanks @Syamsudin

I don’t have any problems moving between group by in a regular view.

Rather, I want the view to open and it should be already filtered by group, but with the ability for the user to switch to another group by.

LINKTOFILTEREDVIEW() stays filtered and the user can’t go to another group by

I want the table view (in desktop design) to open with a ‘filter by group’ button already selected, then the view will be filtered but the user can easily select a different group by.

8

Hello @PGold,

Could you maybe add a slice to your main view? I looked for a template that does the same for IT Ticketing System where My Tickets use a slice to filter for Unresolved tickets that are either created or assigned to me.

AND([Resolved] = false, OR([Email] = USEREMAIL(), [Assigned Tech].[IT Email] = USEREMAIL()))

9

I tinkered with this a bit more. I’m convinced there’s no way to do what you want.

10

I don’t think there is a deep-link parameter that sets the selected state of those group/filter buttons specifically. The URL parameters can filter the view, but the button state itself is more of AppSheet’s view UI state than something exposed as a normal deep-link target.

For what you described, I’d probably make separate views/slices for the common starting states, like Available, Unavailable, All, etc., then deep-link to the right starting view. Users can still switch views/buttons afterward, but the launch state is predictable.

So: LINKTOFILTEREDVIEW() or a dedicated slice/view is likely the practical route. I wouldn’t spend too much time hunting for a hidden group-button parameter unless AppSheet documents one later.

Related discussion that may help with deep-link behavior: How to Pass Multiple Groups Using Deeplink in AppSheet

11

@Steve ok thanks

@zainkhan23 thanks for your response, and clarifying what I’m looking for.

If using slices,

what is a neat way that they can switch easily to a different slice, without adding more menu buttons?

I really like the filter by group buttons as they are neat and intuitive.

For now, I’m using the full URL of the selected state instead of a constructed deep link. It seems to work for now, but I’m not sure whether its a good idea and how stable it is.