Idea Summary
Enhance the Create Application from File wizard to support multi-sheet Excel workbook upload with automatic table creation, foreign key detection, and master–detail page generation. Currently, APEX supports single-sheet upload only. Many real-world Excel files contain normalized relational data across multiple sheets (e.g., Customers → Orders → Order Items). Supporting multi-sheet upload would allow APEX to automatically create related tables, define foreign key constraints, and generate fully functional master–detail forms, interactive reports, and navigation.
Use Case
This enhancement accelerates rapid application development, improves first-time user onboarding, enables seamless Excel-to-APEX migration, and strengthens APEX’s position as a leading low-code platform for citizen developers and enterprise application modernization.
Preferred Solution (Optional)
Enhance the wizard to detect multiple sheets, allow relationship mapping, create tables with foreign keys, and automatically generate master-detail pages.