Jqgrid - vertical column orientation

It seems that jqgrid by default displays the columns horizontally, in the usual table view from above. This is great in most cases, but I have a situation where I want to display only one single record, but I want the columns to move vertically on the left side of the screen. And each data value will be to the right of the column header to the left. This table has about 30 columns, too many to go through the top, and I don't want to use horizontal scrolling.

I want this orientation type in my jqgrid:

Col1 Foo1 Col2 Foo2 Col3 Foo3 

I do not like:

 Col1 Col2 Col3 Foo1 Foo2 Foo3 Foo4 Foo5 Foo6 

And there will always be only 1 entry. How can i achieve this? And how to enable vertical scrollbar? I want users to be able to scroll down to see all the columns.

+4
source share
3 answers

How about adding a column to the top of the grid and then using formatting to create the html.

You can hide other columns when done. This assumes that everything is correctly configured on the grid, for example, columns (colNames and colModel) and json from the server.

Also, I think there might be some confusion about what you are trying to configure, given your simple example

Col1 Foo1 Col2 Foo2 Col3 Foo3

I would think that you want to be able to maintain a β€œform” layout of some type, consisting of data retrieved from the server, not necessarily 2 columns, but a disparate layout. I could be wrong.

 function detailFormatter(cellvalue, options, rowObject) { var content = "<form>"; content += "<fieldset>"; content += "<legend>Personalia:</legend>"; content += "Name: <input type='text' value='" + rowObject[3] + "' /><br />"; content += "Email: <input type='text' /><br />"; content += "Date of birth: <input type='text' />"; content += "</fieldset>"; content += "</form>"; return content; } var col_names = ['', 'Qty', 'ATR', 'Item #', 'Brand', 'Product', 'Catalog', 'Price', 'UOM', 'Case', 'Remarks', 'Wt.', 'ProductId']; var col_model = [ { name: 'Details', index: 'Details', formatter: detailFormatter }, { name: 'Quantity', index: 'Quantity', width: 22, title: false, sorttype: "number", editable: true, edittype: 'text', editoptions: { size: 10, maxlength: 15} }, { name: 'ProductAttributes', index: 'ProductAttributes', hidden: true }, { name: 'ItemNum', index: 'ItemNum', width: 50, align: "right" }, { name: 'BrandName', index: 'BrandName', width: 100 }, { name: 'ProducName', index: 'ProducName', width: 150 }, { name: 'Catalog', index: 'Catalog', width: 100 }, { name: 'Price', index: 'Price', width: 40, sorttype: "number", align: "right" }, { name: 'UOM', index: 'UOM', width: 30 }, { name: 'CasePack', index: 'CasePack', width: 30 }, { name: 'PackageRemarks', index: 'PackageRemarks', width: 80 }, { name: 'AveWeight', index: 'AveWeight', width: 30, title: false, align: "right" }, { name: 'ProductId', index: 'ProductId', hidden: true, key: true } productGrid = $('#productGrid'); productGrid.jqGrid({ scroll: 1, url: '/Buyer/ProductSearch/ProductsDetailService/', datatype: 'json', ajaxGridOptions: { contentType: "application/json" }, jsonReader: { root: 'rows', page: 'page', total: 'total', records: 'records', repeatitems: true, cell: "cell", id: "ProductId" }, colNames: col_names, colModel: col_model, rowNum: 100, // number of records per page mtype: "GET", rownumbers: true, rownumWidth: 40, height: 600, autowidth: true, sortable: true, // enable column sorting multiselect: true, // enable multiselct gridview: true, pager: $('#productPager'), viewrecords: true, loadui: 'block', emptyrecords: 'Nothing to display', loadComplete: function () { var gd = $('#productGrid'); //fixGridSize(gd); } }); 

Examples of data returned from the endpoint. (you can clean a little)

 {"total":131,"page":1,"records":13051,"rows":[{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","24.42","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","26.26","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.5","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","24.92","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","26.39","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","24.48","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","24.75","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.43","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.61","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.87","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.06","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.37","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","26.51","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.24","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.65","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.34","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.27","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","26.11","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","26.19","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","24.81","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.76","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.62","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.49","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.81","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":1326807001,"cell":["","1","X~X~X~X~X~X~X~X","5522479","LABELLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.99","CA","20 PK","1 LB","20 LB","1326807001"]},{"id":2047556844,"cell":["","1","X~X~X~X~X~X~X~X","6706700","","2 LT OP PEND PB 6103-34E###","BE National Catalog","135.5","EA","1","","","2047556844"]},{"id":2047557330,"cell":["","1","X~X~X~X~X~X~X~X","6935200","","PENDANT 17 1/4in. 1LT SIENNA FINISH","BE National Catalog","177.51","EA","1","","","2047557330"]},{"id":2047557264,"cell":["","1","X~X~X~X~X~X~X~X","6924100","","5LT PEND PLAT FRST WHT ALBSTR GL","BE National Catalog","111.5","EA","1","","","2047557264"]},{"id":2047557039,"cell":["","1","X~X~X~X~X~X~X~X","6765700","","MOUNTING BRKT FOR 2 MINI PENDS WHT","BE National Catalog","15.28","EA","6","","","2047557039"]},{"id":2047554940,"cell":["","1","X~X~X~X~X~X~X~X","2288300","","4\u0027 PENDANT CORD SET WHT","BE National Catalog","14.37","EA","50","","","2047554940"]},{"id":4350187308,"cell":["","1","X~X~X~X~X~X~X~X","7827530","PENNANT","DOUGH ROLL VIENNA","Sysco Products Catalog","41.3","CA","216 PK","2 OZ","27 LB","4350187308"]},{"id":4350187308,"cell":["","1","X~X~X~X~X~X~X~X","7827530","PENNANT","DOUGH ROLL VIENNA","Sysco Products Catalog","39.94","CA","216 PK","2 OZ","27 LB","4350187308"]},{"id":2047556653,"cell":["","1","X~X~X~X~X~X~X~X","6682100","","1LT OUTDR PEND BLK CST AL FRST GLS","BE National Catalog","19.53","EA","6","","","2047556653"]},{"id":4284822563,"cell":["","1","P~X~X~X~X~X~X~X","DA7671","Lawson Products","(qty 3) Open & Shut Bolt Loose","BE National Catalog","25.77","CS","1","","","4284822563"]},{"id":1746213061,"cell":["","1","P~X~X~X~X~X~X~X","595671","","X-Acto(R) By Boston(R) School Pro(TM) Electric Pencil Sharpener","BE National Catalog","42.74","EA","","","","1746213061"]},{"id":3012148986,"cell":["","1","P~X~X~X~X~X~X~X","CEB34X36","","Tape, Magic, 19mm x 33m, refill","Staples\\Corporate Express - Canada","1.11","EA","1","","","3012148986"]},{"id":2263809510,"cell":["","1","P~X~X~X~X~X~X~X","593785","","Sanford(R) Uni-Ball(R) Signo Gelstick(TM) Pens, 0.7 mm, Medium Point, Blue Barrel, Blue Ink, Pack Of 12","BE National Catalog","6.23","DZ","","","","2263809510"]},{"id":3083479466,"cell":["","1","P~X~X~X~X~X~X~X","MDS131020","","PENLIGHT,DISPOSABLE,6/PK","MEDLINE - WIST","9.98","PK","6","","","3083479466"]},{"id":3083479466,"cell":["","1","P~X~X~X~X~X~X~X","MDS131020","","PENLIGHT,DISPOSABLE,6/PK","MEDLINE - SMGT","7.69","PK","6","","","3083479466"]},{"id":3083479466,"cell":["","1","P~X~X~X~X~X~X~X","MDS131020","","PENLIGHT,DISPOSABLE,6/PK","MEDLINE - THS","3.93","PK","6","","","3083479466"]},{"id":3083479466,"cell":["","1","P~X~X~X~X~X~X~X","MDS131020","","PENLIGHT,DISPOSABLE,6/PK","MEDLINE - LSSM","8.44","PK","6","","","3083479466"]},{"id":3083479466,"cell":["","1","P~X~X~X~X~X~X~X","MDS131020","","PENLIGHT,DISPOSABLE,6/PK","MEDLINE - WALKER","7.78","PK","6","","","3083479466"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.48","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.48","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","20.33","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","17.98","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.48","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","20.82","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.48","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.48","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","17.98","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.15","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.03","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","17.98","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.15","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","25.81","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","20.82","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.73","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.48","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","22.02","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":1769105211,"cell":["","1","X~X~X~X~X~X~X~X","7967946","BARILLA","PASTA PENNE RIGATE","Sysco Products Catalog","21.78","CA","2 PK","10 LB","20 LB","1769105211"]},{"id":3868776945,"cell":["","1","X~X~X~X~X~X~X~X","23371","","SLOAN 601 PENAL VALVE,6-3/4\"L","BE National Catalog","227.73","EA","","","","3868776945"]},{"id":1771696671,"cell":["","1","P~X~X~X~X~X~X~X","BICMM11","","Pen, Ball point, Retractable, Medium, 4colour","Staples\\Corporate Express - Canada","3.28","EA","1","","","1771696671"]},{"id":1771702789,"cell":["","1","P~X~X~X~X~X~X~X","PENBLN15A","","Pen, Roller, ENERGEL, .5mm, Black","Staples\\Corporate Express - Canada","2.5","EA","1","","","1771702789"]},{"id":1771703397,"cell":["","1","P~X~X~X~X~X~X~X","SAN60143","","Pen, Uniball, Onyx, .7mm, Black","Staples\\Corporate Express - Canada","0.93","EA","1","","","1771703397"]},{"id":1771703401,"cell":["","1","P~X~X~X~X~X~X~X","SAN60152","","Pen, Uniball, Micro, .5mm, Red","Staples\\Corporate Express - Canada","1.65","EA","1","","","1771703401"]},{"id":1771703921,"cell":["","1","P~X~X~X~X~X~X~X","STD51163","","Sharpener, Pencil, Noris, Plastic","Staples\\Corporate Express - Canada","3.75","EA","1","","","1771703921"]},{"id":1777244009,"cell":["","1","P~X~X~X~X~X~X~X","149039","","Prismacolor(R) Col-Erase(R) Pencils, Blue, Box Of 12","BE National Catalog","9.49","BX","","","","1777244009"]},{"id":2047557554,"cell":["","1","X~X~X~X~X~X~X~X","6984100","","1LT PEND (DM) WRM GLD SCAVO GLS","BE National Catalog","27.45","EA","4","","","2047557554"]},{"id":3868776906,"cell":["","1","X~X~X~X~X~X~X~X","23675","","SLOAN 611 PENAL VALVE,9-3/4\"L","BE National Catalog","303.58","EA","","","","3868776906"]},{"id":2847053310,"cell":["","1","X~X~X~X~X~X~X~X","39834","PENNANT","PASTRY DGH PUFF WHI","AFI Foodservice","46.67","CS","2","15 LB","31.00 LB","2847053310"]},{"id":2028575199,"cell":["","1","X~X~X~X~X~X~X~X","HP16918","","HENNY PENNY ORIFICE","BE National Catalog","23.77","EA","1","","","2028575199"]},{"id":2263805248,"cell":["","1","P~X~X~X~X~X~X~X","527056","","Pilot(R) Dr. Grip(TM) Center Of Gravity Ballpoint Pen, 0.7 mm, Medium Point, Pink Metallic Barrel, Black Ink","BE National Catalog","5.69","EA","","","","2263805248"]},{"id":2263825833,"cell":["","1","P~X~X~X~X~X~X~X","863200","","Paper Mate(R) Write Bros. Grip Ballpoint Stick Pens, 1.0 mm, Medium Point, Red Barrel, Red Ink, Pack Of 12","BE National Catalog","1.79","DZ","","","","2263825833"]},{"id":1735210354,"cell":["","1","P~X~X~X~X~X~X~X","907336","","Sanford(R) Uni-Ball(R) Vision(TM) Liquid Ink Rollerball Pens, 0.7 mm, Fine Point, Gray Barrel, Blue Ink, Pack Of 12","BE National Catalog","14.66","DZ","","","","1735210354"]},{"id":2559697016,"cell":["","1","X~X~X~X~X~X~X~X","810360","DE CECCO","PASTA PENNE RIGATE #41 OU","Ace Endico","28.24","CS","20/1 LB","","24","2559697016"]},{"id":4354802160,"cell":["","1","P~X~X~X~X~X~X~X","CARNGXDIS-235","","GOODKIND PEN-WOODY","BE National Catalog","3.55","EA","1","","","4354802160"]},{"id":2795617689,"cell":["","1","X~X~X~X~X~X~X~X","158303","","03259 PROF LINE FEBREZE RTU DEEP PENETR 945ML@8 ","Unisource - Canada","63.56","CS","8","","","2795617689"]},{"id":3098309987,"cell":["","1","P~X~X~X~X~X~X~X","44354","","TRAY SCHOOL PENNY-SAVER NAVY BLUE 10X14","BE National Catalog","88.5","CS","24","","","3098309987"]},{"id":3150562359,"cell":["","1","P~X~X~X~X~X~X~X","2757WPEN","","WESTIN KIDS COLORED PENCILS","BE National Catalog","98.36","CA","144","","","3150562359"]},{"id":3150562359,"cell":["","1","P~X~X~X~X~X~X~X","2757WPEN","","WESTIN KIDS COLORED PENCILS","Canadian Hotel Supply","111.61","CA","144","","","3150562359"]},{"id":3161067816,"cell":["","1","P~X~X~X~X~X~X~X","NONHCR3710C","","LINER,CLEAR,30X37,10 MIC,30 GAL,25/RL","MEDLINE - WIST","28.11","CS","500","","","3161067816"]},{"id":3161067816,"cell":["","1","P~X~X~X~X~X~X~X","NONHCR3710C","","LINER,CLEAR,30X37,10 MIC,30 GAL,25/RL","MEDLINE - EBY","22.77","CS","500","","","3161067816"]}]} 
0
source

It seems like I'm trying to make impossible with jqgrid: http://www.trirand.net/forum/default.aspx?g=posts&m=8186

If anyone thinks this is possible, let me know. :-)

I assume that I will have to create my own layout for my script with 1 entry. Not a big deal.

0
source

You open the edit form in the loadcomplete grid and then hide the grid.

You can move the grid from the browser screen using

  jQuery.extend(jQuery.jgrid.edit, { height: 1, width: 1, top:-100, left: -100 } ); 

after creating the grid, call its method in loadComplete to show the form:

 $("#edit_grid_top").click() 
0
source

Source: https://habr.com/ru/post/1398821/


All Articles