I to everyone,
I am trying to create a query that modifies the data of two columns, but the various attempts seem not to work. Do you have any advice?
Thanks in advance as always
let today = new Date();
let code = $w("#dts1").getCurrentItem().myCode; // code for query wixData.query("didacticalServices") .limit(100) .eq("codeTeacher", code) .eq("typeService", "LABORATORY") .find() .then((res) => { let items = res.items; let item = items[0]; let dateEvent = $w("#eventDate").value; if (dateEvent < today) { for (var i = 0; i < expired.item.length; i++) { $w("#dts2").setFieldValues({ . // dataset where change row record "active": false, // field to change "status": "CLOSED", // field to change }) $w("#dts2").save(); } } })