I want to make notification to user when item in database decrease to limit value. Anyone can advice me.

Anyone please advice me how to make confirm popup.

I need to update DB by used ID "code" to query and then update only "value" field, but it not any update in DB when i try .save it always insert not update. anyone can help me fix it. import wixData from 'wix-data'; export function button1_click(event) { let values; const inID = $w('#idSe').value; const inValue = parseInt($w('#input1').value, 10); wixData.query("ChamokInventory") .eq("code", inID) .find() .then((results) => { values = results.items[0].value; let sum = inValue + values; let newupdate = { "code": inID, "value": sum, }; if (inValue > 0) { const alert = $w('#errorText').hide(); wixData.update("ChamokInventory", newupdate) //update only "value" field .then((results2) => { let item2 = results2; const alertSuc = $w('#succMsg').show(); }) .catch((err) => { let errorMsg = err; }); } else { const alert = $w('#errorText').show(); } console.log(values);; }); // } when i try let toUpdate = { "code": inID, "value": inValue, "title":"a", "unit":"ab", "type": "abc" };

I need to use result from query only 'value' field and use it to calculate with input value 'input1'. how to do it. import wixData from 'wix-data'; export function button1_click(event) { const inID = $w('#idSe').value; const inValue = $w('#input1').value; let toInsert = { "code": inID, "value": inValue }; if (inValue > 0) { const alert = $w('#errorText').hide(); wixData.query("ChamokInventory") .eq("code", inID) .find() .then((results) => { console.log(results.items); // it show all data. i need only 'value' field. //and use it to calculate with input1. }); wixData.insert("ChamokInventory", toInsert) .then((results) => { let item = results; //see item below const alertSuc = $w('#succMsg').show(); }) .catch((err) => { let errorMsg = err; }); } else { const alert = $w('#errorText').show(); } }

This is my code in Update button. I need to use input from textbox ID to search update location and textbox Value to increased value in DB.  export function button1_click(event) { // ... let toInsert = {   "ID":          "C003",   //how to get input from textbox.   "value":    10             //how to increased value in DB such as DB has value 15 then i add 10 //DB must increased value to 25. }; wixData.insert("ChamokInventory", toInsert)     .then( (results) => {         let item = results; //see item below     } )     .catch( (err) => {         let errorMsg = err;     } ); }