Custom Data Entry Input Programs

Web Developer, Jon Holmquist, has years of experience in programming and database design. He has applied his experience to create an AJAX-based *, comprehensive suite of Shopping Cart web application programs for developers to use in their own projects. The "back-end" database management tools include data entry programs for every database file in the module.

We have special tools that allow us to quickly (one-day turn-around) create inexpensive, custom data entry input web-application programs for developers to use in their own projects. We can produce simple, single table programs (try this simple demo), or more complex, dual table programs that allow you to edit a secondary relational table from the same interface. For example, edit an invoice, and its related detail lines from one program (try this complex demo).

*Ajax (Asynchronous JavaScript and XML) is a relatively new web development technique for creating interactive web applications. It is rapidly gaining in popularity for the seemless and responsive interactive experience it provides to users. Traditional client-server processing requires a barely-noticed, but annoying, refresh of the page, which can add confusion if your page position is shifted. AJAX allows instantaneous database updates, page updates, message boxes, etc., without ever leaving the current page and focus.

For us to create your web application programs, all we need are the definitions of the tables you're working with. For example, if your are working in MySQL, and have the proper privledges to access your database, you can copy this definition into a file. The command line syntax would be:
mysqlshow ‹databasename› ‹tablename› › ‹tablename›.def
(where the variables within the "‹›" are the actual names of your database and table).

The table definition of our simple demo table looks like this:

Database: iwddb  Table: contdemo
+-----------+-------------+--------+------+-----+-----+---------+-------+-----+
| Field     | Type        | Collat | Null | Key | Def | Extra   | Privil| Com |
+-----------+-------------+--------+------+-----+-----+---------+-------+-----+
| contid    | int(11)     |        | NO   | PRI |     | auto_inc| select|     |
| username  | varchar(32) | latin1 | NO   | MUL |     |         | select|     |
| email     | varchar(32) | latin1 | NO   |     |     |         | select|     |
| phone     | varchar(32) | latin1 | NO   |     |     |         | select|     |
| conttype  | int(11)     |        | NO   |     |     |         | select|     |
| comments  | text        | latin1 | NO   |     |     |         | select|     |
| listoptin | tinyint(1)  |        | NO   |     |     |         | select|     |
| credtime  | datetime    |        | NO   |     |     |         | select|     |
+-----------+-------------+--------+------+-----+-----+---------+-------+-----+

Try out both of our Data Entry Input Program Demos, the simple demo and the complex demo. They are both fully functional examples of data entry programs for finding, entering, navigating forward and backward through, and deleting fictional contact and invoice information.

Features

• Convenient access to data with multiple functions in a single interface
• Find records to edit by entering a partial key
• Target record is displayed in the middle of a list with similar neighbors above and below
• Select record to edit from list with a single mouse click
• List allows Next and Previous page scanning with buttons deactivated at maximum and minimum limits
• 'Add This' button automatically changes to 'Update' after add
• Main edit page displays record key number
• Main edit page allows Next and Previous record scanning with buttons deactivated at maximum and minimum limits
• Delete buttons prompt for delete confirmation
• Entry values are error checked for type for numerical and date types
• Drop down menus work for static values or values obtained from external relational tables
• 'Complex' programs integrate relational table data entry to primary table data entry
• Custom functions available, e.g. a summation function from line items - Amount Due in invoice example
• Custom button functionality available
• Image display functionality available
• Display label for key id from an external table

Please contact us for questions or more information about our custom data entry programs.