AppSheet Field and making filters

## **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).