make cell editable depending on value of another cell in the same row

[shawnParticipant]

I want to make a cell editable depending on value of another cell in the same row.

If the value of cell “linkORfile”===”file” then the cell “linkHref” it NOT editable. If “linkORfile”===”link” then it IS editable.
My code doesn’t work.

	          $("#eLinks").jqxGrid(
	          {
	              width: 800,
	              height: 200,
	              source: dataAdapter,
	              editable: true,
				        columns: [
				          { text: 'ID', datafield: 'lID',width: "7%",editable: false},
				          { text: 'link description', datafield: 'linkName',width: "29%",editable: true},
				          { text: 'HREF', datafield: 'linkHref',width: "28%",editable:true,
											cellsrenderer: function (row) {
                          var dataRecord = $("#eLinks").jqxGrid('getrowdata', row);		
													var FL=dataRecord.linkORfile;
													if(FL==="file"){														 
														 $("#eLinks").jqxGrid('endcelledit', row, "linkHref", false);
													}                         
                      }		
                  },    		          			
				          { text: 'type', datafield: 'linkORfile',width: "20%",editable: true, columntype: 'dropdownlist',	
											initeditor: function (row, cellvalue, editor) {
                          editor.jqxDropDownList({ source: dropdownListSource});
                      }
                  },            	
									{ text: 'save', datafield: 'edit', width: "8%",  columntype: 'button', 
										     cellsrenderer: function () {
		                     		return "Save";
		                  	}, buttonclick: function (row) { 
		                  		var dataRecord = $("#eLinks").jqxGrid('getrowdata', row);		  
		                  		clog(dataRecord.linkORfile);                		
		                  	}
		               },
									{ text: 'delete', datafield: 'delete', width: "8%",  columntype: 'button', 
										     cellsrenderer: function () {
		                     		return "Delete";
		                  	}, buttonclick: function (row) { 
		                  		var dataRecord = $("#eLinks").jqxGrid('getrowdata', row);		  
		                  		clog(dataRecord.linkORfile);                		
		                  	}
		               }			               				          
				        ]
	          });		

[shawnParticipant]

one other thing I’d like to do: If the value of the cell ‘linkORfile’ changes, I want to change the editable state of ‘linkHref’ as well.

How?

[HristoParticipant]

Hello shawn,

We have one similar theme, that will be helpful:
http://www.jqwidgets.com/community/topic/allow-cells-to-be-editable-only-under-specific-conditions/#post-52955
You could find more in our forum.

About second question you could use cellsrenderer member from columns property of the Grid.
Please, take a look this demo:
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/defaultfunctionality.htm?light

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Author]

Posts