Basic – AJAX – Child Form Mgt

From All n One's bxp software Wixi

Jump to: navigation, search

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.
      • StaffActive – will render a list of all of the active users in the system


ChildMgt Settings.png


  • Child Record Limiting Fields
    • This is simply the ID of the child form in bxp


  • Child Record Limiting Values


  • Sort Results field


3 Operation

3.1 Data Table No Child Records Present

ChildMgt NoRecords.png


3.2 Data Table Child Records Present

ChildMgt ChildRecords.png


3.3 Add a new child record

ChildMgt AddRecord.png


3.4 Update/Delete an existing child record

ChildMgt ManageRecord.png