Skip to content

Latest commit

 

History

History
76 lines (46 loc) · 4.19 KB

README.md

File metadata and controls

76 lines (46 loc) · 4.19 KB
Raw

Oracle APEX Application for JSON Form Creation

Introduction

Here, I present to you an Oracle Apex application. With this application, you can easily generate JSON-based forms. You don't need any knowledge of Oracle Apex, JSON, or any programming skills. You can simply create a form through a few clicks in the menu, define the columns, and optionally add properties to the columns. In the end, you have your JSON generated. It is very easy to use and user-friendly.

Demo: https://flowsforapex.com/ords/preview/r/simple-form-builder/json-sfb

Download Options

1. Local App

Description: The Local App is a local version of the application that is installed on your own server or instance. This version is publicly accessible, and any user can create, edit, and delete forms.

Important Note: In this version, every user has access to the forms of all other users. This means that all forms are public and can be viewed by anyone.

Deletion: Forms are not automatically deleted. However, users have the option to manually delete forms when they are no longer needed.

2. Cloud App

Description: The Cloud App is a hosted version of the application that operates in the cloud. This version is also publicly accessible, but each user can only view and edit their own forms.

Important Note: In this version, the forms are private and only visible to the respective creator. Other users cannot view the forms.

Deletion: Forms are automatically deleted after 24 hours. However, users have the option to manually delete forms if they wish to do so before the 24-hour period expires.

Installation

1. Step: Download the App

Download the Oracle Apex App from the official website or a provided link. Save the file on your local computer.

2. Step: Upload the App to Oracle Apex Workspace

  1. Log in to your Oracle Apex Workspace.
  2. Navigate to App Builder.
  3. Click on Import.
  4. Select the downloaded app file and follow the instructions to upload the app to your workspace.

3. Step: Install Supporting Objects

During the app installation, you will be prompted to install Supporting Objects. These must be installed. The following objects will be automatically created by the installation scripts in the background:

  • Sequences: These are used to generate unique IDs for records.
  • Tables: These store the form data.
  • Views: These provide a user-friendly view of the data.
  • Packages: These contain PL/SQL code to support the app functionality.

Note: This application uses the JSON Region Plugin by Uwe Simon, version 0.9.5. This plugin is essential for integrating and managing the JSON structures within Oracle APEX. For more information about this plugin and detailed instructions on how to configure it, please visit the official documentation.

4. Step: Launch the App

After successful installation, you can launch the app. Navigate to App Builder and click on the name of the newly installed app to start it. You can now begin creating forms directly.

Uninstallation

1. Step: Delete the App

If you want to delete the app and the associated objects, you can do this through the Oracle Apex interface:

  1. Log in to your Oracle Apex Workspace.
  2. Navigate to App Builder.
  3. Select the app you want to delete.
  4. Click on Delete.
  5. Check the box to also delete the associated objects (sequences, tables, views, and packages).
  6. Confirm the deletion.

The uninstallation of the objects will be automatically executed by an uninstallation script in the background.