Difference between revisions of "Basic – AJAX – Child Form Mgt"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
|||
| Line 2: | Line 2: | ||
= Overview = | = Overview = | ||
| − | + | bxp allows a user when creating or modifying a form to add a question type which allows Adding, Updating and Deletion of records in a child database. This Question type is called “Basic – AJAX – Child Form Mgt”. | |
| Line 22: | Line 22: | ||
* '''Fields to render in Data Table''' | * '''Fields to render in Data Table''' | ||
| − | ** | + | ** These should be the fields from the child form that should be included in the data table, each field should be separated by a | symbol |
** ''Example -'' strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3 | ** ''Example -'' strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3 | ||
* '''Fields to Insert/Update''' | * '''Fields to Insert/Update''' | ||
| − | ** | + | ** These should contain the fields in the child form that will be inserted to and updated. Each field should be separated by a | symbol |
** ''Example -'' strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3|strCDA_2_field_0_4 | ** ''Example -'' strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3|strCDA_2_field_0_4 | ||
* '''Management Interface Question headings''' | * '''Management Interface Question headings''' | ||
| − | ** | + | ** These should be the headings you are assigning to the questions when the Addition/Update interface is displayed on screen. Each field should be separated by a | symbol |
** ''Example –'' First Name|Surname|D.O.B|Phone Number | ** ''Example –'' First Name|Surname|D.O.B|Phone Number | ||
* '''Data Table Column Headings''' | * '''Data Table Column Headings''' | ||
| − | ** | + | ** These should be the headings you want to apply to each column in the data table. Each field should be separated by a | symbol |
** ''Example –'' First Name|Surname|D.O.B | ** ''Example –'' First Name|Surname|D.O.B | ||
* '''Management Interface Question types''' | * '''Management Interface Question types''' | ||
| − | ** | + | ** These should be the types of questions you want to apply to the Addition/Update interface. Each field should be separated by a | symbol |
| − | ** The following are the allowed question types | + | ** The following are the allowed question types: |
*** Text – will render a text box | *** Text – will render a text box | ||
*** Date – will render a date box | *** Date – will render a date box | ||
| Line 50: | Line 50: | ||
*** Truefalse – will render a True/False drop down list | *** Truefalse – will render a True/False drop down list | ||
*** Number[x] – will render a number list drop down list – replace X with the number to stop at i.e. x=50 will give you a number list of 1-50 | *** Number[x] – will render a number list drop down list – replace X with the number to stop at i.e. x=50 will give you a number list of 1-50 | ||
| − | *** Custom[x] – will render a custom drop down list of answer values in a child form question – replace x with the strCDA_X_field_X_X of the question you | + | *** Custom[x] – will render a custom drop down list of answer values in a child form question – replace x with the strCDA_X_field_X_X of the question you wsih to get the answer values for. |
Revision as of 11:35, 30 August 2016
Contents
1 Overview
bxp allows a user when creating or modifying a form to add a question type which allows Adding, Updating and Deletion of records in a child database. This Question type is called “Basic – AJAX – Child Form Mgt”.
2 Question Settings
- Child Form Id
- This is simply the ID of the child form in bxp
- Field that store parent link
- This is the filed in the child form that contains the intCDA_X_Id of the parent from record i.e. the foreign key
- Example - strCDA_2_field_0_0
- Custom Table CSS
- This allows the user to apply their own custom CSS to the DIV that the rendered AJAX table is in. If no custom CSS is required simply add NULL to this option
- Fields to render in Data Table
- These should be the fields from the child form that should be included in the data table, each field should be separated by a | symbol
- Example - strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3
- Fields to Insert/Update
- These should contain the fields in the child form that will be inserted to and updated. Each field should be separated by a | symbol
- Example - strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3|strCDA_2_field_0_4
- Management Interface Question headings
- These should be the headings you are assigning to the questions when the Addition/Update interface is displayed on screen. Each field should be separated by a | symbol
- Example – First Name|Surname|D.O.B|Phone Number
- Data Table Column Headings
- These should be the headings you want to apply to each column in the data table. Each field should be separated by a | symbol
- Example – First Name|Surname|D.O.B
- Management Interface Question types
- These should be the types of questions you want to apply to the Addition/Update interface. Each field should be separated by a | symbol
- The following are the allowed question types:
- Text – will render a text box
- Date – will render a date box
- Datetime – will render a date time box
- Yesno – will render a Yes/No drop down list
- Truefalse – will render a True/False drop down list
- Number[x] – will render a number list drop down list – replace X with the number to stop at i.e. x=50 will give you a number list of 1-50
- Custom[x] – will render a custom drop down list of answer values in a child form question – replace x with the strCDA_X_field_X_X of the question you wsih to get the answer values for.
3 Operation
3.1 Data Table No Child Records Present
3.2 Data Table Child Records Present
3.3 Add a new child record
3.4 Update/Delete an existing child record
