I have JS code that copies a record. It worked perfectly until I did a little database redesign where some of the fields being copied were moved to other tables. Any ideas what I need to do to get it working again?
Included is the code that worked. The three fields not copying are:
data.field_453 //Venue Name
data.field_527 //Customer Name
data.field_551 //Requestor Name
I’m not a coder by trade, I don’t know JS, and I’m winging it with everyone’s help. And y’all continue to provide wonderful support. Thank you.
$(document).on(‘knack-view-render.view_352’, function(event, view, data) {
// Do something after the view renders - copy button is on scene_33/views/view_352
console.log(data)
var duplicateData = {
field_9: data.field_9, //Group
field_11: data.field_11, //Event Start Time
field_12: data.field_12, //Event End Time
field_14: data.field_14, //Referral Source
field_16: data.field_16, //Type of Event
field_220: data.field_220, //Set Rate?
field_222: data.field_222, //Initial Contract/Negotiated Price
field_225: data.field_225, //Will Invoice?
field_239: data.field_239, //Terms
field_244: data.field_244, //Lead Owner
field_358: data.field_358, //Pieces
field_453: data.field_453, //Venue Name from Lookup of Venue Table
field_527: data.field_527, //Customer Name from Lookup of Customer Table
field_538: data.field_538, //Event Pre-Audit
field_551: data.field_551 //Requestor from Lookup of Requestor Table
}
// Add a button to execute the action
$(‘#’ + view.key).prepend(‘Copy Record’);
// Add the duplicate function to the button we just added
document.getElementById(‘copy-button’).addEventListener(‘click’, function () {
Knack.showSpinner();
$.ajax( {
// Change object here to match your record’s object #
url: ‘https://api.knack.com/v1/pages/scene_xx/views/view_xxx/records’,
type: ‘POST’,
headers: {
‘Authorization’: Knack.getUserToken(),
‘X-Knack-Application-Id’: Knack.application_id,
‘X-Knack-REST-API-Key’:‘knack’},
data: duplicateData,
success: function(response) {
alert(‘Record Copied! Find the record on New Records tab, add the new event date and set the status!’);
Knack.hideSpinner();
}
});
});
});