App on Browser not showing all data

Hi Guys,

I have users reporting that they are not finding customers in the app. When they call for support and provide the customer number and the search is performed the customers is found. The search are done in the same app but in different computers. The users run AppSheet on a FireFox browser and I am using Chrome.

The data source is MySql

Asked other users to look for the missing customers on different browsers besides FireFox and they report the same error, customer not showing.

The search option is check on the search column, the tables have security filters based on date and customer type.

Search options