Expression to Filter in Form

[CloudChampion]

Greetings,

I have a long form 100+ columns, to capture inventory at my store.  Given its length, I want all of the blank entries to show up, but as they are answered, they will 'drop off' by applying an expression in the 'show' field. 

Additionally, I have an Enum column [Line] "filter" to show all entries, regardless of their answered status (Y/N) 'show all' field. 

Lastly, I have another Enum column [Type] with all of the products listed, that allows the user to search all.

The behavior I want, is if [Line] is set to 'yes', then show all fields regardless of ISBLANK.  Also, if a user searches "Tire - 19868" that the ONLY value that will show up on the form is going to be that specific field and none others, regardless of ISBLANK or not.

I am using the expression below, and am SUPER close, but when using the item search, it will not display ONLY the selection, but the blank lines along with the selected filter, so you have to scroll down through all of the unanswered lines to fine "Tire - 19868".

IFS(
or(
[Type] = “Tire - 19868”,
ISBLANK([Tire - 19868])),
[Line]=No,

or(
ISBLANK([Type]),
ISNOTBLANK([Tire - 19868])),
[Line]=Yes,

or(
ISBLANK([Type]),
ISBLANK([Tire - 19868])),
[Line]=Yes,

or(
ISBLANK([Type]),
ISBLANK([Tire - 19868])),
[Line]=No,

or(
[Type] = “Tire - 19868”,
ISBLANK([Tire - 19868])),
[Line]=No,

)

Any help is appreciated!

[CloudChampion]

@Steve Any suggestions?  You always make these look easy 🙂

[Steve · Accepted solution]

This?

IF(
  ISNOTBLANK([Type]),
  ("Tire - 19868" = [Type]),
  OR(
    ("Yes" = [Line]),
    ISNOTBLANK([_THIS])
  )
)

[CloudChampion]

@Steve 

Maybe close?  Getting this:

Condition OR([Line], NOT(ISBLANK([_THIS]))) has an invalid structure: subexpressions must be Yes/No conditions

[Steve]

Whoops! I thought the Line column was of type Yes/No, but apparently it isn't. I've adjusted my suggestion above.

[CloudChampion]

Perfect!  I changed the ISNOTBLANK to ISBLANK on the last statement and it worked flawlessly!  Thanks as always