Skip to content

Quickforms Applications

Jump to bottom
Imaobong Eyoma edited this page Jun 12, 2015 · 3 revisions

Introduction

Quickforms applications are BI apps built over the Quickforms application framework.The apps use form-based interfaces to collect data and a star-schema multi-dimensional database that is optimized for reporting. The BI app is defined by linking the user interfaces to the reporting database. A set of controls and templates defined in the Quickforms application framework [library](Quickforms\ Library) is used to build the apps. We will use the following simple sample application to learn how to create an application in Quickforms.

Sample Application

This is a simple application used for reference purposes and to quickly learn how to build an app in Quickforms. It is created for a student to register for their term as a full-time or a part-time student.

  • The application starts with a login page. Login credentials (username and password) are used to grant users access to different functions of the application and to protect data.

  • The main features of the application includes the navigation bar, the table summary, the reports, different kinds of forms, team members and much more.

  • Once the user has successfully logged into the app, the landing page will look like this termed as a homepage for the application.

http://imgur.com/FZVf11i.png

  • The navigation bar is divided into three parts: Forms (Students), Reports and Team Members representing the navigation on the homepage.

    1. The forms section would allow us to add new forms (collect data) and submit them to the database as well.
    2. The reports section is to generate simple and explanatory reports based on the data submitted.
    3. The team members section is used to view current members of the application and also to add any new member to the application.

  • Also, on the homepage a summary table can be provided to list the most relevant data elements we enter in the forms.

Backend

  • Behind the scenes of the application, we need certain JS files, CSS and follow the configuration settings to get the application up and running.

Database

  • The applications follow a start-schema database model. The star-schema is the simplest form of a data-mart with one or more fact tables referencing any number of lookup tables. The schema for this application looks like this:

patientRegistrationDatabaseDiagram

We will guide you through creating and enhancing on each section as you proceed through the tutorials.

Tutorials

  • [Get Started](Get\ Started)
Clone this wiki locally