Method of Data Capture, Storage and Retrieval Through User Created Form Templates and Data Item Templates by Executing Computer-Executable Instructions Stored On a Non-Transitory Computer-Readable Medium

摘要

In a method of operating a software engine for storing, organizing and reporting data in an organizational environment through user created templates and data items, users can build highly customizable templates for data and web forms for data entry, with many different specifiable attributes. Related data is linked and can be queried for retrieval. Users can design, create, add, and use unlimited number of forms, reports, business processes, and queries without any additional programming. Metadata objects (mobjects) and data items (ditems) are created by an administrator. Mobject templates are form templates that are rendered into web forms by a render module, and ditem templates are inputs and controls on the web forms. The schema of the production database remains unchanged regardless of user interaction with the system, thus providing a highly customizable data storage and organization system for any business environment.

主权项

1. A method of data capture, storage and retrieval through user created form templates and data item templates by executing computer-executable instructions stored on a non-transitory computer-readable medium comprises the steps of:
(A) providing a plurality of software modules, wherein the plurality of software modules comprises a template builder module, a central module, an environment manager module, and a render module; (B) providing a template database, an environment database, and a production database, wherein the schema of the production database is fixed and remains unchanged regardless of user interaction with the plurality of software modules; (C) providing a graphical user interface (GUI) for each of the plurality of software modules; (D) receiving input through the GUI of the template builder module from an administrator account to define a plurality of programmatic objects, wherein the plurality of programmatic objects comprises a plurality of data item (ditem) templates and a plurality of metadata object (mobject) templates, and wherein each mobject template comprises at least one ditem template; (E) storing the plurality of programmatic objects in the template database; (F) receiving a request through the central module to retrieve at least one specific mobject template from the plurality of mobject templates from the template database; (G) processing the specific mobject template through the render module in order to produce a rendered web form from the specific mobject template; (H) displaying the rendered web form to a user profile through the GUI of the central module; (I) receiving at least one user input value to the rendered web form from the user profile through the GUI of the central module, wherein each user input value corresponds to one of the ditem templates of the specific mobject template; (J) compiling the specific mobject template and each user input value in order to produce a filled mobject; (K) storing each user input value of the filled mobject as a filled ditem in the production database through the central module, wherein each filled ditem is further associated with a plurality of runtime-filled ditem values, the specific mobject template, and with a plurality of runtime-filled mobject values of the specific mobject template; (L) receiving a template request through the central module; (M) searching the template database to find a relevant mobject template, wherein the relevant mobject template corresponds to the template request; (N) searching the production database to find at least one relevant filled ditem, wherein each relevant filled ditem corresponds to relevant mobject template; (O) rendering each relevant filled ditem with the relevant mobject template as a rendered mobject page with the render module; and (P) displaying the rendered mobject page on the GUI with the central module.