Appsheet Expressions Filter Data

[syahirISB]

Hi all,

I have a filter data interface like below;

And the expressions to filter the data is like this;

isnotblank(Any(Select(Filter VMT[UID],
And([_THISROW].[Work Date]>=[Start Date],
[_THISROW].[Work Date]<=[End Date],
[_THISROW].[Device Location]=[Filter Location],
[_THISROW].[Device Model]=[Filter Model]))))

The question is how do I make the expressions can filter either by one of them? 

For example can filter by only date range OR Location OR Model without removing the quick edit column. Only by changing the expressions.

I try replace AND expressions with OR, and have the filter, filter data by date range only (left other quick edit column blank) but the Filtered Data show all data.

Can someone help me? thanks

[jballester]

Hi, 

you can check the following by substituting "AND"

  AND(
	OR(  ISBLANK([_THISROW].[Work Date]),[_THISROW].[Work Date]>=[Start Date]),
	OR(  ISBLANK([_THISROW].[Work Date]),[_THISROW].[Work Date]<=[End Date] ),
	OR(  ISBLANK([_THISROW].[Device Location]),[_THISROW].[Device Location]=[Filter Location]),
	OR(  ISBLANK([_THISROW].[Device Model]),[_THISROW].[Device Model]=[Filter Model])	
  )

Also, you can check the following by substituting the entire function

FILTER("Filter VMT",  
  AND(
	OR(  ISBLANK([_THISROW].[Work Date]),[_THISROW].[Work Date]>=[Start Date]),
	OR(  ISBLANK([_THISROW].[Work Date]),[_THISROW].[Work Date]<=[End Date] ),
	OR(  ISBLANK([_THISROW].[Device Location]),[_THISROW].[Device Location]=[Filter Location]),
	OR(  ISBLANK([_THISROW].[Device Model]),[_THISROW].[Device Model]=[Filter Model])	
  )
)

[syahirISB]

1. First expression no error but the result not showing when I try to filter by 1 option only

2. Second expression have this error like below. May I know which part should I change the settings?

[jballester]

in the field where you have the filter, change the field type to "list"