|
|
|
|
|
| |
Configuring Fields in HTML Forms
You can use the fields configuration page to configure your entry forms. This form can be found under settings > 'Configure Your Database' > Fields option. You would need administrative account to access this option.
Before using this tool, we reccomend you to be little fimiliar with HTML Tags and their attributes. However you can still try various of the options using one by one and figure out results.
| Sr. | Field | Type | Property | Source / Value | Message | Title | * reqd |
Sr. will show you no. of rows.
Field Name column will show you a dropdown of all the fields from the table you have selected. Note that in order to configure fields you do not have to follow the sequential order of the fields of the table.
Field Type lets you configure the following field types, each one is explained below;
1. Text
2. Textarea
3. Select
|
4. CheckBox
5. Radio
6. SQL
|
7. Hidden
8. Label
9. Hidden + Label
|
10. Password
11. Not Wanted
12. Link
13. File Or Image
|
Property column lets you configure HTML properties of Field Type. For example, Text field size can be configured to 40 by including Size=40 in the property field.
Text given here will appear inside the tag of the fields such as;
<INPUT type=text name=task Size=40 >
or
<TEXTAREA Name=Address Rows=5 Cols=40>,
This would be the result of value ‘Rows=5 Cols=40’ in property field when the field type is text area.
Source field lets you define the data source in case of CheckBoxes, Radio, Select Boxes, SQL etc. This is explained in sections below.
Message allows you to define any message to be displayed at the time of entering the data of a perticular field. such as please enter date in format DD MON YYYY
If the Title is specified, it is displayed instead of the usual field name.
*Reqd defines mandatory fields, and makes sure that those fields are filled before data goes into the database.
Defining Field Properties and Source Values (Examples)
You can configure a field for following behaviours (given with example);
Text - try Size=40 value to increase the size of text box (alternatively you can also use style tag i.e., style='width:100;', learn about CSS Stylesheets Here.)
Textarea - Try Rows=5 Cols=40 in properties field in order to define size of a Textarea Box.
Select -
This one is for Dropdowns. To configure enter ‘1:Yes,0:No’ in source field, and 1(or 0, i.e., value which will appear as selected value) in property field.
Check Box -
If you want values from the database, enter a SQL query selecting two columns from database ID and its corresponding Text. Alternatively, enter ‘1:first value,2:second value’ in Source Field.
Default values can be checked or unchecked based upon following parameters;
By default, all values will be unchecked.
In Property field,
If hyphen ‘-’ is entered all values will be checked.
Alternatively, enter values you want to be selected in property fields and end them with comma, for example, it should appear like 1, 2, etc. the string should end with comma and a space to make it work.
When the form is submitted, values will be stored in comma separated format in the database. i.e., 1002, 1004, 1005
Radio Buttons - The usage is similar to the Check Box. When displayed in the form, you can select only one value out of all choices.
SQL -
You can define a SQL query in Source field, this will fetch data from that perticular table in the SQL Server and populate the dropdown. Make sure to select two columns from the table, first column will be mostly ID, and second will be text to be displayed in the dropdown. For example your SQL query should look like;
Select ID, Title From Status Where [Used For] Like ‘Material’
You can have default selected by entering the value in Property field.
You also can generate a multiple select box by entering ‘Multiple’ text in Property field. This will be similar to Check Boxes, and the values will be stored in comma separated format. i.e., 1002, 1004, 1005.
Other Field Types
Hidden -
Hidden fields are hidden variables which carries a value without showing it to end user. You can define it by entering a value in Source field. This also is used in order to hide parent table columns which are automatically taken by the system.
Hidden + Lebel -
This is similar to the Hidden field. The only difference is that it shows the value while displaying all the fields and also makes a provision for sending the same value to the application when the form is submitted.
Label -
At the time of data entry it allows user to enter a value, but at the time of editing record it will just show the value not allowing anyone to modify it.
Password - is a password field.
Not Wanted - The field would not be displayed in the form, neither it will store or retrieve any value. These are mostly used when you manually intend to use them by other means of programming.
Link - Used for linking a table to its parent table.
File Or Image - This is for storing documents or images. you must define File Folder in the properties window of any table before setting any field to this data type. Make sure these folders are into your web directory with write permissions. Refer online for setting permissions on your IIS.
|
|
| |
