xxxxxxxxxx
//Edit a record
function edit_rec() {
console.log('Edit Function invoked');
let name_update = field_name.name.value;
let surname_update = field_name.surname.value;
let email_update = field_name.email.value;
console.log('The database is going to be updated with ', name_update, surname_update, email_update);
ZOHO.CREATOR.init().then(function (data) {
formData = {
data: {
f_Name: name_update,
l_Name: surname_update,
Email: email_update
}
};
let config = {
reportName: 'All_Visitors',
id: ID_GLOBAL,
data: formData
};
ZOHO.CREATOR.API
.updateRecord(config)
.then(function (response) {
console.log('Response code received from Zoho: ', response.code);
if (response.code == 3000) {
console.log('Response data received from Zoho: ', response);
alert('Record updated successfully');
get_all_recs();
reset_the_form();
}
})
.catch(function (data) {
alert(data.responseText);
console.log('Boss, we have a little problem');
console.log(data.responseText);
reset_the_form();
});
});
}
xxxxxxxxxx
//Adding a new record
function add_new_rec() {
console.log('Invoking add new');
ZOHO.CREATOR.init().then(function (data) {
let add_Name = field_name.name.value; //First name
let add_Surname = field_name.surname.value; //Last name
let add_Email = field_name.email.value; //Email
let form_n = 'Visitors';
formData = {
data: {
f_Name: add_Name,
l_Name: add_Surname,
Email: add_Email
}
};
console.log(formData);
let config = {
formName: form_n,
data: formData
};
ZOHO.CREATOR.API
.addRecord(config)
.then(function (response) {
console.log('Adding record...');
console.log(response);
if (response.code == 3000) {
console.log('Record added successfully');
alert('Record updated successfully');
console.log(response.data.ID);
reset_the_form();
get_all_recs();
}
})
.catch(function (data) {
alert(data.responseText);
console.log('Boss, we have a little problem');
console.log(data.responseText);
reset_the_form();
});
});
}