Hi Stamen

I've tried to wire that in (as per code below), but it's not working because the datasource for the combo column is still empty at this point.  I've put a break point in my GetComboData() and it isn't called until the combo is dropped down for the first time.  Is there something I need to do to get it to eager load the data?  I tried adding a DataBind call in the comboEditorOptions but that didn't help.  Do you have an example of this that I could look at?

@(Html.Infragistics()
.Grid(Model)
.ID("grid1")
.PrimaryKey(nameof(LuItemType.ItemTypeId))
.UpdateUrl(Url.Action("UpdatingSaveChanges", "ItemType"))
.AutoGenerateLayouts(false)
.AutoCommit(true)
.Columns(column =>
{
column.For(x => x.ItemTypeId).HeaderText("ItemTypeId").DataType("number").Hidden(true);
column.For(x => x.ItemDesc).HeaderText("Description").DataType("string");
column.For(x => x.SafeWorkingLoad).HeaderText("SWL").DataType("string");
column.For(x => x.InspectionPeriodId).HeaderText("InspectionPeriod")/*.FormatterFunction("lookupProductName")*/;
})
.Width("600px")
.Height("500px")
.Features(features =>
{
features.Updating()
.EditMode(GridEditMode.Row)
.EnableDeleteRow(true)
.EnableAddRow(true)
.ColumnSettings(settings =>
{
settings.ColumnSetting().ColumnKey(nameof(LuItemType.ItemDesc))
.EditorType(ColumnEditorType.Text).Required(true).Validation(true);
settings.ColumnSetting().ColumnKey(nameof(LuItemType.SafeWorkingLoad))
.EditorType(ColumnEditorType.Text).Required(true).Validation(true);
settings.ColumnSetting().ColumnKey(nameof(LuItemType.InspectionPeriodId))
.EditorType(ColumnEditorType.Combo)
.ComboEditorOptions(options =>
{
options.DataSourceUrl(Url.Action("GetComboData", "ItemType"))
.TextKey(nameof(LuInspectionPeriod.InspectionDesc))
.ValueKey(nameof(LuInspectionPeriod.InspectionPeriodId))
.EnableClearButton(true)
.Mode(ComboMode.DropDown);
})
.Required(true).Validation(true);

});

features.Sorting().ColumnSettings(sorting =>
{
sorting.ColumnSetting().ColumnKey(nameof(LuItemType.ItemDesc))
.CurrentSortDirection("ascending").AllowSorting(true);
});

})
.AddClientEvent("rendered", "fillList()")
.DataSourceUrl(Url.Action("GetGridData", "ItemType"))
.DataBind()
.Render())
<br />
<input type="button" class="btn btn-success" id="saveChanges" value="Save Changes" />

<script type="text/javascript">

$("#saveChanges").bind({
click: function () {
$("#grid1").igGrid("saveChanges");
}
});

function fillList() {
fillProductNameLookup(lookupProductList);
}

// from https://es.infragistics.com/community/forums/p/72892/370474.aspx#370474
function fillProductNameLookup(objectToFill) {
var colSettings = $("#grid1").igGridUpdating("option", "columnSettings");
var colSetting;
for (var i = 0; i < colSettings.length; i++) {
colSetting = colSettings[i];
if (colSetting.columnKey === "InspectionPeriodId") {
if (colSetting.editorType && colSetting.editorType === "combo") {
var ds = colSetting.editorOptions.dataSource;
var textKey = colSetting.editorOptions.textKey;
var valueKey = colSetting.editorOptions.valueKey;
var item;
for (var j = 0; i < ds.length; i++) {
item = ds[i];
objectToFill[item[valueKey]] = item[textKey];
}
}
break;
}
}
}

var lookupProductList = {};

function lookupProductName(productNumber) {
return lookupProductList[productNumber];
}
</script>

The column then gets its data as follows:

column.For(x => x.InspectionPeriodId).HeaderText("InspectionPeriod").FormatterFunction("lookupProductName");

So I've tried to get Martin's solution working as follows:

<script type="text/javascript">

$("#saveChanges").bind({
click: function () {
$("#grid1").igGrid("saveChanges");
}
});

fillProductNameLookup(lookupProductList);

function fillProductNameLookup(objectToFill) {
var colSettings = $("#grid1").igGridUpdating("option", "columnSettings");
var colSetting;
for (var i = 0; i < colSettings.length; i++) {
colSetting = colSettings[i];
if (colSetting.columnKey === "InspectionPeriodId") {
if (colSetting.editorType && colSetting.editorType === "combo") {
var ds = colSetting.editorOptions.dataSource;
var textKey = colSetting.editorOptions.textKey;
var valueKey = colSetting.editorOptions.valueKey;
var item;
for (var j = 0; i < ds.length; i++) {
item = ds[i];
objectToFill[item[valueKey]] = item[textKey];
}
}
break;
}
}
}

var lookupProductList = {};

fillProductNameLookup(lookupProductList);

function lookupProductName(productNumber) {
return lookupProductList[productNumber];
}
</script>

The problem I'm having though is that fillProductNameLookup(lookupProductList) is trying to run before the grid is initialised.  Currently I'm not using the loader (I'm using the CDN), but even if I was I don't know how I'd force this code to run after the mvc wrapper has completed?  Is there a "grid initialized" event I can wrap the fillProductNameLookup(lookupProductList) call in?