Welcome to F4E AppSheet Documentation
Welcome to the comprehensive documentation for the Food for Education (F4E) AppSheet Kitchen Operations Management System. This system is designed to streamline and automate kitchen operations, meal planning, and resource management across F4E's school feeding program.
What is the F4E AppSheet System?
The F4E AppSheet App (Kitchen Ops) is a comprehensive digital solution that manages the entire kitchen operations workflow for Food for Education's school feeding program. It handles everything from meal planning and projection management to consumption tracking and inventory management.
Key Capabilities
- Meal Planning: Creation and managing meal plans for different kitchen types
- Projection Management: Track student, staff, and teacher projection & actual numbers for accurate planning
- Consumption Tracking: Calculation of planned quantities per school projection in a plan
- Picking Management: Generate and manage picking lists for kitchen managers to record actual quantity per item.
- Inventory Management: Track stock levels, stock requisition, stock adjustments and counts
- School Operations: Manage school projection detail data, BOM configurations, and school program types
- Cross-Platform Access: Accessible on desktop & mobile for field operations
System Architecture
The system consists of several interconnected components:
Business Operations Covered
Based on the database schema analysis, the system supports 7 major business functions:
| Business Function | Tables Involved | Key Features |
|---|---|---|
| Kitchen Operations | public.kitchen, meal_plan, plan | Kitchen management, meal planning, capacity tracking |
| Warehouse | request, ingredients, product_master,stock_summary | Inventory management |
| Finance | consumption, ingredients, stock_adjustment, stock_summary, picking, stock_count | Cost tracking, budget planning, financial reporting |
| School Operations | public.school, projection, school_bom | School management, projection tracking, BOM configuration |
| Production Planning | plan, projection, ingredients | Production scheduling, recipe management, capacity planning |
| Reporting & Analytics | plan_recipe_log, audit tables | Performance metrics, audit trails, data analytics |
| Compliance & Audit | All tables (audit fields) | Change tracking, user action logging, data integrity |
User Roles
The system is designed for different user roles:
- Kitchen Managers: Daily kitchen operations, meal preparation, inventory management
- Warehouse Associate: Inventory management, stock request review, stock issuance
- Finance Associate: Stock counts, stock adjustment
- Admin: System configuration, user management, meal planning, BOM assign per school, kitchen & school update, bots configuration, daily watch (monitoring kitchens)
Getting Started
Ready to dive in? Here's how to get started:
- System Overview - Understand the system architecture
- User Guides - Learn how to use the system for your role
- Technical Reference - Deep dive into technical details
- Troubleshooting - Resolve common issues
System Statistics
- 16 Database Tables directly integrated with AppSheet
- 11 Trigger Functions managing business logic
- 7 Business Functions supported
- 4 User Roles with different access levels
Technical Foundation
The system is built on:
- AppSheet: Mobile-first application platform
- PostgreSQL: Robust database with advanced trigger system
- Google Workspace: Integration with Google services
- External APIs: Data synchronization with other F4E systems
Support
Need help? We're here to support you:
- Email: [email protected]
- Documentation: This comprehensive guide
- Troubleshooting: Overview
- FAQ: Frequently Asked Questions
Ready to explore? Start with the System Overview to understand how everything works together, or jump straight to the User Guides if you're ready to start using the system.