Latest revision as of 15:41, 24 July 2018

Dynamic Drop-down Lists

Introduction

A dynamic drop-down list is a field in the database that is presented in the form of a list of options. It is possible to enter information directly in the field, or to select one of the predefined options.

The options presented in the list must be defined by a Prodon user directly in the field or in the " Dynamic Drop-down List Management ".

Functionality of a Dynamic Drop-down List


There are 2 ways to specify a value in a the field of a dynamic drop-down list: Via the '' Dynamic Drop-down List Management ''. It is possible to click on to select a value in the predefined list of options. (See A: on the image above) If the desired value is not part of the predefined list of options, it is possible to enter a new value in the field. NOTE: If a new value is entered in a dynamic drop-down list, this window opens up to allows you to add the new value to the predefined list of options. There are 2 ways to delete a value from the dynamic drop-down list: Via the '' Dynamic Drop-down List Management ''. Select the value to delete among the options (the value must be selected exactly the same way as the one in the image above) and then click on the " Delete " key on the keyboard. NOTE: After clicking on the " Delete " key, this window opens up to ask you to confirm that the value should really be deleted from the list. (See A: on the image above) To modify an option in the list, you must go through the '' Dynamic Drop-down List Management ".

Adding a Value to the Predefined Options List from the Field

After entering a new value in a field for the dynamic drop-down list and that value is not listed in the predefined options list, the following window opens up.

Click on " Yes " to add the new value to the predefined options in the " Dynamic Drop-down List ". By clicking on " No ", the value remains in the field, but it is not added in the " Dynamic Drop-down List ". NOTE: To define multiple new options, modify or delete certain options in the list, go to this section.

Removing a value from the predefined options list from the field

After deleting a value from a dynamic drop-down list from a field, the following window opens up.

Click on " Yes " to confirm the removal of the value in the predefined options in the " Dynamic Drop-down List ". NOTE: To delete multiple options, modify or add certain options in the list, go to this section.

Dynamic Drop-down List Management

The " Dynamic Drop-down List Management " allows you to add, modify or delete predefined options from the different " Dynamic Drop-down Lists " in Prodon.

First go to the " Dynamic Drop-down List Management ".

To do this from the software's home page, click on the " Configuration " menu, '' Customization '' and select " Dynamic Drop-down Lists ".

After clicking on the " Dynamic Drop-down Lists ", the following window opens up.

A: The button allows you to add a new predefined option into one the group lists specified in D. After clicking on that button, this window opens up.	B: The button allows you to modify an option in E. To do so, select the option in the list that needs to be modified, then click on the button. After clicking on that button, this window opens up.
C: The button allows you to delete an option in E. To do so, select the option in the list to delete, then click on the button. After clicking on that button, this window opens up.	D: These are the field groups in Prodon that are dynamic drop-down lists.
E: These are the predefined options of all the dynamic drop-down lists in Prodon.	CAUTION: Make sure no items contain that value before deleting it, otherwise, the items that contain this value will now have that value emptied. For more information, see this section.

Adding an option in the dynamic drop-down list from the " Dynamic Drop-down List Management "

After clicking on the button, the following window opens up.

A: Select the field group of the drop-down list for which an option will be added.	B: Enter the value for the new predefined option.

Modifying an option in the dynamic drop-down list from the " Dynamic Drop-down List Management "

After clicking on the button, the following window opens up.

A: Select the field group from the drop-down list in which an option will be modified.	B: Enter the new value for the predefined option.
C: If this checkbox is checked, the new value entered in B will be assigned to the items that contain the old value.	D: This is the number of items to which the value that is going to be modified is specified to.

Removing an option from the dynamic drop-down list from the "Dynamic Drop-down List Management"

After clicking on the button, the following window opens.

A: This is the field group in the dynamic drop-down list for which the option B should be deleted.	B: This is the value that will be deleted from the predefined options in the dynamic drop-down list.
C: If this checkbox is checked, all the items that contain the value at B will be emptied.	D: This is the number of items to which the value to delete is specified to.
CAUTION: Make sure the number of items mentioned at D is down to 0 before deleting the value, otherwise, the information in this value will become empty.

Document name: Common functions:Dynamic Drop-down Lists

Printable version

Difference between revisions of "Common functions:Dynamic Drop-down Lists"

Latest revision as of 15:41, 24 July 2018

Contents

Introduction

Functionality of a Dynamic Drop-down List

Adding a Value to the Predefined Options List from the Field

Removing a value from the predefined options list from the field

