Use data to generate your app
Spreadsheets are useful tools to organize data, perform calculations and create charts, but what if many users need to enter, update and retrieve data? Or what if you need to give customers, suppliers or partners access to the data? Inevitably you will have challenges with version and access control.
Rather than sharing spreadsheets with others to gather or distribute information, with Oracle APEX Application Development, you can create a spreadsheet-based web app in minutes without writing any code. The result will be a secure, scalable, multi-user application that provides a single source of truth for your data.
Proficiency level: Beginner citizen developer or professional developer
Time to complete: 10 minutes
Cost: Free Tier eligible
Technologies used:
Oracle APEX Application Development
Get help:
Ask the community
Watch how-to videos
Read documentation
Setup: Creating Your APEX Environment - 5 minutes
Create an APEX service instance and APEX workspace for your team.
Lab 1: Creating an App from a Spreadsheet - 5 minutes
Upload data from a spreadsheet and automatically create a project application that displays the data in a variety of ways.
Lab 2: Improving the Faceted Search - 10 minutes
Give your users the ability to find data based on facets, which are different types of criteria that you define.
Lab 3: Improving the Report and Form - 20 minutes
Use filters and calculations to view report data in different ways. Link to a form where you can change application data.
Lab 4: Linking the Calendar - 5 minutes
Create a calendar event link to a form where you can manipulate data.