Surface the "View details" action or create a combined LINKTOFILTEREDVIEW and LINKTOROW function

AppSheet AppSheet Q&A
1

Let’s say that I have “Customer” and “Order” tables. I have a “Customer” detail view that incorporates my “Order” table view.

When I select an order, I intercept the “Row Selected” event to do a few things before displaying the order. The last action in the custom action group is a “View Detail” action:

LINKTOROW([_THISROW], "Order - Detail")

The problem with this is that I would like to enable “Slideshow mode” in the “Order” detail view. Using LINKTOROW doesn’t apply a filter on the “Customer” column, so “Slideshow mode” allows me to scroll through every single “Order” record.

If I don’t override the “Row Selected” event and I just stick with the “Auto assign (View details)” action, it takes me to the correct row and limits the slideshow to only those orders that belong to the customer. There’s no way I can find in the API to mimic that behaviour (i.e., filter the view and go to this record).

Please either surface the “View details” action so I can use it in an action group or provide a function that combines LINKTOFILTEREDVIEW and LINKTOROW.

2

Use LINKTOFILTEREDVIEW() rather than LINKTOROW().

1 Like
3

How? If I want to restrict the detail view to only those orders belonging to the customer, it’s easy enough:

LINKTOFILTEREDVIEW("Order - Detail", [Customer] = [_THISROW].[Customer])

But that takes me to the first record in the sort order, not the one I selected in the table.

If I make it more specific:

LINKTOFILTEREDVIEW("Order - Detail", [Row ID] = [_THISROW])

then shows me the one record but I lose navigation.

I have two choices: filter the view and lose the row I selected or link to the row and lose the filter.

4

Try this:

CONCATENATE(
  LINKTOFILTEREDVIEW(
    "Order - Detail",
    ([_THISROW].[Customer] = [Customer])
  ),
  "&row=",
  ENCODEURL([_THISROW])
)
3 Likes
5

I expect that would work. My request to make “View details” a visible action the same way that “Add”, “Edit”, and “Delete” stands, though, as it would be a lot easier.

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.