Searching a sheet from a workapp

Options

We have a Workapp for our field personnel to look up information from their phones as they do not have computers.

One of the items in the workapp is a sheet with requirements per location, and we have over 1300 locations. Our users are unable to use the search functionality on their phones unless they have admin permissions to the source sheet. Any other permission level and it just returns "no results found".

We don't want 300+ people having that kind of access to the sheet and being able to make changes. Is there any workaround?

Answers