AppSheet Developer Needed – Office Management App for a Law Firm (Design Ready)

We are a litigation firm with 5 users. We need one app, on phone and computer, to run the office. The design is already complete: you will receive a clickable prototype showing every screen, plus a written brief with all rules, roles and alerts. Your job is to build it properly in Google AppSheet, connected to our Google Workspace (Sheets + Drive + Gmail). Modules to build Leads: source (Referral / Justdial / Lawrato / Other), call and follow-up log, 10-minute first-contact alert, weekly follow-up reminders, auto-mark dead after 3 months, conflict check, convert to client. Tasks and team: Owner assigns tasks with deadlines; associates submit drafts as Google Doc links for review; Owner approves or returns with comments; “ask for update” on overdue tasks; workload view per associate; task timer. Clients and matters: case file page with hearing history, physical file number, stage tracking, instruction and discussion thread per case. Hearings and orders: next date entered the same day, with escalation if missing (associate → manager → owner); order downloaded and filed within 5 days; client update sent within 24 hours. Deadline tracker: automatic statutory deadline calculation (RTI, SARFAESI, limitation, replies). Fees and invoices: one-time, installment and per-hearing fee plans; recoverable expenses; invoice with terms-and-conditions library. Expenses and cash, attendance, leave, letters sent register, marketing log, reports and owner dashboard. Office notices board. Must-haves Role-based security enforced by AppSheet security filters, not just hidden columns. Four roles: Owner, Manager, Associate, Clerk. Associates must not see fees, and the Manager must not see firm totals. Drive folder permissions must match. Hindi + English labels side by side. Automatic Drive folder per client and per lead. Email alerts and a daily morning summary to the Owner. Built and tested on dummy data only; real data entered by us after handover. Everything owned by our Workspace account; your access removed at handover. Deliverables Working app (all modules), with later modules hidden from staff until we switch them on. Testing against our checklist. One staff training session (online is fine) and a short admin guide (adding users, editing T&C, adding deadline types). 1 month of free support after handover. Budget and payment Fixed price: ₹35,000 (negotiable) for the full build. Please quote Phase 1 (Leads + Tasks + Users) separately as well complete fee. Milestones: 25% at start, 25% when Phase 1 is demonstrated, 30% when all modules work on dummy data, 20% after testing, training and handover. Timeline: 3–5 weeks. NDA required before we share the prototype and brief. To apply, please answer: Share 2 AppSheet apps you have built with different user roles, plus a short screen recording of one if possible. How will you make sure an associate cannot see fee data, both in the app and in Google Drive? Have you built automated email alerts and scheduled reports in AppSheet? Give one example. Your fixed price for the full build, your price for Phase 1 alone, and your timeline. Can you work in Hindi/English and be available on IST working hours? Applications without answers to these questions will not be considered.