Dynamic Drop-down List Management

Adding an option in the dynamic drop-down list from the " Dynamic Drop-down List Management "

Modifying an option in the dynamic drop-down list from the " Dynamic Drop-down List Management "

Removing an option from the dynamic drop-down list from the "Dynamic Drop-down List Management"

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Menu

ProDon

Tools

@@ Line 1: / Line 1: @@
 {{Header_TOC}}
+'''<u>CAUTION</u>''' : This document is for '''VERSION''' '''5''' of  '''''Prodon'''''. To go to the document for version 4, [[Common functions:Dynamic Drop-down Lists (Version 4)|click here]]. <br>
 <br>
@@ Line 5: / Line 7: @@
 = Introduction  =
-A dynamic drop-down list is a field of the database that is presented in the form of a list of options. It is possible to enter information directly in the field, or to select one of the predefined options.&nbsp;
+A dynamic drop-down list is a field in the database that is presented in the form of a list of options. It is possible to enter information directly in the field, or to select one of the predefined options.&nbsp;
-The options presented in the list must be defined by a '''''ProDon''''' user directly in the field or from the "Dynamic drop-down list management".
+The options presented in the list must be defined by a '''''Prodon''''' user directly in the field or in the " Dynamic Drop-down List Management ".
-'''<u>CAUTION</u>''' : This document is for '''VERSION''' '''5''' of '''''Prodon'''''. To go to the document for version 4, [[ProDon:Preferences_(Version_4)|click here]]. <br><br><span style="color: rgb(255, 0, 0);">'''WARNING&nbsp;: This document is currently being edited/revised, it is possible that some parts are missing or obsolete.'''</span>
 <br>
-== Functioning of a Dynamic Drop-down List <br>  ==
+== Functionality of a Dynamic Drop-down List    ==
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 001.png]]<br>
+| colspan="2" | [[File:Prodon5 Dynamic Drop-down Lists 001.png]]
 |-
 | colspan="2" |
 There are 2 ways to specify a value in a the field of a dynamic drop-down list:&nbsp;
-#It is possible to click on [[Image:Dynamic drop-down list button.png]] to select among the predefined options of the list.
+#Via the [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|<nowiki>''</nowiki> Dynamic Drop-down List Management <nowiki>''</nowiki>]].
-#If the desired value is not part of the predefined option list, it is possible to enter a new value in the field. <br>'''NOTE:''' If a new value is entered in a dynamic drop-down list, [[Common functions:Dynamic Drop-down Lists#Adding_a_Value_to_the_Predefined_Option_List_from_the_Field|this window]] opens to allow you to add the new entered value to the predefined option list.&nbsp;
+#It is possible to click on [[Image:Dynamic drop-down list button.png]] to select a value in the predefined list of options. (See <span style="color: rgb(255, 0, 0);">'''A:'''</span> on the image above) If the desired value is not part of the predefined list of options, it is possible to enter a new value in the field. <br>'''NOTE:''' If a new value is entered in a dynamic drop-down list, [[Common functions:Dynamic Drop-down Lists#Adding_a_Value_to_the_Predefined_Option_List_from_the_Field|this window]] opens up to allows you to add the new value to the predefined list of options.&nbsp;
-There are 2 ways to delete a value from the dynamic drop-down list: <br>
+There are 2 ways to delete a value from the dynamic drop-down list:
-#Via the [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|dynamic drop-down list management]].<br>
+#Via the [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|<nowiki>''</nowiki> Dynamic Drop-down List Management <nowiki>''</nowiki>]].
-#Select the value to delete among the options (the value must be selected exactly in the same way as the one in the image above) and then click on the "Delete" key of the keyboard. <br>'''NOTE:''' After clicking on the "Delete" key, [[Common functions:Dynamic Drop-down Lists#Removing_a_Value_from_the_Predefined_Option_List_from_the_Field.C2.A0|this window]] opens to confirm that the value should really be removed from the list. <br>
+#Select the value to delete among the options (the value must be selected exactly the same way as the one in the image above) and then click on the " Delete " key on the keyboard. <br>'''NOTE:''' After clicking on the " Delete " key, [[Common functions:Dynamic Drop-down Lists#Removing_a_Value_from_the_Predefined_Option_List_from_the_Field.C2.A0|this window]] opens up to ask you to confirm that the value should really be deleted from the list. (See <span style="color: rgb(255, 0, 0);">'''A:'''</span> on the image above)  <br>
-To modify an option in the list, you absolutely need to go through the [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|dynamic drop-down list management]].<br>
+To modify an option in the list, you must go through the [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|<nowiki>''</nowiki> Dynamic Drop-down List Management "]].<br>
 |}
