Basic – AJAX – Child Form Mgt - Revision history

Philip Lacey at 16:10, 27 September 2017

2017-09-27T16:10:53Z

Meabh Landers at 09:32, 30 January 2017

2017-01-30T09:32:37Z

Philip Lacey at 10:35, 30 August 2016

2016-08-30T10:35:02Z

Patrick Jenkins at 09:38, 30 August 2016

2016-08-30T09:38:58Z

Patrick Jenkins: Created page with " == Overview == Bxp allows for a user when creating or modifying a form to add a question type which allows for the Adding/Updating and Deletion of records in a child databas..."

2016-08-30T09:23:47Z

Created page with " == Overview == Bxp allows for a user when creating or modifying a form to add a question type which allows for the Adding/Updating and Deletion of records in a child databas..."

New page

== Overview ==

Bxp allows for a user when creating or modifying a form to add a question type which allows for the Adding/Updating and Deletion of records in a child database. This Question type is called “Basic – AJAX – Child Form Mgt”.

== 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'''
** This should be the fields from the child form that you require to 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'''
** This 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'''
** This should be the headings that you want to assign 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'''
** This should be the headings that 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'''
** This should be the types of questions that 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 want to get the answer values for.

← Older revision		Revision as of 16:10, 27 September 2017
Line 1:		Line 1:
		+	= 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”.		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 54:		Line 55:


−	[[File:ChildMgt_Settings.png\|~~900px~~]]	+	[[File:ChildMgt_Settings.png\|800px]]
		+
		+
		+	* '''Child Record Limiting Fields'''
		+	** This is simply the ID of the child form in bxp
		+
		+
		+	* '''Child Record Limiting Values'''
		+	**
		+
		+
		+	* '''Sort Results field'''
		+	**

← Older revision		Revision as of 09:32, 30 January 2017
Line 51:		Line 51:
	*** 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 wsih to get the answer values for.		*** 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

@@ Line 2: / Line 2: @@
 = Overview =
-Bxp allows for a user when creating or modifying a form to add a question type which allows for the Adding/Updating and Deletion of records in a child database. This Question type is called “Basic – AJAX – Child Form Mgt”.
+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'''
-**	This should be the fields from the child form that you require to be included in the data table, each field should be separated by a | symbol
+**	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'''
-**	This should contain the fields in the child form that will be inserted to and updated, each field should be separated by a | symbol
+**	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'''
-**	This should be the headings that you want to assign to the questions when the Addition/Update interface is displayed on screen, each field should be separated by a | symbol
+**	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'''
-**	This should be the headings that you want to apply to each column in the data table, each field should be separated by a | symbol
+**	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'''
-**	This should be the types of questions that you want to apply to the Addition/Update interface, each field should be separated by a | symbol
+**	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
 ***	Date – will render a date box
@@ Line 50: / Line 50: @@
 ***	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 want to get the answer values for.
+***	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.