Limited information about the hiring company was provided at the time of listing. This opportunity was shared based on details made publicly available by the employer. Applicants are advised to review the official job page for full and updated company information.

I am a BCA student seeking an AppSheet professional to build a robust factory management system. I have the database, workflow recordings, and mapping ready. I need a Logic Sprint focused on technical execution and error-proofing.

Project: AppSheet Expert - Inventory BOM Logic & OCR
Budget: $350 (Fixed Price) + $50 Bonus for Perfect Delivery
Timeline: 5-7 Days (Approx. 10-15 hours of work)
Location: Remote

Specific responsibilities were not disclosed. For similar roles, tasks typically vary by employer and may be outlined during the application or interview process. Applicants should refer to the official source for accurate role expectations.

• Zero-Error BOM Logic: You must build a Referenced Action Loop using a "Recipe" table (mapping products to 12+ components) that triggers atomically when a job is marked "DONE," ensuring all parts are subtracted accurately in one sync.
• Perfect OCR Implementation: Configure Document AI for Sales/Vendor bills. It must include a "Confidence/Review Screen" for data verification before it hits inventory and must handle variations in bill layouts.
• The "Safety Layer": Prevent common errors like double-deduction, negative stock, and ensure stock recalculates correctly if old production/sales rows are edited or deleted.
• Automated PDF Lists: Create 3 distinct templates (Fitting, Packing, and Vendor Orders) that trigger automatically based on row updates.

Why this is a 10-15 hour project:
I am handling the data entry and the BOM mapping. I am looking for the "technical wiring" and error-handling logic. No "80-hour" quotes, please.

The "Error-Proofing" Checklist (What the solution must handle):

• OCR Accuracy: Map bill text (e.g., '14 MUSTANG') to exact Inventory IDs intelligently.
• The "Revert" Error: Automatically add back parts if a job status is changed from 'DONE' back to 'To-Do'.
• Vendor Mapping: Ensure ordering PDFs only list parts linked to that specific vendor.
• Mobile Stability: The 'DONE' action must be fast and use a Grouped Action to prevent app freezing on mobile.

To Apply:
DM me and explain your strategy for ensuring OCR accuracy and how you prevent Sync Errors in a multi-row reference loop via the link: https://www.reddit.com/r/AppSheet/comments/1rf5n4c/hiring_appsheet_expert_inventory_bom_logic_ocr/

For a detailed understanding of the workflow, please review the voice recordings here:
https://drive.google.com/drive/folders/1UJvl9FhQQGC3mJ5W8VzMQ9-QQgeCJPLR