Answers

• colin Posts: 15,142Questions: 1Answers: 2,586

  May 2020

  For instance, if the original row had a StartDate of January and no EndDate, once I create a duplicate with a StartDate of March, I need to update the original to have an EndDate of March.

  Are you updating to March as part of the duplication process? Or at some point in the future after duplicating?

  Also, have you limited the user to only duplicating a single record? Or can they duplicate many?

  Colin
• Lmtarbox Posts: 9Questions: 3Answers: 0

  May 2020 edited May 2020

  I'm updating as part of the duplication process. So the button opens the editor form and uses the create action like this ->

  {
                      extend: "selected",
                      text: 'Duplicate',
                      action: function (e, dt, node, config) {
                          // Start in edit mode, and then change to create
                          editor
                              .edit(table.rows({ selected: true }).indexes(), {
                                  title: 'Duplicate record',
                                  buttons: 'Create from existing'
                              })
                              .mode('create');
                      }
                  },
  

  When the editor window pops up, the user can make changes to any fields, and will add a StartDate as part of that process before clicking "Create from existing"

  I'm focusing on duplicating a single record right now.
• colin Posts: 15,142Questions: 1Answers: 2,586

  May 2020 Answer ✓

  This should here help you along. If the office field is changed from the original, then it gets updated in the duplicate. It's not quite the same as your requirements, but it demonstrates how the old and new records can be accessed and manipulated.

  Hope that does the trick,

  Colin