HTML form "spreadsheet" enhancer
Program for re-sale.
In a programming language of your choice, plus Javascript / PHP.
I want a program/script that will give basic spreadsheet functionality to HTML forms, taking into account that although text fields are simiilar to spreadsheets cells, that radio buttons, checkboxes and selection menus are not.
I see several parts to the program: (1) A PHP library file that provides the spreadsheet functionaility (2) Some Javascript added to the HTML form page to help with the control (3) A file containing the data required for the HTML form (4) A program that adds the data and functionality to an existing form, and generates the data file.
Background Features
1. Works with existing HTML forms.
2. To deal with form elements that may already have assigned values, etc.
3. To work like a spreadsheet.
4. Basic error checking, though I haven't really thought through what happens if someone subsequently edits a form, so that the save data/actions no longer apply because some of the form elements are missing, or have changed names.
5. This doesn't have to be WYSIWYG, though it would be useful to be able to select form elements with a mouse. I guess that Row/Column indicators will not be applicable.
Example functionality
1. On selecting a particular radio buttons, or checkbox, or selection box, a value is selected in a text box. For example, Given a choice of three radio buttons: 1st Class. Surface Mail. Airmail, on selecting Surface Mail, $3.00 is placed in a specified text box.
2. Spreadsheet like calculations:
.. a. Add up the values in selected text fields, and place the result in another.
.. b. To carry about basic arithmetic on a text field, and place the result in another.
.. c. To specify the format and accuracy of the results, eg. Currency symbol = £, 2 decimal places.
.. d. etc
3. To perform basic validation on Submit. Selected text fields must contain either:
.. a. Any content
.. b. Text only
.. c. Numeric only.
.. d. Contains a currency value
.. e. etc
4. Special consideration for the Submit button, eg:
.. a. Go to another page and/or form
.. b. Ready data for Post/Get
.. c. Pass all values to a form-to-email script for emailing results
5. Some basic form element editing
.. a. Changing element names
.. b. Specify which radio buttons for a group
.. etc
I want to keep this program fairly basic to start with, so if any of these options are very difficult, let me know an we'll cut it out, or compromise. Or if you can think of features which are easy to add, then let me know.
The project will be fairly open-ended, but I'd like to start with a basic working version, which we could later enhance by arrangement. At the very least, I'd like to start by using the program to create a simple Order Form, that would add-up totals, and let people select postage rates, etc.
I am also happy to consider you waiving your programmer's fee in return for a split of the profits.
.