alasql | JavaScript SQL database for browser and Node.js | SQL Database library

Firstly u need right import alasql

I do not know why my original method didn't work, but I have devised a work around.

My alternative to making a qaers table, and then selecting that table in a future query, is to make the table a JS array and then pass that into the query formatting it as a list.

This gives the proper result I am looking for, because it allows me to use the list of names and a WITH statement, which will be necessary as I make the query more complicated.

I believe your current situation and your goal as follows.

• You have 2 sheets in a Google Spreadsheet.
  • One is a sheet which has the sheet name of Base Sheet.
  • Another is a sheet which has the sheet name of Weight.
• When the value of "Order#" is removed from Base Sheet, you want to put a value of Yes to the column "C" of the same "Order#" in the sheet Weight.
• You want to run the script when the cell value is removed and the row is deleted.
• You want to achieve your goal using Google Apps Script.

In this case, I would like to propose to use the trigger as follows.

• For detecting the manually deleted cell value, the simple trigger of OnEdit is used.
• For detecting the manually deleted rows, the installable trigger of OnChange is used.

The sample script is as follows.

Please copy and paste the following script to the script editor of Google Spreadsheet. And, if you want to detect not only the manually deleted cell value, but also the manually deleted rows, please install the OnChange trigger to the function onEdit.

The function signature for d3.rollup is:

d3.rollup(iterable, reduce, ...keys)

Which on the face of it says you can provide one operation in reduce e.g. counting or summation or some other operation - but just one.

For your output, you're looking for two different operations

• counting the replies and edits, and
• an array operation to get post_ids where action == "edit"

As soon as you made the choice to use (x) => x.length you've kind of cut off the opportunity to use a different reduce operation. Arguably d3.rollup isn't the function you need if you have multiple operations?

Still you can add edited_post_ids to teacherSummary by simply reaching back into the original data and applying a filter then map:

You cannot invoke client side functions from the server, with the sole exception of the success or failure handler specified for a client-side-initiated call to a server function. Note that your server-side code cannot know which client side function was registered as the response handler, or even if there was one registered at all.

So no, you can't "just" call a .html-defined function from your .gs files.

Please review the HTMLService guide and API reference