LINKTOFILTEREDVIEW does it work with virtual columns

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?

0 4 66
4 REPLIES 4

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]))

Thank you for the solution!

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

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?

Thank you for the solution!

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

Top Labels in this Space