I don’t have anything to add in terms of advice, but just wanted to second that this is a problem I’m also having right now. My code has worked fine for weeks and still does in Preview mode, but now it suddenly doesn’t on the Published site
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;
})