@@ Line 36: / Line 36: @@
 <br>
-=== Adding a Value to the Predefined Option List from the Field  ===
+=== Adding a Value to the Predefined Options List from the Field  ===
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 |-
 | colspan="2" |
-After entering a new value in a field of the dynamic drop-down list and this value is not part of the predefined option list, the following window opens.
+After entering a new value in a field for the dynamic drop-down list and that value is not listed in the predefined options list, the following window opens up.
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 002.png]]
+| colspan="2" |[[File:Prodon5 Dynamic Drop-down Lists 002.png|316x316px]]
 |-
 | colspan="2" |
-Click on "[[Image:Button Check mark Confirm.png]] Yes" to add a new value to the predefined options of the dynamic drop-down list.
+Click on " [[Image:Button Check mark Confirm.png]] Yes " to add the new value to the predefined options in the " Dynamic Drop-down List ".
-By clicking on "[[Image:Button cancel.png]] No", the value remains in the field, but is not added to the dynamic drop-down list.&nbsp;
+By clicking on " [[Image:Button cancel.png]] No ", the value remains in the field, but it is not added in the " Dynamic Drop-down List ".&nbsp;
-'''NOTE:''' To define many new options, to modify or to remove certain options of the list, see [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|this section]].&nbsp;&nbsp;
+'''NOTE:''' To define multiple new options, modify or delete certain options in the list, go to [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|this section]].&nbsp;
 |}
@@ Line 57: / Line 57: @@
 <br>
-=== Removing a Value from the Predefined Option List from the Field&nbsp;  ===
+=== Removing a value from the predefined options list from the field&nbsp;  ===
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 |-
 | colspan="2" |
-After deleting a value from a dynamic drop-down list from a field, the following window opens.&nbsp;
+After deleting a value from a dynamic drop-down list from a field, the following window opens up.&nbsp;
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 003.png]]<br>
+| colspan="2" |[[File:Prodon5 Dynamic Drop-down Lists 003.png|frameless|330x330px]]
 |-
 | colspan="2" |
-Click on "[[Image:Button Check mark Confirm.png]] Yes" to confirm the removal of the value from the predefined options of the dynamic drop-down list.&nbsp;
+Click on " [[Image:Button Check mark Confirm.png]] Yes " to confirm the removal of the value in the predefined options in the " Dynamic Drop-down List ".&nbsp;
-'''NOTE:''' To delete many options, to modify or to add certain options of the list, see [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|this section]].&nbsp;
+'''NOTE:''' To delete multiple options, modify or add certain options in the list, go to [[Common functions:Dynamic Drop-down Lists#Dynamic_Drop-down_List_Management|this section]].&nbsp;
 |}
 <br>
 == Dynamic Drop-down List Management  ==
-The "Dynamic drop-down list management" allows you to add, modify or remove predefined options from the different dynamic drop-down lists in '''''ProDon'''''.<br>
+The " Dynamic Drop-down List Management " allows you to add, modify or delete predefined options from the different " Dynamic Drop-down Lists " in '''''Prodon'''''.<br>
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 |-
 | colspan="2" |
-First go to the "Dynamic drop-down list management".&nbsp;
+First go to the " Dynamic Drop-down List Management ".&nbsp;
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 004.png]]<br>
+| colspan="2" | [[File:Prodon5 Dynamic Drop-down Lists 004.png|frameless|421x421px]]
 |-
 | colspan="2" |
-To do so, from the software's home page, click on the "Configuration" menu, then select "Dynamic drop-down lists".
+To do this from the software's home page, click on the " Configuration " menu, <nowiki>''</nowiki> Customization <nowiki>''</nowiki> and select " Dynamic Drop-down Lists ".
 |}
@@ Line 98: / Line 98: @@
 |-
 | colspan="2" |
