Similar problem. Doesn’t write to custom collection in live mode. Works perfectly in Preview.
/**
- Adds an event handler that runs when the element is clicked.
Read more - @param {$w.MouseEvent} event
*/
export function submitRegistration_click(event) {
// This function was added from the Properties & Events panel. To learn more, visit Working with the Properties & Events Panel
// Add your code for this event here:
let occupant = $w(‘#firstName’).value + " " + $w(‘#lastName’).value;
let roomChoice = $w(‘#roomNumber’).value;
let bedChoice = $w(‘#bed’).value;
let roomItem = ;
console.log(occupant);
console.log(roomChoice);
console.log(bedChoice);
// get the room record
wixData.query('RoomAssignments').eq('title', roomChoice).find().then((results) => {
if(results.items.length > 0) {
console.log(results.items);
roomItem = results.items[0];
switch (bedChoice) {
case "queen":
roomItem.queenOccupant = occupant;
roomItem.queen = true;
break;
case "twin1Bed":
roomItem.twin1Occupant = occupant;
roomItem.twin1 = true;
break;
case "twin2Bed":
roomItem.twin2Occupant = occupant;
roomItem.twin2 = true;
break;
case "twin3Bed":
roomItem.twin3Occupant = occupant;
roomItem.twin3 = true;
break;
case "twin4Bed":
roomItem.twin4Occupant = occupant;
roomItem.twin4 = true;
break;
}
roomItem.roomFull = roomItem.queen && roomItem.twin1 && roomItem.twin2 && roomItem.twin3 && roomItem.twin4;
console.log(roomItem);
// This works fine in preview, but not on the published site
wixData.update('RoomAssignments', roomItem);
}
})
.catch((error) => {
let errorMsg = error.message;
let code = error.code;
})
}