How do I filter out one or more field values?

Hmm.. You can create a "NOT Clock" field.. and filter that based on Yes...   Using the To Do database template.. Here is a filter of "Not Done".. 

First.. please confirm that you want to filter for "Not Clock"... as I beleive there is a type-o in the initial post.   Assuming that to be true.. Other platforms have capabilities for creating all kinds of filtering .. contains. .does not contain .. begins with .. et all..   For example.. here is a filter from a popular ITSM platform.. 

And here is the previously suggested filter for "Not Done".. 

Honestly .. given the variety of filter options.. I do not see it as a "work around" .. but exactly what it is called.. A filter.  Just my two cents. 

First.. please confirm that you want to filter for "Not Clock"... as I beleive there is a type-o in the initial post.   Assuming that to be true.. Other platforms have capabilities for creating all kinds of filtering .. contains. .does not contain .. begins with .. et all..   For example.. here is a filter from a popular ITSM platform.. 

And here is the previously suggested filter for "Not Done".. 

Honestly .. given the variety of filter options.. I do not see it as a "work around" .. but exactly what it is called.. A filter.  Just my two cents. 

Ooops.. sorry for the double post.. perhaps support can remove one.. Too quick on the click I suppose.. :( 

This is not as simple as just being able to choose "Not", but it is available. Simply select all of the items you want to see and not the "Clock" item.

It's because you are trying to filter a Multiple Choice field. I used a Choice field not knowing what you used and when I tested using a Multiple Choice field I got the same result you did.

It's looking for a field that has both "Advertising" and "Battery Powered" stored in it in your example.

as a workarond you could create a formula that has something like

text(contains(concat(text(Type)), "Clock"))

Then filter for !="Yes"

You would have to show the new formula column in the view, then you can enter the filter formula.

The choice and multiple choice field only let you do the radio button filtering. Other types of fields allow you to enter a formula to filter on.

I'm giving it another try. What you could do is duplicate your database just to be on the safe side, create a Choice field that has all the choices that your Multiple Choice field has and attach the following code to a button.

for t in select YourTable do
if text(t.Type) = "Action Figure" then
t.(Type2 := "Action Figure")
end
end

Type2 is just what I called the new Choice field. You would have to change the Type item in the code before each new run, but it beats manually updating each item. I the end you should be able to delete your Multiple Choice field and filter on the new Choice field.

One more line of code and you'd only have change it each time. On the first line enter:

let myItem := "Action Figure";

And where "Action Figure" is in the loop you would replace it with myItem.

If you set it up like this, you'll only need to push the button once.

let aryItem := ["Apples", "Oranges", "Bananas"];
for i in range(0, 3) do
for f in select Table1 do
if text(f.'Fruit 2') = item(aryItem, i) then
f.('Fruit 3' := item(aryItem, i))
end
end
end