-After clicking on "Dynamic drop-down lists", the following window opens.
+After clicking on the " Dynamic Drop-down Lists ", the following window opens up.
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 005.png]]<br>
+| colspan="2" | [[File:Prodon5 Dynamic Drop-down Lists 005.png]]
+|-
+|<span style="color: rgb(255, 0, 0);">'''A:'''</span> The [[Image:Button add plus.png]] button allows you to add a new predefined option into one the group lists specified in&nbsp;<span style="color: rgb(255, 0, 0);">'''D'''</span>. After clicking on that button, [[Common functions:Dynamic Drop-down Lists#Adding_an_Option_to_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22|this window]] opens up.&nbsp;
+|<span style="color: rgb(255, 0, 0);">'''B:'''</span> The [[Image:Button Edit.png]] button allows you to modify an option in&nbsp;<span style="color: rgb(255, 0, 0);">'''E'''</span>. To do so, select the option in the list that needs to be modified, then click on the [[Image:Button Edit.png]] button. After clicking on that button, [[Common functions:Dynamic Drop-down Lists#Modifying_an_Option_of_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22.C2.A0|this window]] opens up.&nbsp;
 |-
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''A:'''</span> These are the fields of '''''ProDon''''' that are dynamic drop-down lists.&nbsp;
+<span style="color: rgb(255, 0, 0);">'''C:'''</span> The [[Image:Button Minus remove delete.png]] button allows you to delete an option in <span style="color: rgb(255, 0, 0);">'''E'''</span>. To do so, select the option in the list to delete, then click on the [[Image:Button Minus remove delete.png]] button. After clicking on that button, [[Common functions:Dynamic Drop-down Lists#Removing_an_Option_from_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22.C2.A0|this window]] opens up.
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''B:'''</span> These are the predefined options of all the dynamic drop-down lists in '''''ProDon'''''.
+<span style="color: rgb(255, 0, 0);">'''D:'''</span> These are the field groups in '''''Prodon''''' that are dynamic drop-down lists.&nbsp;
-|-
-|
-<span style="color: rgb(255, 0, 0);">'''C:'''</span> The [[Image:Button add plus.png]] button allows you to add a new predefined option to the list specified at&nbsp;<span style="color: rgb(255, 0, 0);">'''A'''</span>. After clicking on that button, [[Common functions:Dynamic Drop-down Lists#Adding_an_Option_to_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22|this window]] opens.&nbsp;
-|
-<span style="color: rgb(255, 0, 0);">'''D:'''</span> The [[Image:Button Edit.png]] button allows you to modify an option at&nbsp;<span style="color: rgb(255, 0, 0);">'''B'''</span>. To do so, select the option to modify, then click on the [[Image:Button Edit.png]] button. After clicking on that button, [[Common functions:Dynamic Drop-down Lists#Modifying_an_Option_of_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22.C2.A0|this window]] opens.&nbsp;
 |-
 |
-<span style="color: rgb(255, 0, 0);">'''E:'''</span> The [[Image:Button Minus remove delete.png]] button allows you to delete an option at <span style="color: rgb(255, 0, 0);">'''B'''</span>. To do so, select the option to modify, then click on the [[Image:Button Minus remove delete.png]] button. After clicking on that button, [[Common functions:Dynamic Drop-down Lists#Removing_an_Option_from_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22.C2.A0|this window]] opens.
+<span style="color: rgb(255, 0, 0);">'''E:'''</span> These are the predefined options of all the dynamic drop-down lists in '''''Prodon'''''.
 |
-'''CAUTION:''' Make sure no element contains the value before deleting it; otherwise, the elements that contain this value will become empty. For more information, see [[Common functions:Dynamic Drop-down Lists#Removing_an_Option_from_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22.C2.A0|this section]]. <br>
+'''CAUTION:''' Make sure no items contain that value before deleting it, otherwise, the items that contain this value will now have that value emptied. For more information, see [[Common functions:Dynamic Drop-down Lists#Removing_an_Option_from_the_Dynamic_Drop-down_List_from_the_.22Dynamic_drop-down_list_management.22.C2.A0|this section]].
 |}
@@ Line 127: / Line 123: @@
 <br>
-=== Adding an Option to the Dynamic Drop-down List from the "Dynamic drop-down list management"  ===
+=== Adding an option in the dynamic drop-down list from the " Dynamic Drop-down List Management "  ===
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 |-
 | colspan="2" |
-After clicking on the [[Image:Button add plus.png]] button, the following window opens.&nbsp;
+After clicking on the [[Image:Button add plus.png]] button, the following window opens up.&nbsp;
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 006.png]]<br>
+| colspan="2" | [[File:Prodon5 Dynamic Drop-down Lists 006.png]]
 |-
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''A:'''</span> Select the field of the drop-down list for which an option should be added.&nbsp;
+<span style="color: rgb(255, 0, 0);">'''A:'''</span> Select the field group of the drop-down list for which an option will be added.&nbsp;
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''B:'''</span> Enter the value of the predefined option.
+<span style="color: rgb(255, 0, 0);">'''B:'''</span> Enter the value for the new predefined option.
 |}
@@ Line 147: / Line 143: @@
 <br>
-=== Modifying an Option of the Dynamic Drop-down List from the "Dynamic drop-down list management"&nbsp;  ===
+=== Modifying an option in the dynamic drop-down list from the " Dynamic Drop-down List Management "&nbsp;  ===
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 |-
 | colspan="2" |
-After clicking on the&nbsp;[[Image:Button Edit.png]] button, the following window opens.
+After clicking on the&nbsp;[[Image:Button Edit.png]] button, the following window opens up.
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 007.png]]<br>
+| colspan="2" | [[File:Prodon5 Dynamic Drop-down Lists 007.png]]<br>
 |-
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''A:'''</span> Select the field of the drop-down list for which an option should be modified. <br>
+<span style="color: rgb(255, 0, 0);">'''A:'''</span> Select the field group from the drop-down list in which an option will be modified.
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''B:'''</span> Enter the new value of the predefined option. <br>
+<span style="color: rgb(255, 0, 0);">'''B:'''</span> Enter the new value for the predefined option. <br>
 |-
 |
-<span style="color: rgb(255, 0, 0);">'''C:'''</span> If this checkbox is checked, the new value entered at <span style="color: rgb(255, 0, 0);">'''B'''</span> will be assigned to the elements that contained the old value. <br>
+<span style="color: rgb(255, 0, 0);">'''C:'''</span> If this checkbox is checked, the new value entered in <span style="color: rgb(255, 0, 0);">'''B'''</span> will be assigned to the items that contain the old value.
 |
-<span style="color: rgb(255, 0, 0);">'''D:'''</span> This is the number of elements in which the value to modify was specified.&nbsp;
+<span style="color: rgb(255, 0, 0);">'''D:'''</span> This is the number of items to which the value that is going to be modified is specified to.&nbsp;
 |}
@@ Line 174: / Line 170: @@
 <br>
-=== Removing an Option from the Dynamic Drop-down List from the "Dynamic drop-down list management"&nbsp;  ===
+=== Removing an option from the dynamic drop-down list from the "Dynamic Drop-down List Management"&nbsp;  ===
 {| width="200" cellspacing="1" cellpadding="1" border="1" class="wikitable"
@@ Line 182: / Line 178: @@
 |-
-| colspan="2" | [[Image:Dymanic Drop-down Lists 008.png]]<br>
+| colspan="2" | [[File:Prodon5 Dynamic Drop-down Lists 008.png]]<br>
 |-
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''A:'''</span> This is the field of the dynamic drop-down list for which the option at <span style="color: rgb(255, 0, 0);">'''B'''</span> should be removed.
+<span style="color: rgb(255, 0, 0);">'''A:'''</span> This is the field group in the dynamic drop-down list for which the option <span style="color: rgb(255, 0, 0);">'''B'''</span> should be deleted.
 | width="50%" |
-<span style="color: rgb(255, 0, 0);">'''B:'''</span> This is the value that will be removed from the predefined options.
+<span style="color: rgb(255, 0, 0);">'''B:'''</span> This is the value that will be deleted from the predefined options in the dynamic drop-down list.
 |-
 |
-<span style="color: rgb(255, 0, 0);">'''C:'''</span> If this checkbox is checked, all the elements that contain the value at <span style="color: rgb(255, 0, 0);">'''B'''</span> will become empty.
+<span style="color: rgb(255, 0, 0);">'''C:'''</span> If this checkbox is checked, all the items that contain the value at <span style="color: rgb(255, 0, 0);">'''B'''</span> will be emptied.
 |
-<span style="color: rgb(255, 0, 0);">'''D:'''</span> This is the number of elements in which the value to remove was specified.&nbsp;
+<span style="color: rgb(255, 0, 0);">'''D:'''</span> This is the number of items to which the value to delete is specified to.&nbsp;
 |-
 | colspan="2" |
-'''CAUTION:''' Make sure the number of items at <span style="color: rgb(255, 0, 0);">'''D'''</span> is down to '''0''' before deleting the value; otherwise, the elements that contain this value will become empty.&nbsp;
+'''CAUTION:''' Make sure the number of items mentioned at <span style="color: rgb(255, 0, 0);">'''D'''</span> is down to '''0''' before deleting the value, otherwise, the information in this value will become empty.&nbsp;
 |}