LINKTOFILTEREDVIEW does it work with virtual columns

AppSheet AppSheet Q&A
, ,
1

Hi,

My linktofiltered view formula on an action icon is not working?
LINKTOFILTEREDVIEW(“Call Log”, ([Concatenated VC] = [_THISROW].[Concatenated VC]))
Is it because the column I have used is a virtual column?

2

Although it’s not explicit in the LINKTOFILTEREDVIEW() - AppSheet Help article, I imagine that the function’s filter argument may need to return a list of values from the key column of the table the view is based on. Try:

LINKTOFILTEREDVIEW("Call Log", FILTER("Call Log Table", [Concatenated VC] = [_THISROW].[Concatenated VC]))
3

Shouldn’t make a difference. Its probably that somehow [Concatenated VC] = [_THISROW].[Concatenated VC] isn’t returning any values. But also the formula seems to imply that you want to link to a view of just the rows where [Concatenated VC] matches [Concatenated VC] for the column your in. Is this right? Are you sure that [Concatenated VC] isn’t blank in the column your in?

1 Like
4

Thank you for the solution!

I found my answer. I had to actually change a setting for a specific field.

1 Like
5

Thank you for the solution!

I found my answer. I had to actually change a setting for a specific field..

1 Like