Search

Thanks everyone for helping me through this. I have a working site now thanks to help that all of you have given.

Hi, Many thanks for flagging this up. There is an error in Editor on it's handling of updating field options when the Ajax request is cancelled. I've got the fix committed locally and it will be in 2.1.1 which I expect to drop either later this week or early next. If you edit your source version of Editor, the fix is in _optionsUpdate. It should check for json as well as json.options. Allan

Nice one - thanks for sharing your solution with us. Allan

Did you look at the examples for either option? The row display will be different than what you depict above. Will either solution display in a way that is workable for you? If you want help with an example then please start with a test case that has an example of your data and data structure. Also tell us which example you want to use to start form. https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case Kevin

hi @adrianChallinor Why not use .def, so if user do not wand to validate record, nothing is done portEditor.on('preOpen', function(e, mode, action) { if (action == "create") { var selected = voyageTable.row( { selected: true } ); var qty = selected.data().voyage.quantity; portEditor.field("quantity").def(qty); } }); Else to set value use .val portEditor.on('preOpen', function(e, mode, action) { if (action == "create") { var selected = voyageTable.row( { selected: true } ); var qty = selected.data().voyage.quantity; portEditor.field("quantity").val(qty); } });

It is very similar: var response = new Editor(Db, "users") .Field(new Field("users.first_name")) .Field(new Field("users.last_name")) // ... .LeftJoin( "sites", "sites.id", "=", "users.site" ) .Where("site", request.Form["site"]) .Process(request) .Data(); return Json(response); See the .NET documentation for more details. You might also want to add the wrapper if condition with request.Form.AllKeys.Contains("site"). Regards, Allan

I've tried this, but nothing happens. Only borders dissapear, but width not calculate properly

Yep, good spot. It's mistake on the page. It was corrected in the final code - see the link at the bottom of the blog post. I'll update the blog post - thanks for pointing out. Colin

Thanks for that. I've updated the page, and it'll be pushed on the next site build, Colin

New thread at https://datatables.net/forums/discussion/60910/dependant-selects#latest