Article Details
Id:15894
Product:finPOWER Connect
Type:NEW
Version:3.01.11
Opened:25/02/2019
Closed:25/02/2019
Released:03/04/2019
Job: J021926

HTML Widgets; Grids; Editable columns now have more advanced list support

Editable String columns in grids now have more advanced list support.

Previously, a "listCsv" option could be defined when adding a String column. This would provide a dropdown list for data entry.

Resolvable lists have been added, e.g.:

C.gridClients.AddColumnString("Branch", { caption: "Type", allowEdit: true, list: "RANGE.Branches", idColumn: "BranchId", column: "BranchId,Name", limitToList: true });

C.gridAccounts.AddColumnString("Ledger", { caption: "Type", allowEdit: true, list: "LIST.AccountLedger", limitToList: true });

Collections have also been added, e.g.:

// Define collection
var arr = [];
arr.push({AccountRoleId: "B", Description: "Borrower", Signatory: true});
arr.push({AccountRoleId: "G", Description: "Guarantor", Signatory: false});

C.gridClients.AddColumnString("AccountRoleId", { caption: "Role", width: widget.UI.FIELD_WIDTH_CODE_10, allowEdit: true, collection: arr, idColumn: "AccountRoleId", columns: "Description,Signatory" });