On drop down values selection, grid should be displayed accordingly

Question

Hi All, 
 I have drop down component where I'm populating values from the dbase column. 
 I'm trying to code the below functionality. 
 1) An editable grid should be displayed on initial selection of any drop down value. 
 2) Grid values should be refreshed on every change in the drop down value selection. 
 
 Is there any way we can dynamically make the grid appear on initial selection of the values(AFAIK we can create an editable grid as an sail interface and looping into the main interface conditionally) Any other approach?? 
 Any suggestions .. 
 
 TIA..

abishekk109 · Answer

Use the gridlayout component inside a with () and use the showWhen: when the dropdown value <> null.. This will achieve the above scenario :)

shafaly · Answer

Hi nalinib0001, 
 
You can use like : 
 
load( 
local!Value, /* You can initialize the initial value here*/ 
with( 
local!Datasubset : rule!ReturnsDatasubset(local!Value), /*It will returns datasubset on the basis of value*/ 
a!dropdownField( 
 label:"", 
 choiceLabels:{}, 
 choiceValues:{}, 
 value:local!Value, 
 saveInto:local!Value 
), 
a!gridField( 
 /*Grid code using local!Datasubset*/ 
) 
) 
) 
 
It will automatically update the data of grid on the basis of selection. 
 
I hope this will help you. 
 
Thanks

ankita0004 · Answer

Extract the value of grid data varibale in the save into of dropdown like this: 
 
load(local!data1, 
local!GridData, 
a!dropdownField( 
 placeholderLabel:"Please select a velue", 
 choiceLabels:{}, 
 choiceValues:{}, 
 value:local!data1, 
 saveInto:{ 
 local!data1, 
 a!save( 
 local!gridData, queryEntity call by local!data1 paas as parameter 
 ) 
 } 
) 
 
when you refresh the dropdown than saveinto of it will run and editable grid data will refresh but at the same time you are updating in editable grid than that data will loose you have to append that data also in different local variable.