0

I've created a function in Google Script Editor that appends a row in Google Spreadsheet. Values being passed as parameters. Now, what I want to do is, call this function in my HTML page (built using UI Services, not HTML Services) and pass the values to be stored from this page. I cannot find a way. Pls help?

Mogsdad
  • 44,709
  • 21
  • 151
  • 275
user1926046
  • 1
  • 1
  • 2

2 Answers2

0

At the time you asked this question, the documentation was not very rich. It has improved considerably, and there are examples provided that are close to what you want to do.

With the UI Service, the way you would accomplish this would be by using a handler function, either client-side or server-side, which would be triggered by a button click (for example), and handle the submission of a "form" (a set of input text areas, etc.). The handler would call your storage function, passing the values returned from the form.

See the examples in the documentation links provided above.

If your web app used Html Services, you would have several options for calling server-side apps-script, see Html Service: Communicate with Server Functions. There are also numerous questions here that demonstrate this:

Community
  • 1
  • 1
Mogsdad
  • 44,709
  • 21
  • 151
  • 275
0

Short answer:

google.script.run.nameOfYourFunction();

Use this to call your function that is defined outside of the html file, from within the html file. Based on the docs

lenz
  • 2,193
  • 17
  • 31