I am trying to get google sheets to trigger a onEdit script when a form is submitted by identifying when a column changes. I can type in the column and it triggers the script but when I have a form submit data to the column it does not trigger. Any ideas. Here is the script I’m running: function onEdit(e) { var langName = ‘ADVISOR INFORMATION’ var langCell = ‘C2’ var curSheet = e.range.getSheet() if (curSheet.getName() === langName) { if (e.range.getA1Notation() === langCell) { var cookingMethodSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘APPOINTMENTS’) var range = cookingMethodSheet.getRange(‘D2:N2’) range.clear() } } }

Hi Joe, is this the problem? [image] onEdit() script won't run when sheet is edited by Glide app Hi Rogelio, As I have discussed here, onEdit() won’t work with Glide. Change it to onChange(), or trigger the event by an “on change” option in the triggers dashboard.

The problem with onChange() is that it would be performed everytime something in the workbook is changed not just the sheet the forms are submitted to. Unless I’m mistaken and you can do a onchange with just a single sheet

Wrap a further IF to make sure it only triggers for a certain sheet. For example: function sendEmail(e) { var Active = e.source.getActiveSheet().getName(); if(Active == 'SheetA'){

What I meant to say is that I don’t think it’s possible to setup onChange to just look at one tab and not the entire workbook/sheet.

Yeah I understood that. You can try my method above, wrap an IF so that it is only triggered when the active sheet is the sheet of your choice.

Taking my original script above could you try to modify it with on change and I can see if it works.

function ClearRows(e) { var Active = e.source.getActiveSheet().getName(); if(Active == ‘ADVISOR INFORMATION’){ var langCell = ‘C2’ if (e.range.getA1Notation() === langCell) { var cookingMethodSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘APPOINTMENTS’) var range = cookingMethodSheet.getRange(‘D2:N2’) range.clear() } } } } Can you try this and tell me if it works?

I’m sorry. I live in the states and it got so late I just took another stab at it and got it working then went to bed. This is the script I made that got it to work though: function onChange(e) { var sheet = e.source.getActiveSheet() if (sheet.getName() === ‘ADVISOR INFORMATION’) { var cookingMethodSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘APPOINTMENTS’) var range = cookingMethodSheet.getRange(‘D2:N2’) range.clear() } } Thank you for your help and your time.

No worries, have a nice Sunday yourself. Now my time to go to bed, it’s 11pm in Vietnam :smile:

It’s pretty much identical to be honest…I just eliminated a variable. And I needed it to check the entire page, I used that variable for testing. That’s the only reason I had it on there.

Form Submit Not Triggering Google Scripts

Ask for Help

ThinhDinh June 21, 2020, 5:01am 2

Hi Joe, is this the problem?

Topic		Replies	Views
onEdit() script won't run when sheet is edited by Glide app Ask for Help	27	7097	July 17, 2020
Script is not working Ask for Help	7	582	April 29, 2021
Trigger script onEdit event from App Ask for Help	14	5355	September 23, 2022
Google Sheets built-in "On form submit" trigger Ask for Help	61	7179	January 26, 2021
OnChange trigger Ask for Help	29	7539	January 3, 2022

Form Submit Not Triggering Google Scripts

Related topics