lwc:google_api:html_interface [wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

===== HTML interface for Google Sheets: =====

(see examples in "script tests")

  * [[http://www.javascript-spreadsheet-programming.com/2013/05/html-service-basics-write-form-data-to.html|this example]] shows how to add content from an html interface. In the example they add rows based on input fields in html
  * [[http://www.javascript-spreadsheet-programming.com/2015/04/using-google-spreadsheet-named-ranges.html|read google sheet to get dropdown options and]]and [[https://github.com/Rotifer/SpreadsheetToHtmlSelect|here is the code]]
  * there's a [[https://leanpub.com/googlespreadsheetprogramming|good book]] on this and here is the[[https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015/blob/master/ch07.html|code for the book]]\\


==== Using Bootstrap: ====

make layouts [[http://www.layoutit.com|here]]

it appears (?) you need https to load external files?

before </head>: <link rel="stylesheet" href="https:%%//%%maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css">

before </body>:

  * <script src="https:%%//%%ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
  * <script src="https:%%//%%maxcdn.bootstrapcdn.com/bootstrap/3.3.2/js/bootstrap.min.js"></script>\\
</body>

reference: http:%%//%%stackoverflow.com/questions/27863416/can-bootstrap-js-be-used-in-gas-google-apps-script\\


\\
\\