BMM | Configurable data collection app

CONTACT

In Brief

'User Data Entry Form (Form 1)' enters the user's details into the Database.
'Data Display Table (Table 1)' displays the last entry made into the Database from Form 1.
'Admin Control Form (Form 2)' sets the entry fields that display in Form 1.

'User Data Entry Form (Form 1)' - Instructions

Enter test data into Form 1 below and click the "Submit" button.
A successful submission will be displayed in Table 1.
If a field appears blank in Table 1, or is mentioned here in these instructions but you cannot see it on Form 1, it is because the field has been deselected in Form 2.
All fields that appear on Form 1 are mandatory fields apart from the second or third lines of the address, which are the only optional fields.
A minimum and maximum age restriction may apply to the "Date of birth" field (if this has been enabled in Form 2). This will limit the available dates that can be used in the calendar.
Form 1 can be set with an expiry date and time, after which no more entries are allowed. If no fields are visible and Form 1 is displaying an "expired" notice, the expiry date will need to be reset in Form 2 below.
↓ Note: This is a dummy database so do NOT enter real data. ↓

User Data Entry Form (Form 1)

Win a sunny holiday competition

What do you have to lose?

Title :

*

First Name : *

Last Name : *

Date of birth : *

E-mail : *

Phone Number : *

Address Details
Address Line 1 : *

Address Line 2 :

City : *

Postcode : *

Country : *

In 50 words or less, describe why you are the best thing since toasted bread.
*

This is the last entry that was made to the database:

Data Display Table (Table 1)

Title :	Mx
First Name :	Rob
Last Name :	Roy
Gender :
Date of birth :	10/07/1989
E-mail :	rr1234@gmail.com
Phone Number :	07253819992
Address Line 1 :	99 old new road
Address Line 2 :	battersby
Address Line 3 :	Cambridge
City :	Cambridge
Post Code :	CA13 9BT
Country :	GB
Free Text :	Sliced bread has nothing on me!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

'Admin Control Form (Form 2)' - Instructions

Change any of the field settings in Form 2 below.
Always click the "Update" button when you have finished making changes or they will not be saved.
After you have saved any changes, refresh the page by clicking the "Refresh Page" button and the changes you have made will be visible in Form 1 above.
If a field is selected by ticking the checkbox next to it, the field description becomes highlighted in green and that field (once the settings are saved) will be displayed on Form 1. Conversely, if the field is deselected (and you save the settings and refresh the page), it will no longer appear on Form 1.
Once the expiry date (set at the bottom of Form 2) has passed, it will no longer be possible to submit data in Form 1. Change the expiry date to a future date to continue using Form 1.
All fields can be selected or deselected using the checkbox at the bottom of Form 2.

Admin Control Form (Form 2)

Control Panel for Data Entry Form

Key - indicates that the field is selected and will appear on the user's data input form

Custom Header
"Custom Header" field required?

Custom Header : (You have characters remaining)

"Custom Header Text" field required?

Custom Header Text : (You have characters remaining)

"Title" field required?

"First Name" field - always required

"Last Name" field required?

"Gender" field required?

Date of birth

Date of birth entries can be restricted to a minimum and/or a maximum age.
This will prevent a user from entering an age that is outside of those limits.
Set the value to zero (or clear the field) to remove any age restriction.

"Date of birth" field required?

Minimum Age (years) :

Maximum Age (years) :

"E-mail" field required?

"Phone number" field required?

Address Lines required

If address lines are displayed, only the first address line is a mandatory field.

"Address line" fields required?

Address Line 1 only

Address Line 1 and 2 only

Address Line 1, 2 and 3

"City" field required?

"Post code" field required?

"Country field" required?

Free Text

The "rows" and "columns" settings below control the height and width of the text input field.

"Free text" field required?

Free Text rows (field height):

Free Text columns (field width):

Free text header field required?

Free text header : (You have characters remaining)

Form Colour

Choose one of the 3 options below to set the form colour.
The "Hex" option allows a hexadecimal colour value to be typed/copied into the field.
"Alpha" controls the transparency of the form (1 = fully opaque, 0 = fully transparent).
The setting from the "Alpha" field is always used irrespective of which of the 3 options is selected.

Form Colour (presets):

Form Colour (HEX):

Form Colour (RGB): : : :

Change the colour settings to view the results :

TEST

Alpha :

Form expiry date and time: Form time zone:

Select/deselect all fields

More Detail

This is a fully configurable data collection form. You (the data collector) can easily set up a form to collect the exact data you wish to collect. A "user" (visitor to your website) who completes the form, will only be required to complete those fields that you have specified are required.
There are 2 forms on this page. The first form is the 'User Data Entry Form (Form 1)' which updates an on-line database. The last record that has been entered into the database by a "user", (using Form 1) is displayed in Table 1.
In Table 1, where entries against fields are blank, this is because these fields were NOT specified as required in the 'Admin Control Form (Form 2)', at the time the form was completed.
In practice, Form 1 and Form 2 would be on separate pages (Form 2 would be in a separate "administrator" module) but the 2 forms have been put on the same page for purposes of the demonstration.
In a real life scenario, the steps involved for data collection would be something like:
1) As a website owner, you embed Form 1 in your own website with a few simple lines of code.
2) You go to your "administrator" module on my website and using Form 2, you configure Form 1 for the data collection you require.
3) You download and use the data you have collected from Form 1 using the "administrator" module (this aspect has not been shown in this demo).
4) As and when required, you can completely change the look and purpose of the embedded form from Form 2 in the "administrator" module without having to touch the code on your website, e.g. you could start a new competition seamlessly when one ends.
5) You can set an expiry date so that no data collection is allowed past a certain date.
6) A second form (or third, etc.) could be embedded on your website for a different data collection exercise.