I built a simple script to clear the content of two columns on two different sheets: function clearFormEntries() { // Activate 2nd sheet [Team] and delete G2:G [CHECKLIST] var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); SpreadsheetApp.setActiveSheet(spreadsheet.getSheets()[1]); …

This might seem non-intuitive, but when Glide adds a new row, the changeType will be EDIT (not INSERT ROW) EDIT: Actually, I should qualify that. In actual fact, when Glide adds a new row the changeType could be EDIT, or it could be INSERT ROW. Which depends on whether or not there are any empty ro…

Here is a bit of code I grabbed from one of my tests that may help. // create a Google App Trigger for this function // go to Edit/Current project's triggers. Add an OnChange trigger that runs this function // it will increment the value in sheet Counter cell A2 every time this function runs functi…

3 ticks before code and 3 ticks after…What is symbol for the tick?

On my Macbook keyboard it is in the upper left corner. ` shift of it is a ~

New challenge. Sheet has many records, but my app will let the user check a box on a particular record for a particular column. Eg, Task is now complete, check the box. After user checks the box, I want to pull data from that row and send emails and SMS based on field values in the row. I looked …

I assume you can still use an on change trigger, take out the row number of the row which triggers the script and use those values to send an email/SMS. You can use Zapier/Integromat to do the same thing with emailing/Twilio.

Yes, I have it working with Zapier/Twilio but there is a 2-3 minute lag. It’s the lag that is driving me to want the GAS to work.

[image] gp9293: New challenge. Sheet has many records, but my app will let the user check a box on a particular record for a particular column. Eg, Task is now complete, check the box. After user checks the box, I want to pull data from that row and send emails and SMS based on field values in t…

Google Sheets built-in "On form submit" trigger

Ask for Help

gp9293 December 29, 2020, 6:32pm 19

Special thanks to George B and Darren. I was able to get my script to work and only trigger when a new row is added. You guys are great.

Topic		Replies	Views
OnChange trigger Ask for Help	30	7293	January 17, 2024
Scripts, scripts, scripts! Ask for Help	240	10510	January 4, 2022
New Row in Spreadsheet for Every User Ask for Help	53	3563	January 27, 2024
Notification (email) when forms submitted Ask for Help	47	5493	July 30, 2021
How to write google sheet script so only latest timestamped forms record if duplicate is the only record? Ask for Help	17	2330	October 9, 2021

Google Sheets built-in "On form submit" trigger

Related topics