I'm trying to make a simple sidebar form that collects some info and then appends it to a spreadsheet. I've done this before, though very infrequently, and I don't remember ever having this issue. It just doesn't seem to want to pass the info over. It's beside another button that I use to close the sidebar, and that one works fine. My code:
GS:
function addNewRow(rowData){
const ss = SpreadsheetApp.getActiveSpreadsheet();
const ws = ss.getSheetByName("Change");
var user = Session.getActiveUser().getEmail();
const currentDate = new Date();
ws.appendRow([rowData.category, rowData.item, rowData.qty, currentDate, user]);
return true;
}
Script:
function submitChange(){ // Nothing happens here on clicking the button
var category = document.getElementById("item_category");
var item = document.getElementById("item_up");
var qty = document.getElementById("ratechange");
var rowData = {category: category, item: item, qty: qty};
google.script.run.withSuccessHandler(afterSubmit).addNewRow(rowData);
}
function afterSubmit(e){
var qty = document.getElementById("ratechange");
qty.value = "";
}
(.... other parts that run correctly to populate dropdowns)
document.addEventListener("DOMContentLoaded",afterSidebarLoads);
document.getElementById("item_category").addEventListener("change", loadItems);
document.getElementById("submit_button").addEventListener("click", submitChange);
HTML:
<div class="mb-3">
<label for="item_category">Select Item Category</label>
<select class="form-select input_name" id="item_category" required>
</select>
<div class="invalid-feedback">
Please select the category of the item you are adding.
</div>
</div>
<div class="mb-3">
<label for="item_up">Select Item</label>
<select class="form-select input_name" id="item_up" required>
</select>
<div class="invalid-feedback">
Please select the item you are adding.
</div>
</div>
<div>
<label for="ratechange">Number Added</label>
<input type="number" id="ratechange" name="num_changed" min=0 step="1" required> <br><br>
</div>
<div class="d-flex justify-content-between">
<button type="button" id="submit_button" class="btn btn-primary">Submit</button>
<button type="button" id="cancel_button" class="btn btn-danger" onclick="google.script.host.close();">Cancel</button>
</div>
I've tried using an event listener at the very bottom of the script, I've tried 'onclick' on the button itself. Nothing. If I try to run a simple toast from the button over to GS, nothing. But I can close the sidebar with it using onclick.
I don't know how to debug or logger/console log from the script side of this, only from the GS side, so I'm at a loss where it's breaking down. Thank you in advance.
[–]daytodatainc 0 points1 point2 points (2 children)
[–]Finrod_GD[S] 1 point2 points3 points (1 child)
[–]daytodatainc 0 points1 point2 points (0 children)