Application URL: developer.qrimp.com

Category: Community

Overview: As one of the initial users trained in the Qrimp Platform, I was asked by the company founder to use the Platform to create an application that would manage all aspects of the development community.

Specifications:The developer network website was created to provide help files, forums for public discussion, feedback, module management and trouble ticket management. Some areas of the site, such as the Help Files, were to be made available to the public, and others, such as Trouble Tickets, were to be restricted to use by registered users.

The data model for this application includes several data sets acting mostly independently of one another. I created a Help Topics table with the columns: Title, Description, Date Added, Display Order and "Parent Topic". The "Parent Topic" column is a self-referencing relationship that allows for a tree view, so that sub-topics can appear for certain help topics.

As an example of another data set, the "Modules" table is more complex. In addition to the necessary information gathered in the table, it allows module creators to choose the category of their entry from a drop-down list, which is a separate look up table called "Categories".

Several layers of security restrict public access to the developer application data. For the Feedback table, I created custom CRUD permissions to allow anonymous visitors to read and add feedback, while restricting them from deleting any content.

------------------------------------------

Application URL: tara.qrimp.com

Category: Personal Web Sites

Overview: I wanted an application that would store my artistic creations and personal files in one location.

Specifications: This is a fairly simple database application, with a very flat structure and few relationships. I created tables for different categories of artwork, such as Drawings, Paintings, Poems, Blog, etc, and gave these tables public read access. The general public can browse files simply by clicking on the blue arrow buttons. Logged in users can add new content.

I also used this application to create a data set for a private survey that could be completed from a web site. The Survey table contained fields for the questions, with several look-up tables that connected to the Surveys table in a one-to-one relationship. This enabled survey takers to choose options from drop-down lists or radio buttons as appropriate.

-------------------------------------------------------

This is just a brief overview of the types of applications that we can build. If you are interested in having Dented Pen create a similar site for your organization, contact us today.