franklinokech/code.gs

## code.gs
/*
This function renders the html file
*/
function doGet(event){
  Logger.log(event);

  return HtmlService.createHtmlOutputFromFile('page');
}

function userClick(name){
  /*
  Now we want to save whatever the username the user inputs in the text box into a spreadsheet.
  First we have to store the spreadsheet into a variable by getting its id
  */
  var id="1beVqbhcXrDTUNDiqbgO9Q-VgXau6ixOOc03BMTNFCqM";//declare variable spreadsheet id
  var ss=SpreadsheetApp.openById(id);//get the spreadsheet by ID and store in the ss variable
  var wsName="Data";//Declare variable worksheet name
  var ws=ss.getSheetByName(wsName);//get the work sheet by the name declared above
  var currentTimeStampt=new Date();//create the currenttimestamp object from the Date Class

  ws.appendRow([name,currentTimeStampt]);//rowContent is a one dimentional array. The Username get appended to the row in workbok

}

## page.html
<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>


    <h1>Hello</h1>
    <input type="text" id="username"/>
    <button id="btnRunIt">Run It</button>

    <script>
    document.getElementById('btnRunIt').addEventListener('click',doStuff);

    function doStuff(){

    var uname=document.getElementById('username').value;//get the value the user input in the textbox

      google.script.run.userClick(uname);//run server side function
      document.getElementById('username').value='';//set the value of textbox to null after running
    }
    </script>

  </body>
</html>
	/*
	This function renders the html file
	*/
	function doGet(event){
	Logger.log(event);

	return HtmlService.createHtmlOutputFromFile('page');
	}

	function userClick(name){
	/*
	Now we want to save whatever the username the user inputs in the text box into a spreadsheet.
	First we have to store the spreadsheet into a variable by getting its id
	*/
	var id="1beVqbhcXrDTUNDiqbgO9Q-VgXau6ixOOc03BMTNFCqM";//declare variable spreadsheet id
	var ss=SpreadsheetApp.openById(id);//get the spreadsheet by ID and store in the ss variable
	var wsName="Data";//Declare variable worksheet name
	var ws=ss.getSheetByName(wsName);//get the work sheet by the name declared above
	var currentTimeStampt=new Date();//create the currenttimestamp object from the Date Class

	ws.appendRow([name,currentTimeStampt]);//rowContent is a one dimentional array. The Username get appended to the row in workbok

	}
	<!DOCTYPE html>
	<html>
	<head>
	<base target="_top">
	</head>
	<body>


	<h1>Hello</h1>
	<input type="text" id="username"/>
	<button id="btnRunIt">Run It</button>

	<script>
	document.getElementById('btnRunIt').addEventListener('click',doStuff);

	function doStuff(){

	var uname=document.getElementById('username').value;//get the value the user input in the textbox

	google.script.run.userClick(uname);//run server side function
	document.getElementById('username').value='';//set the value of textbox to null after running
	}
	</script>

	</body>
	</html>