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