Hi I have written a script which needs to run when ever user enter new data. Pl let me know how to achieve that.

Hello I cannot recover data with onEdit (e). All of my data seems undefined. Could you give me a sample code that works to inspire me thanks in advance function onEdit(e) { var range = e.range; Logger.log("currentRange"+ range) Logger.log("currentSource"+ e.source) Logger.log("value"+ e.va…

As you can see from the post above, the onEdit(e) event trigger does not work with Glide, only the onChange(e) trigger does.

Thank you do you have a little bit of code to find out which cell has been modified?

Simply change the name of function to onChange(e) and assign spreadsheet trigger. Now your code will work with Glide.

Thank you It is exactly what i do but range is undefined as e.source or e.oldvalue Can you help me [Capture d’écran 2020-04-24 à 16.05.50]

The (e) will not return specific cell information, only these triggers: changeType The type of change ( EDIT , INSERT_ROW , INSERT_COLUMN , REMOVE_ROW , REMOVE_COLUMN , INSERT_GRID , REMOVE_GRID , FORMAT , or OTHER ).

Ok but How to know that cell changed ??

Glide does not pass that to your spreadsheet. You’ll need to write a script that captures that something in the whole spreadsheet has changed, whether it’s adding or removing a row or column or any of the triggers I mentioned above. Then in the script, you’ll reference a change that may be different…

function trailerDelete(e) { //This is the onChange(e) trigger var app = SpreadsheetApp; var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var targetSheet = app.getActiveSpreadsheet().getSheetByName(“Report”); // You can replace “Report” in the above line, to the sheet that you …

You may use getActiveCell() to identify the cell where modifications done. But one thing, for simple editing purposes you do not require all this information. Glide will automatically edit current row.

Trigger script onEdit event from App

Ask for Help

Mrinal_Chakraborty April 11, 2020, 2:07pm 2

I have solved this issue with onChange(e)

Time stamp update

Topic		Replies	Views
onEdit() script won't run when sheet is edited by Glide app Ask for Help	27	6957	July 17, 2020
OnChange trigger Ask for Help	29	7309	January 3, 2022
Script is not working Ask for Help	7	536	April 29, 2021
Using onEdit(e) with GlideApps Ask for Help	3	804	April 24, 2020
Form Submit Not Triggering Google Scripts Ask for Help	14	2801	June 21, 2020

Trigger script onEdit event from App

Related topics