How to get the onEdit event to to be caught in a Google Apps Script when editing a spreasheet via api? -
i have apps script captures onedit event when edit google spreadsheet cell manually, , applies various formatting changes based on change.
however, when edit same cell using google drive api, script doesn't seem run.
is there way trigger event via api can caught apps script? or other solution this?
publish web app:
it possible trigger google apps script code using url, i.e. google apps script editor menu->publish->publish web app. can pass id of cell parameter "web app". , have web app phone call onedit.
i suspect "google-spreadsheet-api" has no way this, basic things such "insert row in middle of sheet", don't exist.
google-apps-script google-spreadsheet google-drive-sdk google-spreadsheet-api
No comments:
Post a Comment