AppSheet: Different Views For Different Users

In this video, I’ll show you how to set up security filters in Google AppSheet to control data visibility based on user types (aka roles). Using a "Service Requests" sample app, I walk through creating expressions that let managers see all data while restricting technicians to only being able to see their own records. I also demonstrate how to test filters using different user logins. Subscribe for more AppSheet videos, and let me know what topics you’d like to see covered next. ➡️ 🤩 Up your AppSheet game with our AppSheet Advisor AI Assistant, the AppSheet expert that works right alongside you. It gives you instant answers to your AppSheet questions as you work, so you can build what you want faster. Try it free at https://appsheetadvisor.com Here's the expression I used in the video. You can copy/paste/edit with your own table and column names to use it in your own security filters. OR( LOOKUP(USEREMAIL(),"Users","Email","Type")="Manager", [Assigned To]=USEREMAIL() )