## **Project Scope: Filter App** ### **1. Objective** To create a secure, mobile-accessible internal tool for instantly filter databases based on specific client requirements. ### **2. Key Features** * **User Authentication:** Secure Google Login for authorized personnel only. * **Multi-Criteria Search:** A dedicated "Search Box" to filter data by: * **Name** (Client name ) * **City** (Location) * **Model** * **Automated Data Slicing:** Real-time logic that hides irrelevant data and shows only matching records. * **Backend Sync:** Fully integrated with Google Sheets for easy, manual data updates. ### **3. Technical Stack** * **Platform:** Google AppSheet. * **Database:** Google Sheets (Cloud-synced). * **Logic:** Custom AppSheet Slices with `UNIQUEID()` and `AND/OR` expression filters. ### **4. User Workflow** 1. **Login** → 2. **Input Filters** (via Search Form) → 3. **Save** → 4. **View Results** (Filtered List).