Answers

• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  March 2016

  Yes, absolutely a DataTable can be used in a modal - however, there isn't a build in field type for that at the moment. I do have a prototype plug-in I can send you if you would like (is the e-mail address you used to register okay?). It hasn't been released yet as there are a few improvements I'd like to make to DataTables core to make the plug-in easier to use, but it does work well.

  Allan
• drewturk Posts: 27Questions: 8Answers: 0

  March 2016

  I would love to take a look at what you have. This email I registered with is great. It would be incredible if I could have an editable table inside an editor modal instance. Thanks Allan
• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  March 2016

  I could have an editable table inside an editor modal instance

  That is won't do (at least that isn't what it is intended for at the moment although it could possibly be hacked to do it). It is really designed as a row selector. Do you still want to see that?

  Allan
• drewturk Posts: 27Questions: 8Answers: 0

  March 2016

  I guess I would have to see it to understand more fully what you mean by "row selector". So, yes please, I would like to see what it can do and if it's even what we want or need. Thanks.
• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  March 2016

  Basically the current goal is to display a DataTable in place of a select list. That presents a number of nice display options for the user to be able to select the data from.

  I've just sent it over.

  Allan
• drewturk Posts: 27Questions: 8Answers: 0

  March 2016

  Thanks, but what I am really working toward is being able to open a modal dataTable using the data from a specific column.

  This column data will be an array of objects, and is therefore why I am hoping I can display this column data in a modal as a dataTable, and yet still allow inline edit of said modal/DataTable.

  Is this at all possible, with the current library?
• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  March 2016

  I don't see why it wouldn't be possible, but it isn't something that I've tried, and therefore there isn't an example of it.

  The first step would probably be to display the modal without using Editor (it sounds like you just want a modal with a DataTable in it). At that point the DataTable in the modal is just a regular DataTable, so you can do whatever you need with it, including inline Editing.

  Allan
• drewturk Posts: 27Questions: 8Answers: 0

  March 2016 edited March 2016

  Thanks Allan,
  I am wondering how to supply my column data for the new DataTable. Is there some way I can plug that column data into the data option for the new DataTable?

  for example, let's say I have a dataTable:

  var someDataTable = $("table").DataTable({
       ajax: "/somemodule/somecontroller/someaction",
       columns: [
              {
                  title: 'Name',
                  name: 'name',
                  data: 'name'
              },
              {
                  title: 'Values',
                  name: 'values',
                  data: 'values'
              }
          ]
      });
  

  And then for the new dataTable modal, plug in the column data into the data option?:

  var modalDataTable = $("modalTable").DataTable({
       data: someDataTable.column('values').data(),
       columns: [
              {
                  title: 'Value Name',
                  name: 'name',
                  data: 'name'
              },
              {
                  title: 'Value',
                  name: 'values',
                  data: 'values'
              }
          ]
      });
  

  So I am not sure if that is what I need or if there is more, like having to draw() the table once the modal is revealed. Either way, I am having a hard time getting my data to show in the modal.
• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  March 2016 Answer ✓

  You would actually just use data() or rows().data() for the above. The column().data() option will only give you a single column - it looks like you want both.

  You do need to be careful doing that though since DataTables will give you the original data object. So if you change it in the second, it would be changed in the first, but DataTables wouldn't know that. You probably want to take a copy of the data, which you could do with $.extend().

  Allan
• SNBCAS Posts: 2Questions: 0Answers: 0

  June 2016

  I, also, would love to see the plug-in you have in the works. It may be over my head, but it may be just what I need. Is this the appropriate place to ask for this?
• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  June 2016

  Sent you a PM :-)
• SNBCAS Posts: 2Questions: 0Answers: 0

  June 2016

  Thank you!
• Lucho_1312 Posts: 30Questions: 9Answers: 0

  July 2016

  Can I see the plug-in too? Thanks!
• Refael Raz Posts: 1Questions: 0Answers: 0

  September 2016

  I'd glad as well, also posted a request on your activity wall (or whatever it's called)
• ryanmark Posts: 1Questions: 0Answers: 0

  February 2017

  Can you help me, I'am struggling in finding a datatable with edit row in a modal, Do you have any idea sir?
• allan Posts: 64,894Questions: 1Answers: 10,747 Site admin

  February 2017 Answer ✓

  finding a datatable with edit row in a modal

  All of these examples provide row editing in a modal.

  Allan
• jrobins1 Posts: 1Questions: 0Answers: 0

  May 2017

  Allan,
  I know I'm a little late to the discussion, but if that plugin is still available could you send it? I have a similar situation as the above, namely a "Request" in a pre-submit state that is made up of a bunch of suggested fields that can be overridden in a Row/Col format before submitting. Perfect opportunity to use a datatable on the modal with inline editing. Thanks!