Why didn't it work

Topic Labels: Formulas
698 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I try to filter by text field with quotes in formula
AND(OR(owner="\"Fname\" \"Smith\"",owner="Foo"),OR(type="audio"))
and items with quotes is missing. I got Foo only not “Fname” “Smith”

3 Replies 3

You either have redundant quotation marks, or need to change your formula to use single quotation marks for the owner='...' portion:

owner='\"Fname\" \ "Smith\"'

While I expected your answer to be correct, @Kamille_Parks, I experimented, and there actually shouldn’t be anything wrong with how @ALEXEY_SANGALOV wrote that part of his formula – Airtable seems to recognize the attempt to escape double-quotes with '\', even inside of un-escaped double-quotes:

CleanShot 2020-10-23 at 10.41.16

So, I’d suggest that the problem is probably somewhere in the structure of the AND() OR() logic – but I can’t really see any obvious issues – or else there’s just a simple typo in the text you are searching for, @ALEXEY_SANGALOV.

Welcome to the Airtable community!

Does your "Fname" "Smith" record also have type audio? Could you provide a screen capture to help us troubleshoot the issue?

Also, notice that your last OR condition has only one condition in it, so the OR doesn’t really do anything.

Here is your formula written in a multi-line format to make it a bit easier to see the logic. I have also used @Kamille_Parks’s use of single quote to avoid having to escape the double quotes, and removed the extraneous OR.

    owner='"Fname" "Smith"',