Category "triggers"

e.source returns Spreadsheet instead of Form object?

I create google form 'on the fly' using data in spreadsheet. Also I install trigger on submit form event. ScriptApp.newTrigger('onSubmit') .forForm(form)

How to add username column into trigger in SQL Server for audit trail

My audit trigger,shown below, works great except that I am required to record who exactly made the change. As written the system user field was supposed to do t

How to check which Quartz Scheduler job is not running

I have below code which i have used to check which quartz scheduler job is running. And it also send me an email the list of running scheduler job. But i dont k

Run script on Sheet(tab) selection/change

I would like to know if there's a way to automatically trigger a script every time a specific sheet, inside a worksheet, is selected. Looking around I found the

google script detect empty cell after edit or delete

I have a problem with my code. It seems fine but it doesn't work and I really don't know why. I tried everything. I want sync my google excel with my google c

Postgres function to update old data and insert new data

I am trying to write a function that when my script pulls information from AD that it inserts new entries that don't exist and then update the ones that do exis

Show Alert Popup when cell selection is changed (onSelectionChange)

I am trying to show an alert popup when cell selection is changed, using the new trigger onSelectionChange. For some reason it is not showing any alerts. Am i d