When using a airtable, simple security filters with text columns do not work. For example, a filter as simple as:
[name] = “John Smith”
Results in a an error: “Error executing AirTable operation. Status code: 422.”
I believe that AppSheet is attempting to push the security filter into the AirTable api. Which would be great! It would save data I/O and sync time. But that process (of AppSheet pushing filters into the AirTable api call) does not seem to be built out well.