jquery – JSON – Import Google Sheets – Protect Formula or Specific Row
with the following code and the combination of sheety.co I would like to set the row of the column “lager” to 1. But formulas in the row are overwritten. Can I prevent this or make the changes only in the column? e.g. change only in column “A”.
function amlagerItems(id) {
let product = this.products.find(product => {
return product.id == id;
});
product.lager = 1;
let headers = new Headers();
headers.set('content-type', 'application/json');
fetch(projectUrl + '/products/' + id, {
method: 'PUT',
body: JSON.stringify({ product: product }),
headers: headers
});
showAllItems();
}
Read more here: Source link