LINKTOFILTEREDVIEW and selecting multiple options in a search form

[capper]

Hello - hoping for a bit of help with a search form issue. Would like for users to be able to search for properties in multiple neighborhoods, at a price less than X, etc.

Right now I’m just trying to get the multiple neighborhoods piece to work.

Selecting one neighborhood generates the expected results. However, selecting more than one yields no results.

The current expression I’m using in the Behavior/app target is:

LINKTOFILTEREDVIEW(“AllProperties_Results”, ([Neighborhood_name] = [_THISROW].[Neighborhood_name]

))

Any advice on how to get the selecting multiple neighborhoods to work?

And separately, is there a way to create a default where all neighborhoods are selected when the search form is opened?

Some additional info on table/column types below in case it’s helpful.

Search Form (Data Table):
Neighborhood_name – column type is enumlist w/ Valid if expression of Neighborhood[Neighborhood_name]

Property List (Data Table):
Neighborhood)name – column type is enumlist w/ Valid if expression of Neighborhood[Neighborhood_name]

Neighborhood (Data Table):
Neighborhood_name column type is name

AllProperties_Results (Ref View) pulls from the Property List Data Table

[Steve · Accepted solution]

capper:

Any advice on how to get the selecting multiple neighborhoods to work?

Because the Neighborhood_name column of the Search Form table is EnumList, change this part of your LINKTOFILTEREDVIEW() expression:

([Neighborhood_name] = [_THISROW].[Neighborhood_name])

to this:

IN([Neighborhood_name], [_THISROW].[Neighborhood_name])

capper:

And separately, is there a way to create a default where all neighborhoods are selected when the search form is opened?

Set the Initial value property for the Neighborhood_name column of the Search Form table to the same expression used for its Valid If property (i.e., Neighborhood[Neighborhood_name]).

[capper]

Much appreciated - worked a treat. Thanks for the assist, Steve.