Display name when using LINKTOFILTEREDVIEW

Phil_Waite · 10-21-2020 10:25 AM

Hi,

Can I have a view name for each view when using LINKTOFILTEREDVIEW. At the moment it only comes up with the name of the view that is being linked to. I have attached a screen shot where I have entered a display name but it doesn’t show up.

Thanks

Phil

Steve

The name displayed here:

Is determined by the value or expression of the view’s Display name property:

The view’s Display name expression does not inherently know anything about how the user got to the view, so there’s no ready way to write an expression that reflects which view the user came from or which action was used to get there.

Phil_Waite

Thanks Steve,

I’ll give the view it links to a generic name then

Phil

Dario

Just to add a bug I think I’ve found semi-related to this Steve, if you use the expression ‘LINKTOFILTEREDVIEW’ with a view name that is part of a column formula, it doesn’t let you set row conditions in the same way as when you are entering the view name without the [ ] tags.

For example, this…
LINKTOFILTEREDVIEW([View], [Department] = “Sales”)

will not work, however the expression naming the view manually, like so…

LINKTOFILTEREDVIEW(“Incident Register”, [Department] = “Sales”)

works fine. The error I get is that Appsheet can’t find the column [Department], which tells me that in the former example it is not looking for columns within the referenced view table, whereas in the above working example it is going to that view, and then finding the column. Is this not a bug? I’ve used the [_THISROW] command ([_THISROW].[View]) to see if that would fix the problem and no luck unfortunately.

Steve

This isn’t a bug, it’s just how the function works. If you want different views conditionally, you’ll have to wrap LINKTOFILTEREDVIEW() in a conditional:

SWITCH(
  [View],
  "View 1", LINKTOFILTEREDVIEW("View 1", ...),
  "View 2", LINKTOFILTEREDVIEW("View 2", ...),
  ...
  "View N", LINKTOFILTEREDVIEW("View N", ...),
  ""
)

Yes, it’s cumbersome.

Dario

Thanks Steve, it would have never occurred to me to try the Switch function to get it working. Brilliant stuff man.

Steve

The community is here to offer new perspectives! Don’t hesitate to ask!

Bahbus

Would be neat to update LINKTOFILTEREDVIEW to have another optional argument for display name. Kind of like the update to UNIQUEID for UUIDs.