Source of truth
Every workflow needs to know which table owns the data, which table is output, and which fields automation may update.
- Source of truth
- Output table
- Lookup table
- Audit log
OPERCEL Documentation
Data and permission design
How OPERCEL handles Excel, Google Sheets, Lark Base, SharePoint, and APIs without creating unmanaged access risks.
Role-based access
Operators, managers, admins, and workflow credentials should not all have the same permissions.
- RBAC
- Workflow credentials
- No frontend secrets
- Test/production separation
Validation
Validation prevents bad data from entering reports and downstream workflows.
- Required fields
- Quantity limits
- Email/date/number formats
- Abnormal data alerts