Get result of picklist in a grid - Forum - Rollbase - Progress Community

Get result of picklist in a grid

 Forum

Get result of picklist in a grid

  • hi ,

    class level is an object , and the record are displayed in the picklist. 

    student is an object . 

    I want to display student by choosing a value from the picklist . 

    help !

  • Hi Abir,

    Please declare a function "loadStudents" in onchange() event handler of "class" picklist. And define the function as below in script component of new page by adding script component.

    <script>

     function loadStudents(){

      var className=rbf_getFieldValue("R48928");

      rbf_selectQuery("SELECT name FROM Student WHERE R48813="+className, 100,function    callback(arr){

      for(var i=0;i<arr.length;i++){

       rbf_addGridRow("0");

       rbf_setGridValue2("0", 'name', i, arr[i][0]);

     }

     }

     );

    }

    </script>

    Attaching app.xml for your reference. I have created three objects 1)Class 2)Students 3)Attendance. Please find the script in new page of "attendance" object.

    sample_grid.xml

    Regards,

    Shiva