Challenge
Challenge
Excel was the source of truth, but operators should not need to open the workbook, find the right sheet, enter the right columns, and remember every stock update step.
Manufacturing / Microsoft 365
SharePoint-based intake and production forms
The business already used Excel on SharePoint, but warehouse intake, production reporting, and stock checks still required too much manual spreadsheet work. OPERCEL built dedicated web forms connected through Microsoft Graph and n8n, keeping the workbook as the source of truth while making daily input easier.
2operating forms
6lookup tables
200live checks
Approach
Approach
- Keep SharePoint and Excel as the data layer instead of forcing a full system replacement.
- Read supplier, fish lot, size, semi-finished goods, and staff lists before rendering the forms.
- Build separate forms for material intake and production reporting with loading states, local Vietnam date defaults, and stock checks.
Expected result
Expected result
- Operators work through a clean form instead of touching a complex workbook directly.
- Lookup lists come from live data, so form options follow the workbook.
- The business keeps its Microsoft 365 workflow while gaining a safer input layer.