I need to use a sidebar to get some variables and print then in the last line of a sheet, using AppScript. So, I was trying to use this code:
Sidebar.HTML
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<p>Name: <input type="text" name="txtName" /></p>
<p>Date: <input type="text" name="txtDate" /></p>
<p>Value: <input type="text" name="txtValue" /></p>
<button onclick="doSomething()"> submit </button>
<script>
function doSomething() {
google.script.run.withFailureHandler(myFunction(document.getElementById("txtName", "txtDate", "txtValue").value))
}
</script>
</body>
</html>
Code.js
function myFunction(name = "", date = "", value = "") {
var ss = SpreadsheetApp.getActive()
var sheet = ss.getSheetByName("1")
var lr = sheet.getLastRow() + 1
sheet.getRange(lr, 1).setValue(name)
sheet.getRange(lr, 2).setValue(date)
sheet.getRange(lr, 3).setValue(value)
}
function openDialog() {
var html = HtmlService.createHtmlOutputFromFile("Sidebar");
html.setTitle("Form");
SpreadsheetApp.getUi().showSidebar(html);
}
But it don’t worked. When I click on the button nothing happen. I’m new in HTML, so, what can I do to fixit?