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 at filters and loops, but feel like I am missing something conceptually. As always, guidance appreciated.
gp9293
20
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| OnChange trigger | 30 | 7293 | January 17, 2024 | |
| Scripts, scripts, scripts! | 240 | 10510 | January 4, 2022 | |
| New Row in Spreadsheet for Every User | 53 | 3563 | January 27, 2024 | |
| Notification (email) when forms submitted | 47 | 5493 | July 30, 2021 | |
| How to write google sheet script so only latest timestamped forms record if duplicate is the only record? | 17 | 2330 | October 9, 2021 |