Form Field
Form fields are also referred as form web controls. They are web form elements for the base form, and categorized into different types.
Form Field Types
  • CheckBox: standard HTML checkbox, return 1 or nothing;
  • DateBox: date picker. Date validation;
  • DateTimeBox: date picker with time entry control. Date and time validation;
  • Duration: display duration as days, hours and minutes, return value is in number of minutes;
  • EmailBox: email entry control. Email validation; double-click to launch send email client program;
  • GridCtrl: grid view; with grid view type of Special Gridview in Base Form;
  • LookupBox: lookup picker control;
  • NumberBox: integer or float number entry control. Number formatting; number validations;
  • PhoneBox: phone number entry control. Phone number formatting; phone number validation; toll free number validation;
  • RadGroup: standard HTML radio boxes;
  • SelectBox: advanced select box control with editable option;
  • StringCtl: string used as embedded HTML segment;
  • TextArea: standard HTML text area control;
  • TextBox: standard HTML text input box;
  • UrlBox: URL entry control. URL formatting; double-click to browse the URL;
Common Form Field Attributes
  • Field Name: Display text in the front of its web field;
  • Field Type: Form field type, different field types may ask for additional attributes;
  • Logic Name: usually it is the database table column name; it is also a part of the web control's id or name. If there is a space in the logic name, it will be replaced by underscore sign. For example, text type fields with logic names of last_name and last name will be rendered to HTML the same way:
    <input name="fld_last_name" value="xxxx" type="text" ... >
  • Display Order: Display sequence in the web form;
  • Is Required: Indicate if user input is required;
  • Preview Field: Indicate if this field will be on the preview section of the base form's Grid View;
  • Section: Host form section;
  • Default Value: Default value for creating new record; if Initview SQL statement is provided for this base form, default value attribute will be read from Initview SQL instead of from this value;
  • Full Row: Indicate if this control is on the whole line, or just on a half line;
  • Read Only: Indicate if this field can be modified through this base form;
  • On Change: Client side on change event handler, it is a JavaScript function call;
  • Max Length: Max length of the characters from the user input;
  • Full Access: Full access permission key;
  • View Access: View access permission key; it applies when full access is not given.
Additional Form Field Attributes
CheckBox Additional Attributes
  • Text: Label text
GridCtrl Additional Attributes
  • Grid View: Special type grid view (FRM);
  • Section: each GridCtrl must be in a separate form tab;
LookupBox Additional Attributes
  • Reference Key: Reference key to the lookup picker;
  • Additional Parameter: Addtional parameter for lookup picker's stored procedure. Pre-defined values:
    {recId}    : will be replaced by data record id;
    {parentId} : will be replaced by data record's parent id;
    
    
    while other values will be directly sent to lookup picker's stored procedure through @param;
NumberBox Additional Attributes
  • Number Type: Integer or float;
  • Maximum Value: Upper end of the data range;
  • Minimum Value: Lower end of the data range;
  • Group: For float type number only, formatting attributes;
  • Accuracy: For float type number only, precision digits;
PhoneBox Additional Attributes
  • Is TollFree: Additional validation over the phone validation, it considers that phone numbers starting with (800/866/877/888/) are toll free numbers;
RadGroup Additional Attributes
  • Parameter One: System can pass three pre-defined values to the SQL through parameter name @p_1:
    User ID   : Login user id;
    Record ID : data record id;
    Parent ID : data record's parent id;
    
  • Parameter Two: see Parameter One, value pass to SQL through parameter name @p_2;
  • Query Database: Database where runs the query;
  • Query Type: SQL statement type: select statement or stored procedure;
  • Query SQL: Text of the select statement or stored procedure name;
SelectBox Additional Attributes
  • See RadGroup Additional Attributes;
  • Editable: Indicate if allows users to enter free text;
StringCtl Additional Attributes
  • Value Source: Indicate if the text string comes from form view SQL dynamically, or from static Content field;
  • Content: HTML code that will be directly rendered to the base form if the Value Source is set to static;
TextArea Additional Attributes
  • Height: Height of the TextArea box in pixels;
TextBox Additional Attributes
  • Text Mode: Plain text or password input mode;