Linktofilteredview with user inputted view + filter

[ABourne]

Hello, I'm trying to create a linktoview process in which the user selects a location from a view, then selects a part type from another view, and takes both of those values to show a part type view filtered by the location selection.

on sheets I currently have a sheet/view for each part type, with a column within each sheet for location; As the part types have different specs and therefore different columns.

How do I pass the location (or part type if that is easier) selection to the second linkto(filtered)view?

Alternatively, I tried to create a search form instead, and came to this equation:

LINKTOFILTEREDVIEW([Part Type],[Plant] = [_THISROW].[Plant])

With the form asking Part Type and Plant. Seems LinktoFilteredView does not like an enum variable input [Part Type] like LINKTOVIEW does.

thank you!

[Steve · Accepted solution]

SWITCH(
  [Part Type],
  "Hammer",
    LINKTOFILTEREDVIEW("Hammers View", [Plant] = [_THISROW].[Plant]),
  "Wrench",
    LINKTOFILTEREDVIEW("Wrenches View", [Plant] = [_THISROW].[Plant]),
  ...
)

[ABourne]

That works! Thank you!!