Multiple Criteria For Filtered View

[LWSChad]

Hello;

I am trying to create a view in which I would like to use multiple criteria on one field to filter the data.

 

i.e.  RecordID <> 101, 109, 117, 131, 140

 

When I attempt to do this Caspio tells me "Invalid value - Value Must Be A Number"

 

Is there a workaround for this?

 

Thanks!

 

 

[MayMusic]

Only condition you can have in a view is to select Contain as Comparison type and then use either AND or OR logical operator in teh condition. As far as I remember Contains is only available for text fields.

[Jan]

Hello EIQ,

 

As far as I know, it is impossible to create several criteria in a View.

You can add several Criteria in your Report DataPage, on the Search page.

[LWSChad]

Thanks!

I played around with using a text field for a filter rather than the ID# field, and found that for my scenario I used Does not contain and a space to separate the criteria.