AppSheet Expert: Factory Production & Inventory System with OCR AI Project Overview I am looking for a professional AppSheet developer to build a manufacturing and inventory management system from scratch using Google Sheets as the backend. I have a BCA background and have already drafted the initial table structures, but I need an expert to build a robust "Logic Engine" that ensures data accuracy and automation. Technical Scope & Deliverables 1. Relational Database Architecture • Build a clean relational model in Google Sheets with four primary tables: Inventory, Production, Sales, and Staff. • Implement proper Reference (Ref) links so that Production jobs are tied to specific Staff and Inventory items. 2. Live Master Inventory Logic • Dynamic Calculations: The Current Stock column in the Inventory table must be a live "App Formula" using SUM(SELECT()). • Logic Requirements: Stock must automatically increase when a Production job status is marked as "DONE" and decrease based on Sales entries. • The Bridge: Set up an Automation Bot that triggers a system "Edit" or "Sync" action on the Inventory table whenever a production status changes to ensure the Master Formula recalculates instantly. 3. AI & Advanced Automation • OCR Document AI: Enable and train an OCR model for the Sales table. The app must allow a user to photograph a bill (e.g., for "Mustang" bike models) and automatically extract the Item Name and Quantity into the data fields. • Automated PDF Reports: Create an automation that generates a "Daily Production Work Order" PDF whenever a new production task is assigned. The PDF must pull data dynamically from the Staff and Production tables. 4. User Experience & Security • UX Rules: Implement conditional formatting so that inventory counts turn Red when they drop below the defined "Minimum Level." • Security Configuration: Correctly configure security options (specifically "Secure Image Access") to ensure the OCR model and PDF generator have the necessary permissions to read spreadsheet data. • Management Dashboard: Build a high-level view for management to track production efficiency and total stock value. What I am Providing • Clear column names and business requirements (e.g., specific product names like 14 MUSTANG EVA). • A clear understanding of the workflow from job assignment to final sale. • Sample data for testing purposes. Candidate Requirements • Proven experience with AppSheet Automation Bots and Bridge Actions. • Expertise in AppSheet OCR (Document AI). • Strong command of AppSheet Expressions (SELECT, FILTER, LOOKUP). app or software or webpage compatible with pc iphone and android I THINK IF POSSIBLE OPEN SOURCE OR ON GOOGLE APP SHEET SOME MODS ON THE WAY WORKSHEETS NEEDED TOTAL STOCK FITTED MATERIAL PACKED MATERIAL MATERIAL PACKED MATERIAL FITTED EMPLOYEE LINKAGE PENDING ORDERS PDF LISTS NEEDED PACKING FITTING ORDERING THINGS TO DO APPSHEET LINKAGE OF DIFFERENT SHEETS AND TABLES BOT INTEGRATION AS WELL AS TRAINING OCR AS AND WHEN NEEDED WORKFLOW WOULD BE LIKE THS 1.WE WOULD ADD ALL THE ITEMS AVAILABLE AND THERE QUANTITY IN TOTAL STOCK 2. WE PRINT AN ORDER LIST AND SHIFT TO PENDING ORDERS DATE WISE OR ORDER WISE LINKED TO OUR PARTIES AND ITEM FROM STOCK AND SEND TO VENDOR 3. WHENEVER A BILL COMES IN WE UPLOAD ITS PIC(USE OF OCR MAYBE) WHICH WILL DO TWO THINGS ADD THE STOCK THAT CAME TO TOTAL STOCK SUBTRACT FROM PENDING ORDERS (HAS TO SUBTRACT ON PRO RATA BASIS) 4. WE PRINT A FITTING LIST AND HAND IT OVER IT DOES TWO THINGS SHIFT THE PTODUCTS TO FITTING(AND TO FITTED MATERIAL WHEN MARKED AS DONE) SUBTRACT THAT QUANTITY FROM TOTAL STOCK OF ALL THE RELEVANT MATERIALS 5. NOW WE PRINT A PACKING LIST IT DOES TWO THINGS SHIFT THE PTODUCTS TO PACKING(AND TO PACKED MATERIAL WHEN MARKED AS DONE) SUBTRACT THAT QUANTITY FROM FITTED MATERIAL AND TOTAL STOCK OF ALL THE RELEVANT MATERIALS 6. NOW WE UPLOAD THE FINAL SALE BILL AND ITS JUST GETS SUBTRACTED FROM PACKED MATERIAL NOTES 1. A CONFIRMATION DIALOGUE FOR ADDING AND SUBTRACTING OF MATERIALS TO KNOW IF ITS DOING CORRECT SHOULD BE THERE EDITABLE IF ITS NO ELSE JUST A YES OR NO 2. WE MUST BE ABLE TO TRAIN THE BOT OR AI FOR EG WHEN WE UPLOAD A BILL SOME TIMES IT WOULD BE 20 MUDGUARD 20 FIGHTER MUDGUARD 20 HERO MUDGUARD AND THE ITEM IN OUR LIST WOULD BE 20 MUDGUARD ONLY IT SHOULD BE ABLE TO MATCH THE BEST AND ADD AND SUBTRACT ACCORDIGLY