Selectbox Grouping Dependency Based on Parent Form Field

Introduction

Learn how to set up a dropdown select box in a grid form that dynamically adjusts its options based on a parent form field's value. This approach is useful for creating dependent or grouped selections in forms, improving performance by limiting the available options based on user inputs.

How does it work?

To achieve dynamic drop-down options based on a parent form field value, follow these steps:

1. In the child form, create a hidden field called dept
2. Use a Custom HTML script to transfer the value from a parent form field to the child form. This enables the child form to use the parent’s value for filtering options.
   

   <script>
   $(function(){
       dept = window.top.$("input[name='department']:checked").val();
       FormUtil.getField("dept").val(dept);
   });
   </script>

    

3. Utilize the Field ID to control available options based on Grouping attribute in the Select Box configuration. This ensures that the dropdown options are populated according to the value copied from the parent form.
   
   
   
4. This will filter dynamically to the users based on department selected.
   

Download sample app