ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: rgorantla on October 11, 2017, 11:47:19 pm

Title: Fill for select list
Post by: rgorantla on October 11, 2017, 11:47:19 pm

Hi ,

I have a select list with an Id mapped to different column similar to what you have in demo.


https://paramquery.com/pro/demos33/datamap

in this demo: select 1 from column A - column b,c,d populate

Now fill the 2nd row,3rd row with 1st row in column A - column A get populated for both rows but not b,c

Any solution?

Title: Re: Fill for select list
Post by: paramvir on October 12, 2017, 09:47:49 pm

Autofill doesn't work for dataMap.

It works if at least one of the dependent column is converted to formula.

Code: [Select]

            { title: "Name", dataIndx: "name",
formula: function(ui){
var rd = ui.rowData,
id = ui.rowData.id;
if(id){
var item = itemlist.find(function(item){
return item.id==id
});
rd.deliverytime = item.deliverytime;
rd.unitprice = item.unitprice;
return item.name;
}
}
     },

As a side note, converting one column to formula field ( as in code above ) is more performant than converting all dependent columns.